Question

Invoices CUSTOMENVOICE_NUMBER_OF_ITEMS_SOLD 1 1 5 2 3 7 1 5 8 1 6 9 Customer Overview NAME CUSTOMEMOUNTINVOICE_NUMBER_OF_ITEMS_SOLD Maxim Sc 1 2500 1 5 Maxim Sc 1 2500 5 8 Maxim Sc 1 2500 6 9 Given tables invoices and customer overview, what other query would give me the same result set as the following: "select distinct a.customer_id, a.invoice_no, a.number_of_items_sold from invoices a left join customer_overview b on a.customer_id;" ?

          Invoices
CUSTOMENVOICE_NUMBER_OF_ITEMS_SOLD
1
1
5
2
3
7
1
5
8
1
6
9
Customer Overview
NAME CUSTOMEMOUNTINVOICE_NUMBER_OF_ITEMS_SOLD
Maxim Sc
1
2500
1
5
Maxim Sc
1
2500
5
8
Maxim Sc
1
2500
6
9
Given tables invoices and customer overview, what other query would give me the same
result set as the following:
"select distinct a.customer_id, a.invoice_no, a.number_of_items_sold from invoices a left
join customer_overview b on a.customer_id;" ?

Invoices
CUSTOMENVOICENUMBEROFITEMSSOLD
1
1
5
2
3
7
1
5
8
1
6
9
Customer Overview
NAME CUSTOMEMOUNTINVOICENUMBEROFITEMSSOLD
Maxim Sc
1
2500
1
5
Maxim Sc
1
2500
5
8
Maxim Sc
1
2500
6
9
Given tables invoices and customer overview, what other query would give me the same
result set as the following:
"select distinct a.customerid, a.invoiceno, a.numberofitemssold from invoices a left
join customeroverview b on a.customerid;" ?

Added by Hugo M.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Md.Daniyal Arshad

Step 1

To achieve the same result set, we can break down the query into multiple steps: Show more…

Show all steps

Thanks for your feedback!

Using SQL database management systems Invoices: CUSTOMER INVOICE NUMBER OF ITEMS SOLD 1 1 5 2 3 7 1 5 8 1 6 9 Customer Overview: NAME CUSTOMER AMOUNT INVOICE NUMBER OF ITEMS SOLD Maxim Sc 1 2500 1 5 Maxim Sc 1 2500 5 8 Maxim Sc 1 2500 6 9 Given tables "invoices" and "customer overview", what other query would give me the same result set as the following: "SELECT DISTINCT a.customer_id, a.invoice_no, a.number_of_items_sold FROM invoices a LEFT JOIN customer_overview b ON a.customer_id;"?