Answered step by step
Verified Expert Solution
Question
1 Approved Answer
data base OG Based on the following Schema, and company data.sql answer the EMPLOYEE NA DERTMENT Damen Mor DEPT LOCATIONS De Occasion PROJECT Prame Porto
data base
OG Based on the following Schema, and company data.sql answer the EMPLOYEE NA DERTMENT Damen Mor DEPT LOCATIONS De Occasion PROJECT Prame Porto Drum WORKS ON Hours DEPENDENT En Decindentame SOR Bdato 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. 04: Write a statement that displays each employee name of the projects that worked on, then sort the according to employee name from (z-a or Z-A) 5: Retrieve the project name and hours worked on that project in which hours are equal to the ma urs worked on the projects Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started