You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: README.md
+2-2Lines changed: 2 additions & 2 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -47,14 +47,14 @@ Answer the following data queries. Keep track of the SQL you write by pasting it
47
47
48
48
> There is more information about the COUNT clause on [W3 Schools](https://www.w3schools.com/sql/sql_count_avg_sum.asp)
49
49
50
-
## Stretch Goals
51
-
52
50
### list customers names and the number of orders per customer. Sort the list by number of orders in descending order. _Ernst Handel_ should be at the top with 10 orders followed by _QUICK-Stop_, _Rattlesnake Canyon Grocery_ and _Wartian Herkku_ with 7 orders each.
53
51
> This can be done by adding an ORDER BY clause to the previous answer
54
52
55
53
### list orders grouped by customer's city showing number of orders per city. Returns 58 Records with _Aachen_ showing 2 orders and _Albuquerque_ showing 7 orders.
56
54
> This is very similar to the previous two queries, however, it focuses on the City rather than the CustomerName
57
55
56
+
## Stretch Goals
57
+
58
58
### delete all customers that have no orders. Should delete 17 (or 18 if you haven't deleted the record added) records.
0 commit comments