Write SQL

The Orion.customer table is

Challenge 3. Enhancing Output with Multiple Techniques Create a report that displays Customer the customer's name displayed as contained FirstName, and Gender, as well as the customer's age as of 02FEB2013. Use the data in the orion.customer table. Include only U.S. customers who were more than 50 years old on Present the data ordered by descending age and customer name. Give the report an appropriate title. Limit the space used to display the customer's name to a maximum of 20 characters so that the report can be printed in portrait orientation. The Customer values must be displayed with leading zeros as shown in this sample report. PROC SQL Output US Customers >50 Years old as of 02FEB013 Customer Last Name, Gender Age ID First Name 75 0000056 Siferd, Roy 0000089 Lewis Wynella 74 0000092 Celii Lendon 64 0000023 Devereaux, Tulio 59 0000018 Asmussen Tonie Jimmie 54