Write a query to display all customers having CustomerName starting with B and placed orders in December 2017. Display the result by descending order of Segment and then by ascending order of CustomerName.
Zoom
ID
CustomerName
Segment
Country
City
State
Postal Code
Region
1
472
Ben Ferrer
Home Office
United States
Lawrence
Massachusetts
1841
East
2
437
Bart Pistole
Corporate
United States
New York City
New York
10024
East
3
478
Ben Peterman
Corporate
United States
Anaheim
California
92804
West
4
485
Ben Peterman
Corporate
United States
San Diego
California
92037
West
5
486
Ben Peterman
Corporate
United States
Seattle
Washington
98103
West
6
554
Bill Stewart
Corporate
United States
Denver
Colorado
80219
West
7
581
Brad Norvell
Corporate
United States
Brentwood
California
94513
West
8
609
Brenda Bowman
Corporate
United States
Oakland
California
94601
West
9
413
Barry Gonzalez
Consumer
United States
Greensboro
North Carolina
27405
South
10
429
Bart Folk
Consumer
United States
New York City
New York
10024
East
11
515
Beth Paige
Consumer
United States
Columbus
Ohio
43229
East
12
594
Bradley Nguyen
Consumer
United States
Los Angeles
California
90049
West
13
638
Brian Derr
Consumer
United States
Bowling Gre...
Kentucky
42104
South
14
656
Brian Thompson
Consumer
United States
Fort Lauder...
Florida
33311
South
15
670
Brosina Hoffman
Consumer
United States
Hattiesburg
Mississippi
39401
South
16 691
Bruce Stewart
Consumer
United States
Edmonds
Washington
98026
West
Picture 3.1
Question 4:
Write a query to display SubCategoryID, SubCategoryName and the corresponding number of products (NumberOfProducts) in each sub-category having the number of products greater than 100, by descending order of NumberOfProducts.
87%
Close
