15 / 65 · 15 SQL & Database Testing · JOINs and Aggregation← prev⊞ allnext →☰ Read as one page
2.7Practical Exercise
- Write a query that finds users who registered but never placed an order
- Write a query that finds duplicate email addresses in the users table
- Write a query that shows error distribution by hour for the last 7 days
- Write a query that finds orders where the total does not match the sum of line items
- Integrate one of these queries into a pytest test