$/*$ Follow the directions below to satisfy the requirements for your homework assignment. $*//*$ Replace all references to $"*$ enter your code here" with the relevant code. $*//*$ Refer to the relevant lecture examples SAS program and PowerPoint lecture slides. $*//*/*/*$ List the employee first and last names from the employee table. $*//*$ Don't forget, you need to specify both the library and the table name so in this caseyou'll select from ITKM$549.$employee. $*/$PROC SQL;$*$ enter code here;QUIT;$/*$ List the last names of all customers from New York $($NY$)$ in the customer table.List their last names and their state. Hint: Watch your semicolons.$*/$PROC SQL;$*$ enter code here;QUIT;$/*$ Provide a list of all of the products, all columns, in descending orderby product cost from the products table.$*/$PROC SQL;$*$ enter code here;QUIT;$/*$ Provide the list of products on the products table that cost between $$50$ and $$100.*/$PROC SQL;$*$ enter code here;QUIT;$/*$ Provide a list of the last names of all employees whose names start with the letters"Me$"$ using the employee table. $*/$PROC SQL;$*$ enter code here;QUIT;$/*$ Provide a count of the employees on the employee table. Include a descriptive header name. $*/$PROC SQL;$*$ enter code here;QUIT;$/*$ List all region names from the sales$\_$extract table. Remove duplicates. $*/$PROC SQL;$*$ enter code here;QUIT;