Advertisement
AmidamaruZXC

Untitled

Dec 13th, 2020
354
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.22 KB | None | 0 0
  1. SELECT * FROM Food
  2. WHERE supplier_id = ‘9vd=xvdd1’
  3. ORDER BY price;
  4.  
  5. SELECT *,
  6. CASE
  7. WHEN closed_at IS NULL
  8. THENNot delivered’
  9. ELSE ‘Delivered’
  10. END closed_at
  11. FROM Orders o  WHERE o.id == ‘ore3#1v-k’;
  12.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement