Advertisement
Guest User

upr6

a guest
Apr 18th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.82 KB | None | 0 0
  1. SELECT
  2.     assignment.EMP_NUM,
  3.     employee.EMP_LNAME,
  4.     SUM(assignment.ASSIGN_HOURS),
  5.     SUM(assignment.ASSIGN_CHARGE)
  6. FROM
  7.     assignment
  8.         JOIN
  9.     employee ON assignment.EMP_NUM = employee.EMP_NUM
  10. GROUP BY assignment.EMP_NUM; /*zayawka 1*/
  11.  
  12. SELECT
  13.     assignment.PROJ_NUM,
  14.     SUM(assignment.ASSIGN_HOURS),
  15.     SUM(assignment.ASSIGN_CHARGE)
  16. FROM
  17.     assignment
  18. GROUP BY assignment.PROJ_NUM;/*zayawka2*/
  19.  
  20. SELECT
  21.     job.JOB_DESCRIPTION,
  22.     SUM(assignment.ASSIGN_HOURS),
  23.     SUM(assignment.ASSIGN_CHARGE)
  24. FROM
  25.     assignment
  26.         JOIN
  27.     job ON assignment.ASSIGN_JOB = job.JOB_CODE
  28. GROUP BY assignment.ASSIGN_JOB;/*zayawka3*/
  29.  
  30. SELECT
  31.     assignment.ASSIGN_DATE,
  32.     SUM(assignment.ASSIGN_HOURS),
  33.     SUM(assignment.ASSIGN_CHARGE)
  34. FROM
  35.     assignment
  36. GROUP BY assignment.ASSIGN_DATE;/*zayawka4*/
  37.  
  38. SELECT
  39.     assignment.PROJ_NUM,
  40.     SUM(assignment.ASSIGN_HOURS) AS ASSIGN_HOURS
  41. FROM
  42.     assignment
  43. WHERE
  44.     ASSIGN_HOURS = (SELECT MAX(ASSIGN_HOURS));/*zayawka5*/
  45.    
  46. SELECT
  47.     assignment.PROJ_NUM,
  48.     SUM(assignment.ASSIGN_CHARGE) AS ASSIGN_CHARGE
  49. FROM
  50.     assignment
  51. WHERE
  52.     ASSIGN_CHARGE = (SELECT MIN(ASSIGN_CHARGE));/*zayawka6*/
  53.    
  54. SELECT
  55.     COUNT(assignment.emp_num) as emp_num,
  56. proj_num
  57.    
  58. FROM
  59.     assignment
  60.    
  61.    where emp_num = (select (emp_num))
  62.    group by proj_num;/*zayawka7*/
  63.    
  64. SELECT
  65.     COUNT(assignment.assign_num) as assign_num,
  66. assign_date
  67. FROM
  68.     assignment
  69.    
  70.    where assign_num = (select (assign_num))
  71.    group by assign_date;/*zayawka8*/
  72.    
  73. SELECT
  74.     AVG(assignment.ASSIGN_CHARGE), assignment.PROJ_NUM
  75. FROM
  76.     assignment
  77. GROUP BY assignment.PROJ_NUM;/*zayawka9*/
  78.  
  79. SELECT
  80.     SUM(assignment.ASSIGN_HOURS) AS ASSIGN_HOURS,
  81.     assignment.PROJ_NUM
  82. FROM
  83.     assignment
  84. WHERE
  85.     ASSIGN_HOURS > 22;/*zayawka10*/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement