I'm making SQL Code and needs some help.

 

using CAST(), aggregate functions, I want you to translate these into SQL Code.

a. How many products does each category have?
b. What is the average bottle size per vendor of whiskey?
c. Which categories have more than 100 products?

d. What is the average bottle size of each category?
e. What is the average bottle size per category and vendor of whiskey?
f. What is the average bottle size per category of whiskey?
g. What are the (unique) vendors that sell Tequilas?

h. What are the (unique) vendors that sell Tequilas with bottle sizes over 1500?

 

i. Explain why the b, e questions do not yield the same results.