Draw from the sales data model to prepare a statement that would show units in stock plus units

on order and a count of units in stock plus units on order. Limit the result set to products that have not been

discontinued. Use column and table aliases. Hint #$1$: only two values are allowed for the column named

discontinued: $$Y$$ and $$N$.$ Hint #$2$: this statement does not include a HAVING clause. Order by the aggregate

function.

Q$4(10$ POINTS$).$ Draw from the project data model to prepare a statement that would show the count of projects

by start year. Use the EXTRACT function to extract year from projectStartDate. Use column and table aliases. Sort

by the aggregate function in descending order.