I’m confused on where to get the average salary for the entire data set on Query 8? In the practice video he gets all the average salary data but doesn’t actually produce a specific number.
1 Answers
I’m not sure if this is the answer you’re looking for, but you’ll need to use “SELECT AVG(*variable*)” and make sure you are using a FROM, JOIN, and WHERE that will gather the data you need to calculate the average. As long as your code follows this, it should output the correct average number.
Your Answer