BMGT 402 Chapter 2: HW2_Kaushal_Kajal
11 Oct 2018
School
Department
Course
Professor
Document Summary
On the following database schema, compose sql select statements to answer 12 questions. Employee (empno, fname, lname, address, dob, sex, position, deptno) Workson (empno, projno, hoursworked: (2pts) list full details of all employees in alphabetical order of last name and then fist name. Order by lname, fname: (2pts) list full details of employees who are "female". W(ere sex = (cid:494)female(cid:495): (3pts) list names and addresses of employees who are "manager". 1: (3pts) list names and addresses of employees who work at the "integration" department. W(ere e. deptno = d. deptno and d. deptname = )ntegreation(cid:495): (3pts) list number of employees who work at the "video" department. W(ere e. deptname = d. deptno and d. deptname = (cid:494)video(cid:495): (3pts) list project names run by the "sound" department. 2: (4pts) list department names and project names run by the departments in which employee name "benjamin franklin" is working. Each row in the resulting table should be unique and be ordered with department names alphabetically.
