Question: 1 . Write the join query to produce following table, which include: customer _ name, order _ id , customer _ id , order _

1.Write the join query to produce following table, which include: customer_name, order_id, customer_id, order_date, and staff_name. Where staff_name is "MireyaCopeland".
2.Write the join query to produce a table from bike database that contain the following coulumens: first_name, last_names of customers, customer_ID, and shipped_date. Where the last_name is "Jackson" or "Copeland".
1 . Write the join query to produce following

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

Q:

solve fast D Description This project involves using various Database concepts to solve Sales use cases. This requires skills like Database concepts, SQL Queries, etc In this project, the MySQL...

Q:

List customer ID, customer name, order ID, order date, product ID and the quantity of each product ordered, for all customers who have placed orders. Hint: You need to include 3 tables in your FROM...

Q:

Case 2 - Outdoor Store (35 marks) Evelvn Cho is the owner of Cairn Outdoor Store, a small camping store she runs in Fort Smith. Arkansas. To help her manage her inventory and orders, she wants to...

Q:

Horizon Books is a bookstore in downtown Madina Munawara. It carries an inventory of approximately 50,000 books. Customers come in and browse the shelves, select their books, and take them to one of...

Q:

From the following tables write a SQL query to list all salespersons along with customer name, city, grade, order number, date, and amount. Condition for selecting list of salesmen : 1. Salesmen who...

Q:

1. List customer ID, customer name, order ID, order date, product name, and the quantity multiplied by the price for each product. Give the mathematical expression the alias of [Extended price]....

Q:

Must be in SQL please. Lab5: Joining Tables LAB OVERVIEW Scenario and Summary Lab 5 will introduce the concept of multi-table JOINS in order to work with data in two or more related tables...

Q:

LAB OVERVIEW Scenario and Summary Lab 5 will introduce the concept of multi-table JOINS in order to work with data in two or more related tables simultaneously. 1. Use the JOIN ON syntax to write a...

Q:

Case Study 2 of 3: SQL with Pine Valley Furniture Company Database Business Intelligence and Analytics Your assignment is to write and execute the SQL queries that will produce the data (record sets)...

Q:

The question is for introduction to database system with sql live. The assignmemt is due on tomorrow 12p.m. Part 1 Maintaining and redesigning an existing database Create the following schema for...

Q:

Then answer the following questions: 1. Are the supporting data consistent with ISPGs claims? Perform an appropriate statistical analysis to confirm ( or discredit) the stated relationship between...

Q:

Cathy Muench a factory worker earns $1,000 each week. In addition, she will receive a $4,000 bonus at year-end and a four-week paid vacation. Prepare the entry to record the weekly payroll and the...

Q:

P . ( 4 ) WHIN 5 of 2 5 Concepts completived Multiple Select Question Select an thet epply Which of the following could be considered a cost of cyclical Political upheaval A higher rate of inflation...

Q:

Points: 0 of 2 The following data lists the number of correct and wrong dosage amounts calculated by 32 physicians. In a research experiment, a group of 19 physicians was given bottles of epinephrine...