IN QUERY FORM!!!!!!!!!

1: (10 Points) Use the customers table, and write a query statement to show CustFirstName, CustLastName, and CustCity columns.

2: (10 Points) Use the employees table, and write a query statement to show the employees EmployeeID, EmpFirstName, EmpLastName, and EmpPhoneNumber, if the employee is living in the 98413 zip code.

3. (20 Points) Use INNER JOIN to create a query result. In this query result, list each vendors name and the name of each product the vendor has supplied to our company. You should use the Vendors, Product_Vendors, and the Products tables in the database to complete this task.

CUSTOMERS CustomerlD h CustFirstName CustLastName CustStreetAddress CustCity CustState CustZipCode CustAreaCode CustPhone Number PK+ ORDERS OrderNumber Order Date ShipDate Customer D Employeel Order Total FK FK EMPLOYEES Employeeld w EmpFirstName EmpLastName EmpStreetAddress EmpCity EmpState EmpZip Code EmpAreaCode EmpPhone Number ORDER_DETAILS OrderNumber CPK Product Number CPK QuotedPrice QuantityOrdered PRODUCTS Product Number PK Product Name Product Description Retail Price QuantityOnHand CategoryID FK CATEGORIES CategoryID PK CategoryDescription PRODUCT_VENDORS ProductNumber CPK Vendorld CPK Wholesale Price DaysToDeliver # ORDERS_ARCHIVE OrderNumber PK Order Date ShipDate Customer EmployeeID OrderTotal" VENDORS VendorID PK VendName VendStreetAddress VendCity VendStato VendZipCode VendPhone Number VendFaxNumber VendWebPage VendEmailAddress ORDER_DETAILS_ARCHIVE* OrderNumber CPK Product Number CPK QuotedPrice QuantityOrdered *Modify version only