Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use Customer and Order Table to answer the question a) Write a query in SQL to display customer number, name and order number for each
Use Customer and Order Table to answer the question
a) Write a query in SQL to display customer number, name and order number for each customer (Using Inner JOIN)
b ) Write a query in SQL to find out who the customer is with order number 5369. (Using Subquery)
Please include references if available
CustomerNumber 100 Name Jake Vanderplas Francois Chollet Discount 5% 101 Address 000 Sokak No:1 Kadky 111 Sokak No:2 skdar 333 Sokak No:4 Fatih 5% 102 Sebastian Raschka 3% Order Number 5369 5375 5385 Order Date 01/03/2020 07/03/2020 18/03/2020 Customer Number 100 101 102Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started