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

In
Nhúng

Bảng xếp hạng

Phong cách trực quan

Tùy chọn

Chuyển đổi mẫu

Bạn có muốn khôi phục tự động lưu: không?