I need help ASAP on how to write there statements to run correctly in SQL Server management studio

Scenario 1: I want a list of all of the vendor names and phone number ordered by state so that she can contact them. Using the AP database, write a select statement that will retrieve these results. We only want the vendor names and phone numbers in the result set.

Scenario 2: I want a list of all of the invoices that have a credit total and wants the list sorted by the invoice number. We only want to see the invoicenumber, invoice date, and credit total. We only want to see records for those that have a credit total in the result set.

Scenario 3: I want to know how many invoices for Vendor number 123 is greater than $50.

Scenario 4: I want to know the address of all vendors we have in the state of California, Ohio, or New Jersey. I want the street address City, State and Zip-code returned as a human would write them. I do not want any NULLs returned.

Scenario 5: I want to know the Contact Name and Number for each Vendor not in California, Ohio, or New Jersey that has a value of Null for the Phone Number. The result set should return the Vendor Name, Vendor Contact First and Last Name, Vendor State, and VendorPhone organized by state.