Write an SQL statement to create a view named ProjectHoursToDateView that shows the values of PROJECT.ProjectID, PROJECT.Name

Question:

Write an SQL statement to create a view named ProjectHoursToDateView that shows the values of PROJECT.ProjectID, PROJECT.Name as ProjectName, PROJECT.MaxHours as ProjectMaxHour and the sum of ASSIGNMENT.HoursWorked as ProjectHoursWorkedToDate. Run this statement, and then test the view with an SQL SELECT statement.

Fantastic news! We've Found the answer you've been seeking!