<prompt> Kujenga query mySQL ambayo anapata juu wafanyakazi watatu kutoka kila idara ili kwa uzoefu.  <response>: To create a mySQL query that gets the top three employees from each department ordered by experience, you must use the the DENSE_RANK , WHERE, and ORDER BY statements. You would replace employees with the name of the table and dept_name, experience, and emp_name with the column names for the department, experience, and employee name :SELECT dept_name, emp_name, experienceFROM SELECT dept_name, emp_name, experience, DENSE_RANK OVERPARTITION BY dept_name ORDER BY experience DESC as rank FROM employees as sub_queryWHERE sub_query.rank 3ORDER BY dept_name, experience DESC; 