FIT2094 Midterm: FIT2094 Databases SQL Revision

• School: Monash University
• Department: Information Technology
• Course: FIT2094
• Professor: Mr Lindsay Smith

Document Summary

Where empname like "j%" or empname like "k%" or empname like "m%" From payroll. employee e join payroll. department d on e. deptno = d. deptno. -15 (no attributes can be joined between the 2 tables) From payroll. employee e join payroll. history h on e. empno = h. empno. -20 - (nvl(attribute,0) if the attribute is null, itll become 0. Select empname, empjob, empmsal, empcomm, empmsal * 12 + nvl(empcomm,0) as "annual salary" -1 select empno, empname, empjob, empmsal, empmsal * (12*(1+0. 1)) as "annual income + -2 ( floor (months_between(sysdate, attribute)/12) select empname, to_date(empbdate, "dd-mon-yyyy"), floor(months_between(sysdate,empbdate)/12) as "age" from payroll. employee order by empname; -3 select empno, empname, empjob, (empmsal + nvl(empcomm,0)) * 12 as "annual salary + -4 (use || to format) select "employee " || empinit || ". " ||empname ||" is a " || empjob || " and works in the " || deptname|| " department" from payroll. employee e join payroll. department d on e. deptno = d. deptno.