1. Write a SELECT statement that returns four columns from the Vitals table: Height in. Weight.Ib Temp. and Pulse. Then, run this statement to make sure it works correctly. Add an ORDER BY clause to this statement that sorts the result set by Pulse in descending sequence. Then, run this statement again to make sure it works correctly. This is a good way to build and test a statement, one clause at a time. 2. Write a SELECT statement that returns one column from the Patient table named full name that joins the last.name and first name columns. Format this column with the last name, a comma, a space, and the first name like this: I Doe, John Sort the result set by last name in ascending sequence. Return only the customers whose last name begins with letters of J and S. 3. Write a SELECT statement that returns these columns from the Vitals table: Hsisht.in, Weight Temp. and Pulse. Return only the rows with height that's greater than 65 and less than 70. Sort the result set in descending sequence by the weight.lk column. 4. Write a SELECT statement that joins the Patient table to the Vitals table and returns these columns: I.name, Bdate, Pulse Sort the result set by Bdate and then by Pulse in ascending sequence. 5. Write a SELECT statement that joins the Patient table to the Medication table and returns these columns: Enams, L.nams, city, state, zip. Rx name, Return the information of the patients with Pressxibing.md of JOHNSON. 6. Write a SELECT statement that returns the Height in and Brusest columns from the Vitals table. Return the patients that has the same resp. Jats, as another patient. Sort the result set by Br..syst 7. Write a SELECT statement that returns these columns Patient number The count of the number of patients in the Vitals table Hsishtaxerans The average of the Haisht.in column in the Vitals table Weightmax The maximum of the Weishulk columns in the Vitals table 650 ce stv