PE_-_DBI_-_02_-_SP_2024_-_Block_10_1501.webp

Picture 4.1
Question 5:
Write a query to display customer_id, full_name, number_of_order all customers; display the results in descending order of number of order as following:
(The image below is only a output on sample data)
customer_id
full_name
number_of_order
850 836
Corinna Adams
1
851 837
Kellye Campbell
1
852 838
Ema Sloan
1
853 839
Carolann Russell
1
854 840
Gilbert Calhoun
1
855 841
Manie Maxwell
1
856 899
Carisa Carpenter
1
857 900
Jule Davenport
1
858 842
Giselle Robles
0
859 898
Crysta Velez
0
860 850
Stephanie Browni...
0
861 885
Janna Hayden
0
Picture 5.1
Zoom
6 of 6
Question 6:

Paper No: 1
+ 100%
Close