using SQL server MGMT studio and the AP database

l uling Server Management Studio. Please make sure the Cis113 the ai w the SQl syntax for each query that is created question is worth 3 points if the following is included in your submission. 1) The sql code. Use comments to show your name, assignment, and the query number a. 2) The first 5 lines of the results tab, with headings. 3) The output in the messages tab 4) No query, results, and messages should span any page break. Please create solutions to the following queries 1. Write a select statement that returns four columns based on the InvoiceT invoices table, Cis11101_AP database otal column of the a. Use the CAST function to return the first column with 0 digits to the right of the decimal point se the CAST function to return the second column with a $ in front of the value. c. Using the CONVERT function to return the third column with the smallest precision in d. Use the CONVERT function to return the fourth column with a $ in front and back of the One row example without the headers: mind to return the scale of 3. value. There should be no spaces between the symbols and number. i.e $3,813.33$ 3813 $3813.33 3813.330 $3,813.33$ The first Write a SELECT statement that returns two columns based on the Vendors table. column, Contact, is the vendor contact name, the second is the phone. 2. For the contact, the first name is followed by last name initial (for example, "John S The second column, Phone, is the VendorPhone column without the area code. a. b. Criteria: 1) 2) Only return rows for those vendors in the 559 area code. You can only use the numbers "559" in the search, no parenthesis. Sort the result set by last name. One row example with headers: Contact Phone Thom A 555-8484