Question: Based on the following Schema, and company data.sql answer the following questions: EMPLOYEE Frame Minit Lname Sen Bdate Address DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date

Based on the following Schema, and company data.sql answer the following questions: EMPLOYEE Frame Minit Lname Sen Bdate Address DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS Dnumber Dlocation. PROJECT Pname Pnumber Plocation. Dnum WORKS ON Esan Pno. Hours Sex Salary Superssn Dno DEPENDENT Esan Dependent name Sex Bdate Relationship Q1: Write a statement that displays each employee name as (Employee_Name), dependent name and each dependent age in years without fractions. Q2: For each department, find the number of employees who belong to it. Q3: Write a statement that displays the Dependent_name and birth date for the oldest Dependent. Q4: Write a statement that displays each employee name of the projects that worked on, then sort the results according to employee name from (z-a or Z-A). Q5: Retrieve the project name and hours worked on that project in which hours are equal to the maximum hours worked on the projects.
Step by Step Solution
3.49 Rating (149 Votes )
There are 3 Steps involved in it
1 Select EMPLOYEEFname as EmployeeName DEPENDENT Dependentname Yea... View full answer
Get step-by-step solutions from verified subject matter experts
