Question: SQL Please. 1. Write a query using JOINS to list the orderid, orderdate, customer last name, customer first name for any orders made with a

SQL Please.

1. Write a query using JOINS to list the orderid, orderdate, customer last name, customer first name for any orders made with a sales rep with the last name of JONES (use all caps).

2. Write a query to display the customer number, last name and first name for every customer represented by sales rep 15 or sales rep 20.

SQL Please. 1. Write a query using JOINS to list the orderid,

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 Databases Questions!

Write a query using JOINS to list the orderid, orderdate, customer last name, customer first name for any orders made with a sales rep with the last name of JONES (use all caps). SQL Please!

Could youplease help me on this MySQL questions. Appricite your help Using multiple-table queries and joins, complete the following tasks (see database below). 2. For each order placed on October 23,...

I need the answers from, 1 though 20 please. Please and thank you, there is no rush. Have a great Morning, Afternoon or Night. We are using, Oracle Database 11g Express Edition. use SQL and the TAL...

please send the screenshot of the SQL work you did and explain the answer but send the SQL screenshot of answer and steps http://apex.oracle.com TAL Distributors Use SQL and the TAL Distributors...

We are using, Oracle Database 11g Express Edition. use SQL and the TAL Distrutors database (see figure 1-2 in chapter 1) to complete the following exercises. if directed to do so by your instructor,...

--******************************************* -- SECTION 1: Single-Table SQL Queries -- --******************************************* -- 1. Write a query to display customers last names, first names,...

-- SECTION 1: Single-Table SQL Queries --******************************************* -- 1. Write a query to display customers last names, first names, and email addresses. -- Sort your results by...

Please I need help with the Part 3 and 4 Questions of this exercise. Thank you. Exercise: Hotel Schema Overview Hotel Software Guild is a resort hotel on the West Arm of Lake Minnetonka. It is a...

Using SQL Developer execute the following queries with these statements. N eed help with the joining clauses in SQL. PLEASE help Write a query to display the title, publisher name, and author FROM...

Could youplease help me on this MySQL questions. Appricite your help Using multiple-table queries and joins, complete the following tasks (see database below). 1. For each order, list the order...

(a) Given n distinct objects, in how many ways can we select r of these objects so that each selection includes some particular m of the n objects? (Here m ¤ r ¤ n.) (b) Using the...

I have a spring boot ecommerce app that is giving me errors I need to fix.

discuss data encapsulation in terms of the variuos types of packets. What are the advantages

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Technology. Assume your instructor was one of your references. You have just accepted your dream job. Write an e-mail expressing appreciation to your instructor for serving as a reference. Update...

Why is the direct plan used to write a resignation letter when it contains negative or bad news? (Objective 4)

Describe how you could gather information about a potential employer.Why is it important to have background information on a future employer? (Objective 3)