1.13Exercises

Beginner:

1. Write a SELECT query to find all users with the role 'admin'.
2. Write a query to count how many users have email_verified = false.
3. Write a query to find the most recently created user.

Intermediate:

4. Write a query that finds users whose updated_at equals created_at (never modified).
5. Write a Python test that creates a user via API and verifies the default role in the database.
6. Write a query to find all soft-deleted users (deleted_at IS NOT NULL) created in the last 30 days.

Advanced:

7. Write a verification query that returns rows ONLY if there is an inconsistency between the users table and user_profiles table (every user should have a profile).
8. Write a comprehensive Python test fixture that provides both API client and database cursor, with automatic cleanup.
9. Write a query that detects timestamps in the future or before the year 2020, across all timestamp columns in the users table.

Career Translation