The school is **pleased with our work** and agrees to **continue the collaboration**. 

Now they have a new task for us. The **top 10 students with the highest average grades** will be offered a trip to a scientific center as a reward. One mandatory condition is receiving a **grade above 90 on the math exam**. To find such students, they have turned to you. 

Let's see what we need to do using our `employee` table as an example.

Suppose we need to find out in **which departments** there are employees who **were hired before 2019** and the **average salary** in those departments. To implement such a task, we can use the following query:








SELECT department, AVG(salary) AS average_salary
FROM employees
WHERE hire_date < '2019-01-01'
GROUP BY department

As you can see, there are only 3 such employees, and we used the necessary tools to achieve this result. 




This course is perfect for those who already have a basic understanding of SQL and want to delve into more advanced concepts to craft more powerful queries. Throughout the course, you will become familiar with data grouping and filtering grouped data. You will also learn how to work with multiple tables simultaneously, including how to combine them. Additionally, you will explore different types of table joins and how to apply them in practice.

Searching for the Top Math Students Challenge

解答