How to solve sql task?

Question

MySQL

I have never worked with pure sql, so I don't know how to solve it. There are two tables in the database:

you need to display 3 employees (together with names) who have the most hours in total.
Thanks in advance.

Answer 1

SELECT
  e.name, SUM(t.hours)
FROM 
  employees e
    JOIN time_reports t ON t.employee_id = e.id
GROUP BY e.id, e.name
ORDER BY 2 DESC
LIMIT 3

Answer 2

select name, sum(hours) hours
from names and
left join time t
on id = t.employ_id
group buy t.emploi_id
order buy hours desk limit 3
something like this...

Answer 3

SELECT employees.name, SUM(time_reports.hours) as hours
FROM time_reports 
LEFT JOIN employees ON time_reports.employee_id = employees.id
GROUP BY time_reports.employee_id
ORDER BY hours DESC
LIMIT 3