Help with question 1,2,3,4

1. Write a SELECT statement that returns two columns- VendoriD and a column named "Vendor Location" which has the VendorName, VendorCity, VendorState and VendorZipCode) in this format: Zylka Design, Fresno, CA 93711 a. Show only those Vendors with names that start with the letter G,H,I,J,K (use LIKE) b. Show only those Vendors that are in states that start with the letter "N" c. Show only those Vendors that are in the state of CA and sort the result set by VendorCity 2. Write a SELECT statement to calculate the balance due for each invoice. It should show four columns: InvoicelD, InvoiceDate, InvoiceTotal and Balance (invoiceTotal PaymentTotal- CreditTotal). Sort them by Balance in DESC order. a. Show only invoices with an InvoiceTotal greater than or equal to $500 but less than or equal to $10,000. b. Show only invoices dated between '2020/02/01' and '2020/03/01'. This should display invoices for the month of February 2020 only. C. Show only invoices that have a balance of 0 . What does it mean when the balance of an invoice is 0