SELECT Employee_Name, Role FROM retail_staff; - Retrieve only the Employee_Name and Role columns from the retail_staff table., SELECT * FROM retail_staff WHERE Store_Location = 'Lagos'; - Display all records where the Store_Location is 'Lagos'., SELECT * FROM retail_staff WHERE Salary > 3000; - List all employees with a salary greater than 3000., SELECT * FROM retail_staff LIMIT 10; - Show all records but only the first 10 rows., SELECT * FROM retail_staff ORDER BY Hire_Date DESC; - Sort employees by Hire_Date from newest to oldest., SELECT Employee_Name, Shift_Type, Salary FROM retail_staff WHERE Shift_Type = 'Morning' AND Salary < 2500; - Lydia’s retail branch wants to identify morning-shift employees earning less than ₦2500. Write an SQL query to display their Employee_Name, Shift_Type, and Salary., SELECT Employee_Name, Role, Hire_Date FROM retail_staff WHERE Hire_Date < '2022-01-01'; - You need to find out which employees joined before 2022-01-01. Write an SQL query to show Employee_Name, Role, and Hire_Date., SELECT DISTINCT Store_Location FROM retail_staff; - Your manager requests a list of all distinct store locations. Write an SQL query using the DISTINCT keyword,

Query Practice

Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?