SQL 101: DML Recap-Some Handy Column Functions, Part 2

​It saved you hours of writing intermediate queries and complicated joins (by the way, here are a couple of refreshers about table joins, if you need them), but the result is most unfortunate: a very long number with loads and loads of decimal places.
To answer this question, we’ll need to list the teacher rank, which is a column of the teachers table, and two functions (a count of the teachers per rank and their average salary). Read More 

Verified by MonsterInsights