Question: Draw from the project data model ( below ) to prepare a statement that would show the average estimated project hours for each project. Specifically,
Draw from the project data model below to prepare a statement that would show the average estimated
project hours for each project. Specifically, show project ID project name, and average estimated project hours.
The column you need for the aggregate function is in the projectemp table.
Round average estimated project hours to the hundredths place in the SELECT clause only
Create an alias for each column, including Avg Estimated Project Hours for the aggregate function
Create and use an alias for each table
Sort by average estimated project hours in descending order
You must group by projectID first
Recall that when a statement includes a column thats shared by two tables in the statement, you must include a
table alias as a prefix for it
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
