Adding to cart

Write the INSERT query to add a product to the cart.

Viewing the cart

To view the cart you use SELECT. You filter one customer's lines.

SELECT product_id, qty
FROM cart
WHERE customer_id = 100;

This query returns products and quantities in customer 100's cart.

product_id, qty is selected from cart. WHERE keeps only the rows where customer_id = 100 holds.

Filter the cart by customer id to see what one person picked. Sum the quantities to find the total count.

Select product_id and qty from cart where customer_id=100.

Show example solution

SELECT product_id, qty
FROM cart
WHERE customer_id = 100

Filter cart

SELECT product_id, qty FROM cart
WHERE ____ = 100;

Show answer

SELECT product_id, qty FROM cart
WHERE customer_id = 100;