Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1.
- SELECT CODE
- FROM CUST
- WHERE ST IN ('AZ', 'CA')
- 2.
- SELECT DATE, DEFECTS, QTY
- FROM MANU
- WHERE CODE NOT IN ('DD', 'GC')
- 3.
- SELECT CODE, DEFECTS
- FROM MANU
- WHERE DEFECTS BETWEEN 12 AND 16
- 4.
- 5.
- SELECT COUNT(*)
- FROM MANU
- 6.
- 18.
- SELECT DATE
- FROM MANU, CUST
- WHERE CUST.CODE = 'AA' AND MST = ST
- ORDER BY DATE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement