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
Get empowered with IBM Power
