intermediate
Generate SQL Query
Writes a SQL query for specific data retrieval based on requirements.
📝 Prompt Content
Write a SQL query for a table named 'employees' that has columns: id, first_name, last_name, department, and salary. The query should select the first name and last name of all employees who work in the 'Sales' department and earn more than 50000. Order the results by last name in ascending order.