LinkedIn Interview Question

Interviewer asked me SQL questions involving group by, aggregate functions and multiple join questions.