SQL Challenges
1. Find Cheap Products
Using the 'Shop' database, select all products that cost less than $100.
Show Solution
SELECT * FROM products WHERE price < 100;
2. Student Grades
Using the 'School' database, find all students majoring in 'CS'.
Show Solution
SELECT * FROM students WHERE major = 'CS';
3. High Salaries
Using the 'Employees' database, list staff earning more than 55000, ordered by salary.
Show Solution
SELECT * FROM staff WHERE salary > 55000 ORDER BY salary DESC;