Problem
|
productID
|
styleName
|
shoeStyle
|
brand
|
colour
|
price
|
|
SS81309
|
Sarah
|
boots
|
Sol Sana
|
tan
|
189
|
|
JS10309
|
Bella
|
sandals
|
Josef Seibel
|
black
|
129
|
|
DJ20822
|
Hannah
|
flats
|
Django & Juliette
|
pink
|
159
|
|
JD58731
|
Milan
|
heels
|
Jane Debster
|
red
|
299
|
|
AE21135
|
Amalfi
|
sandals
|
A. Emery
|
red
|
145
|
|
WT23599
|
Jemma
|
boots
|
Wittner
|
black
|
229
|
The table above contains data about various pairs of shoes for sale at a retails store.
Using the above Shoes table name and column headings (attributes), write the SQL script for the following queries as if it were going to be run/executed in MySQL Workbench:
A. Display the productID, brand, colour, and price for all pairs of shoes with the same brand as the shoes listed in the first row.
B. In alphabetical order of the brand, display all details about shoes for sale.
C. How many pairs of red sandals are for sale?
D. What is the average price of shoes for each brand?
E. List all details of shoes that cost more than $200.