Listing products

Write the query to list products by price and stock.

Adding products

To add a product to the cart you use INSERT. You enter customer, product and quantity info.

INSERT INTO cart (id, customer_id, product_id, qty)
VALUES (1, 100, 5, 2);

Customer 100 adds 2 of product 5.

The values given with VALUES are inserted into cart as new rows.

Each cart line is a row. A customer can have many lines; each is added as a separate row.

Insert into cart the row id=2, customer_id=100, product_id=7, qty=1.

Show example solution

INSERT INTO cart (id, customer_id, product_id, qty)
VALUES (2, 100, 7, 1)

Values

INSERT INTO cart (id, customer_id, product_id, qty)
____ (1, 100, 5, 2);

Show answer

INSERT INTO cart (id, customer_id, product_id, qty)
VALUES (1, 100, 5, 2);