Question

Question 2 (60 points): You need the Sales OrdersExample database to complete this project. To install the database, first, download Data code 1 and run it, then download Data code 2 and run (provided on D2L). Now answer the following questions. 2.1: (20 Points) Use the customers' table inside of the salesordersexample database, and write a query statement to show records from the CustFirstName, CustLastName, and CustCity columns 2.2: (20 Points) Use the employees' table inside of the salesordersexample database, and write a query statement to show the employee's Employeeld, EmpFirstName, EmplastName, and EmpPhone Number, if the employee is living in the 98413 zip code. 2.3. (20 Points) Use INNER JOIN to create a query result. In this query result, list each vendor's 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.

Answer 1

1) SELECT CustFirstName,CustLastName,CustCity from Customers

2) SELECT EmployeeID,EmpFirstName,EmpLastName and EmpPhoneNumber from Employees where empZipCode Like '98413'

3) Product table and product vendor table is not given so couldnt do this...