Create a view named current_collections with the collection ID, title and artist name of every collection that hasn't been soft-deleted. Query it, ordered by ID.
Expected: 4 rows, IDs 1, 2, 3 and 5. ID 4, Hidden Study, is missing.
← SQL · Viewing
1 of 6
01Expose current collections
sql-viewing / reps/01/README.md
- 1 Inside a transaction, soft-delete collection 5 and query your view again. How many rows now, and what does that say the view stores?