Coderbyte SQL member count solution
Free sample test question
SELECT ReportsTo,count(id) as Members,round(avg(age)) as `Average Age`FROM maintable_R70YEwhere ReportsTo is not null group by ReportsToorder by ReportsTo asc
SELECT ReportsTo,count(id) as Members,round(avg(age)) as `Average Age`FROM maintable_R70YEwhere ReportsTo is not null group by ReportsToorder by ReportsTo asc