Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --1
- SELECT * FROM EMP WHERE SALARY < 1300 ORDER BY LAST_NAME;
- --2
- SELECT CONCAT(CONCAT(DATE_ORDERED,' - '),TOTAL) FROM ORD;
- --3
- SELECT FIRST_NAME, LAST_NAME
- FROM EMP
- WHERE
- TITLE = 'Stock Clerk'
- AND
- SALARY > (SELECT AVG(SALARY) FROM EMP WHERE TITLE='Warehouse Manager');
- --4
- SELECT COUNT(*) FROM EMP
- WHERE
- SALARY < (SELECT AVG(SALARY) FROM EMP);
- --5
- SELECT
- LAST_NAME
- FROM EMP
- WHERE
- EXTRACT(YEAR FROM TO_DATE('01-03-2017','DD-MM-YYYY'))-
- EXTRACT(YEAR FROM START_DATE) > 26
- ORDER BY START_DATE;
- --6
- SELECT EMP.ID, SUM(ORD.TOTAL) FROM EMP, ORD
- WHERE
- ORD.SALES_REP_ID = EMP.ID
- GROUP BY EMP.ID;
- --7
- SELECT SALES_REP_ID, SUM(TOTAL) FROM ORD
- GROUP BY SALES_REP_ID
- HAVING SUM(TOTAL)=(SELECT MAX(SUM(TOTAL)) FROM ORD
- GROUP BY SALES_REP_ID);
- --8
- SELECT LAST_NAME FROM EMP
- WHERE ID = (SELECT SALES_REP_ID FROM ORD
- GROUP BY SALES_REP_ID
- HAVING SUM(TOTAL)=(SELECT MAX(SUM(TOTAL)) FROM ORD
- GROUP BY SALES_REP_ID));
- --9
- SELECT START_DATE, COUNT(*) FROM EMP
- GROUP BY START_DATE ORDER BY START_DATE;
- --10
- SELECT PRODUCT.NAME
- FROM INVENTORY, PRODUCT
- WHERE
- INVENTORY.PRODUCT_ID=PRODUCT.ID
- AND
- INVENTORY.OUT_OF_STOCK_EXPLANATION IS NOT NULL;
- --11
- SELECT PRODUCT.NAME
- FROM
- PRODUCT, INVENTORY
- WHERE
- PRODUCT.ID=INVENTORY.PRODUCT_ID
- GROUP BY
- PRODUCT.NAME
- HAVING
- SUM(INVENTORY.AMOUNT_IN_STOCK)<500;
- --12
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement