Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- assignment.EMP_NUM,
- employee.EMP_LNAME,
- SUM(assignment.ASSIGN_HOURS),
- SUM(assignment.ASSIGN_CHARGE)
- FROM
- assignment
- JOIN
- employee ON assignment.EMP_NUM = employee.EMP_NUM
- GROUP BY assignment.EMP_NUM; /*zayawka 1*/
- SELECT
- assignment.PROJ_NUM,
- SUM(assignment.ASSIGN_HOURS),
- SUM(assignment.ASSIGN_CHARGE)
- FROM
- assignment
- GROUP BY assignment.PROJ_NUM;/*zayawka2*/
- SELECT
- job.JOB_DESCRIPTION,
- SUM(assignment.ASSIGN_HOURS),
- SUM(assignment.ASSIGN_CHARGE)
- FROM
- assignment
- JOIN
- job ON assignment.ASSIGN_JOB = job.JOB_CODE
- GROUP BY assignment.ASSIGN_JOB;/*zayawka3*/
- SELECT
- assignment.ASSIGN_DATE,
- SUM(assignment.ASSIGN_HOURS),
- SUM(assignment.ASSIGN_CHARGE)
- FROM
- assignment
- GROUP BY assignment.ASSIGN_DATE;/*zayawka4*/
- SELECT
- assignment.PROJ_NUM,
- SUM(assignment.ASSIGN_HOURS) AS ASSIGN_HOURS
- FROM
- assignment
- WHERE
- ASSIGN_HOURS = (SELECT MAX(ASSIGN_HOURS));/*zayawka5*/
- SELECT
- assignment.PROJ_NUM,
- SUM(assignment.ASSIGN_CHARGE) AS ASSIGN_CHARGE
- FROM
- assignment
- WHERE
- ASSIGN_CHARGE = (SELECT MIN(ASSIGN_CHARGE));/*zayawka6*/
- SELECT
- COUNT(assignment.emp_num) as emp_num,
- proj_num
- FROM
- assignment
- where emp_num = (select (emp_num))
- group by proj_num;/*zayawka7*/
- SELECT
- COUNT(assignment.assign_num) as assign_num,
- assign_date
- FROM
- assignment
- where assign_num = (select (assign_num))
- group by assign_date;/*zayawka8*/
- SELECT
- AVG(assignment.ASSIGN_CHARGE), assignment.PROJ_NUM
- FROM
- assignment
- GROUP BY assignment.PROJ_NUM;/*zayawka9*/
- SELECT
- SUM(assignment.ASSIGN_HOURS) AS ASSIGN_HOURS,
- assignment.PROJ_NUM
- FROM
- assignment
- WHERE
- ASSIGN_HOURS > 22;/*zayawka10*/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement