Advertisement
Guest User

Untitled

a guest
Apr 25th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.34 KB | None | 0 0
  1. --1
  2. SELECT * FROM EMP WHERE SALARY < 1300 ORDER BY LAST_NAME;
  3.  
  4. --2
  5. SELECT CONCAT(CONCAT(DATE_ORDERED,' - '),TOTAL) FROM ORD;
  6.  
  7. --3
  8. SELECT FIRST_NAME, LAST_NAME
  9. FROM EMP
  10. WHERE
  11. TITLE = 'Stock Clerk'
  12. AND
  13. SALARY > (SELECT AVG(SALARY) FROM EMP WHERE TITLE='Warehouse Manager');
  14.  
  15. --4
  16. SELECT COUNT(*) FROM EMP
  17. WHERE
  18. SALARY < (SELECT AVG(SALARY) FROM EMP);
  19.  
  20. --5
  21. SELECT
  22. LAST_NAME
  23. FROM EMP
  24. WHERE
  25. EXTRACT(YEAR FROM TO_DATE('01-03-2017','DD-MM-YYYY'))-
  26. EXTRACT(YEAR FROM START_DATE) > 26
  27. ORDER BY START_DATE;
  28.  
  29. --6
  30. SELECT EMP.ID, SUM(ORD.TOTAL) FROM EMP, ORD
  31. WHERE
  32. ORD.SALES_REP_ID = EMP.ID
  33. GROUP BY EMP.ID;
  34.  
  35. --7
  36. SELECT SALES_REP_ID, SUM(TOTAL) FROM ORD
  37. GROUP BY SALES_REP_ID
  38. HAVING SUM(TOTAL)=(SELECT MAX(SUM(TOTAL)) FROM ORD
  39. GROUP BY SALES_REP_ID);
  40.  
  41. --8
  42. SELECT LAST_NAME FROM EMP
  43. WHERE ID = (SELECT SALES_REP_ID FROM ORD
  44. GROUP BY SALES_REP_ID
  45. HAVING SUM(TOTAL)=(SELECT MAX(SUM(TOTAL)) FROM ORD
  46. GROUP BY SALES_REP_ID));
  47.  
  48. --9
  49. SELECT START_DATE, COUNT(*) FROM EMP
  50. GROUP BY START_DATE ORDER BY START_DATE;
  51.  
  52. --10
  53. SELECT PRODUCT.NAME
  54. FROM INVENTORY, PRODUCT
  55. WHERE
  56. INVENTORY.PRODUCT_ID=PRODUCT.ID
  57. AND
  58. INVENTORY.OUT_OF_STOCK_EXPLANATION IS NOT NULL;
  59.  
  60. --11
  61. SELECT PRODUCT.NAME
  62. FROM
  63. PRODUCT, INVENTORY
  64. WHERE
  65. PRODUCT.ID=INVENTORY.PRODUCT_ID
  66. GROUP BY
  67. PRODUCT.NAME
  68. HAVING
  69. SUM(INVENTORY.AMOUNT_IN_STOCK)<500;
  70.  
  71. --12
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement