Exercises

A common table expresaion $($CTE$)$ allows you to simplify your SOL. CTEs only work for the current quey, compared to a vew enat is saved as a database object and can be used on ies owh or joined with another table. Consider the SOL state that we wrote in our SOL Rovisw Lsaignment, exarcise $24.$ If you remember, the resuls wore not in alphabetic order becsuse Orade sorts lower case letters betore upper case lattors. That is why both won Sydo and de Niro were showing belore Young when sorted in cescending onder. Obviously Young should have been first up in descencing order.

In the first coupie of exereses, wevl take a look at how wo can $*$x that waing a CTE or Viow. There are meny drtenent ways to sccomolsh pis tase, im going to show you a simple way of cong it$.$ The easiost. but arguably not the fastest or best, is by croateng a tecond calculatod fiold that conwarts the lase name to all uppercase. Hore is a sampie SOL coco to do that

$$

$$

$1$

e$.$uxtererx

For the first assignment, you are going to use the above cuery as a cte namod ouctomer$\_$namec and show all tha data. The results ahould look ike tha