tacocopter-sql-workshop/questions.html at master · mjp90/tacocopter-sql-workshop · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152

<h3>Single Table:</h3>
<h3>Specifying Fields</h3>
<h3>Inner Join</h3>
<h3>Many-to-Many</h3>


--OR--


Cities where the most highly rated store is vegetarian


With name
Cities with no stores that serve beer
City with no stores that serve beer
City where all stores are rated less than 5
Vegetarian store with the most expensive bonanza
City with most stores
grouped by rating, city and count
Stores with the same name
Stores with the same name and the same rating
Stores with the same name and different ratings
Stores with same name in different cities
Cities which have a store rated 10
Cities with store count order by most
Store with highest average price per taco and avg

What stores have salsa de pina
What's the only salsa that's never hotter than 3
What's the only city without a store serving Pico de Gallo
What's the only chain to have its own salsa?
Cities with a chain
Stores with ⅘ salsas in common :)
Store # of tacos cheaper / more expensive, store # of tacos cheaper / more expensive
Chain store with special taco and salsa
Chain store with no custom tacos
Stores where all tacos same price
Stores where all tacos different price
Store with same menu at different prices
Tacos at stores with same menu at different prices
Tacos at store with same menu at different prices
Price of bonanza at largest selection
Price of Bonanza at highest price
List of tacos at largest selection
List of tacos at highest bonanza price
What salsas are not served in Goletta
2 stores with same tacos and 100% different tacos
2 stores same tacos same salsas
2 stores same tacos # of salsas in common
stores with different tacos, same salsas
What stores has spiciest pico de gallo?
Which stores have on avg spiciest
Mildest tomatillo
Same salsas at same spices
Same salsas at different spiciness
In same cities,
In different cities
How many different spicesses of pico are there with count
Write a query: What is the best tacqueria in Santa Barbara County?

Extra:
Stores and has_vegetarian

List of stores, whether they are in drone friendly cities, whether they have vegetarian, whether they have salsa spicier than 9, whether they have beef (birria or carne asada)

List of tacos with store and city of cheapest one

List of cities, the rating and name of the highest rated and  a carne asada or a birria for less than $5, 2 or more salsas spicier than 9, and at least 6 tacos in the bonanza which is under $30


At what store did Brad eat tacos next to Conan O'Brian