Now that you have your view working, will re$-$create the query from SQL Review, exercise $4.$ If you remember, the results were not in alphabetical order because Oracle sorts lower case letters before upper case letters. That is why both von Sydo and de Niro were showing before Young when sorted in descending order. Obviously Young should have been first up in descending order.

For this exercise, use the view you created in exercise $3$ to fix the original exercise $4$ from the SQL Review homework. Your query should use the customer$\_$names view as the 'table' to select from, and return the same two fields as the original exercise, customer$\_$id and full$\_$cust$\_$name fields, but this time sort on the last$\_$name$\_$upper name field so the results are ordered as expected.

$2$

The results should look like this:

CUSTOMER ID

FULL CUST NANE

$45=$ voung, k$1$cley

$766$ YoLng, Kl$\backslash$bar $($a$)$ us