Zoom
Question 3:
Picture 2.1
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.
ID
CustomerName
Segment
Country
City Lawrence
State
PostalCode Region
1
472 Ben Ferrer
Home Office
United States
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 California
92804
West
4
485 Ben Peterman
Corporate
United States
San Diego
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
14
656 Brian Thompson
Consumer
15
670 Brosina Hoffman
Consumer United States
United States
Bowling Gre...
Kentucky
42104
South
Fort Lauder...
Florida
33311
South
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
+ 100%
Close
