Each task asks for a label that is not in the table. Build it with CASE.

1. Each customer's name, then member for members and guest for the others.

2. Think before you run it: what does this return for a product with stock 0?

   text

   copy

   CASE WHEN stock < 20 THEN 'low' WHEN stock = 0 THEN 'out' ELSE 'ok' END

3. Each product's name, stock, then a label: out when the stock is 0, low when it is below 20, ok for the others.

4. Each order's id, status, then open for pending and shipped orders and closed for the others.