For this exercise we are going to modify the view created in exercise $2$ in order to further simplify exercise $3.$

Step $1-$ Use the $"$OR REPLACE" clause after the CREATE VIEW statement used in exercise $2.$ This will allow us to replace the view definition with a new view definition $($new SQL query$).$ The new view should sort the results in descending order in the view itself. Do this by adding:

ORDER BY last$\_$name$\_$upper desc

to the SQL making it part of the view definition.

Step $2-$ Modify the SELECT statement from exercise $2$ by removing the ORDER BY clause. You should now be able to run:

SELECT

customer$\_$id$,$

ful$1\_$cust$\_$name

EROM

customer$\_$names

and get the same results in exercise $3.$