I want SQL statement.
The picture has names of table and column.
Find customers who have more than one order:
Show customer number and customer name in your result. Sort the result according to customer number. (Do not show duplicate values)
Do not use aggregate functions (COUNT()) to answer this question.
Hint: To find customers with different order numbers, you need to join the table dbs211_orders with itself. (If for the same customer, there are different orders.) To get the given result, you may need to join more tables.
Given :-
In the above question, the statement is mention in the above given question
Need to write the structured query language for the above mention statement as specified in the above given question
The required solution is mention in step (2) below as,
Step by step
Solved in 2 steps with 1 images
