Description

Create wishlist with customer_id (a whole number), product_id (a whole number) and added_on (a date, required), where:

• a customer can save a product only once, so the pair customer_id, product_id is the primary key
• customer_id must be a real customer, and a customer's wishlist rows are deleted with the customer
• product_id must be a real product

Add these rows:

Then delete customer 26, and show customer_id, product_id and added_on of every wishlist row.

End your query with ORDER BY customer_id, product_id.

Tables