Advertisement
Guest User

Untitled

a guest
Dec 11th, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.32 KB | None | 0 0
  1. 1.
  2. SELECT CODE
  3. FROM CUST
  4. WHERE ST IN ('AZ', 'CA')
  5. 2.
  6. SELECT DATE, DEFECTS, QTY
  7. FROM MANU
  8. WHERE CODE NOT IN ('DD', 'GC')
  9. 3.
  10. SELECT CODE, DEFECTS
  11. FROM MANU
  12. WHERE DEFECTS BETWEEN 12 AND 16
  13. 4.
  14.  
  15. 5.
  16. SELECT COUNT(*)
  17. FROM MANU
  18. 6.
  19.  
  20. 18.
  21. SELECT DATE
  22. FROM MANU, CUST
  23. WHERE CUST.CODE = 'AA' AND MST = ST
  24. ORDER BY DATE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement