12 899
13 900
14 901
15 902
LL Touring Frame - Yellow, 44 Yellow 199.8519 333,42 NULL
LL Touring Frame-Yellow, 50
Yellow 199,8519 333,42 NULL
LL Touring Frame-Yellow, 54 Yellow 199,8519 333,42 NULL
LL Touring Frame-Yellow, 58 Yellow 199,8519 333,42 NULL
Picture 4.1
NULL
NULL
NULL
NULL
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
Question 5:
[1 mark] Write a query to display ModelID, ModelName, NumberOfProducts corresponding to each product model having the name beginning with 'Mountain' or beginning with 'MLMountain'; where NumberOfProducts is the count of distinct products belonging to each model. Display the results in descending order of NumberOfProducts then in ascending order of ModelName for model having the same NumberOfProducts as follows:
Zoom
+ 100%
Close
