Library › Book 15 › Appendix B: 100 SQL Exercises
Appendix B: 100 SQL Exercises
15.1🔒Difficulty Levels- (B) = Beginner: Basic syntax, single table operations - (I) = Intermediate: JOINs, aggregations, subqueries - (A) = Advanced: CTEs…
15.2🔒SELECT and Filtering (Exercises 1-15)1. (B) Select all active users sorted by creation date descending.
15.3🔒JOINs (Exercises 16-35)16. (B) List all orders with the customer's name and email.
15.4🔒GROUP BY and Aggregation (Exercises 36-55)36. (B) Count orders by status.
15.5🔒Subqueries and CTEs (Exercises 56-70)56. (B) Find users who have at least one completed order using EXISTS.
15.6🔒Data Manipulation (Exercises 71-80)71. (B) Insert a new user with all required fields.
15.7🔒Constraints and Schema (Exercises 81-90)81. (B) Test that inserting a duplicate email fails.
15.8🔒Advanced Topics (Exercises 91-100)91. (I) Write a Python test that verifies the updated_at trigger.