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 project2emp 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!