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

1: (10 Points) Use the customers table, and write a query statement to show records from the 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

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...

Now answer the following questions. 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...

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...

You need to write your SQL query statements for each question and put them all in a single.SQL (or ,bxt file) and upload them to the assigned folder on D2L. Here is the ERD diagram of the datacode....

help 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...

1. (10 Points) Use the customers table, and write a query statement to show CustFirstiame, Custlasthame. and Custcity columns. 2: (10 Points) Use the employees table, and write a query statement to...

1: (10 Points] Use the customers table, and write a query statement to showr records from the CustFirstName, CustLastName, and CustCity columns. 2: [10 Points} Use the employees table, and write a...

need help please You need to write your SQL query statements for each question and put them all in a single. SQL (or .txt file) and upload them to the assigned folder on D2L. Here is the ERD diagram...

Write your SQL query statements for each question. 1: Use the customers table, and write a query statement to show records from the CustFirstName, CustLastName, and CustCity columns. 2: Use the...

You have been given the following data for a company's balance sheet: Cash and cash equivalents: $20,000 Accounts receivable: $30,000 Inventory: $40,000 Property, plant and equipment: $200,000...

You are an administrator at "World Tech Inc.", you are assigned to record "Rogers" contact information 1. Create information for a manager that includes the following fields: (Make up the information...

Company \ ( X \ ) has a beta of 1 . 6 , while Company \ ( Y \ ) ' s beta is 0 . 7 . The risk - free rate is 7 percent, and the required rate of return on an average stock is 1 2 percent. Now the...

Mary believes that the ten percent required down payment will protect the bank from a loss of principal.However, should the loan default, the funds are likely to be tied up, without interest income...