task CREATE / ALTER · easy

Create a wishlist table

Create a table wishlist with shopper_id INTEGER NOT NULL, item_id INTEGER NOT NULL and added_on TEXT, where (shopper_id, item_id) is the primary key. Insert (1, 12, '2025-03-01') and (2, 4, '2025-03-02'), then return all wishlist rows ordered by shopper_id.

what to return

Columns

shopper_iditem_idadded_on in this order

Rows

2 rows · in the order asked

Watch for

The same shopper can't list the same item twice.

Neither id may be NULL.

Skill

Define a table with a composite primary key and NOT NULL columns. Refresher: Constraints protect the data contract →

expected result

Your query should return exactly these columns and values. Run it and compare.

data you can query

Sample rows from each table. Each column shows its type underneath; → marks a link to another table.