Customer Order Analytics

#In this SQL, I am querying a database with multiple tables to quantify statistics about customer and order data. 

#1 How many orders were placed in January?

SELECT COUNT(orderid)
FROM BIT_DB.JanSales;

#2 How many of those orders were for an iPhone?

SELECT COUNT(Product)
FROM BIT_DB.JanSales
WHERE Product='iPhone';

#3 Select the customer account numbers for all the orders that were placed in February.

SELECT acctnum
FROM BIT_DB.customers 
INNER JOIN BIT_DB.FebSales
ON customers.order_ID=FebSales.orderid;

#4 Which product was the cheapest one sold in January, and what was the price?

SELECT distinct Product,MIN(price)
FROM BIT_DB.JanSales
ORDER BY price ASC LIMIT 1;

#5 What is the total revenue for each product sold in January?

SELECT SUM(quantity)*price AS revenue
,product
FROM BIT_DB.JanSales
GROUP BY Product;

#6 Which products were sold in February at 548 Lincoln St, Seattle, WA 98101, how many of each were sold, and what was the total revenue?

SELECT SUM(quantity)
, product,
SUM(quantity)*price AS revenue
FROM BIT_DB.FebSales
WHERE  location= '548 Lincoln St, Seattle, WA 98101'
GROUP BY product;

#7 How many customers ordered more than 2 products at a time in February, and what was the average amount spent for those customers?

SELECT COUNT(cust.acctnum),
AVG(quantity*price)
FROM BIT_DB.FebSales AS Feb
LEFT JOIN BIT_DB.customers AS Cust
ON FEB.orderid=cust.order_id
WHERE Feb.quantity>2;

#8 List all the products sold in Los Angeles in February, and include how many of each were sold.

SELECT product
, SUM(quantity)
FROM BIT_DB.FebSales
WHERE location like '%Los Angeles%'
GROUP BY Product;

#9 Which locations in New York received at least 3 orders in January, and how many orders did they each receive?

SELECT distinct location, count(orderID)
FROM BIT_DB.JanSales
WHERE location LIKE '%NY%'
GROUP BY location
HAVING count(orderID) >2;

#10 How many of each type of headphone were sold in February?

SELECT sum(Quantity) as quantity,
Product
FROM BIT_DB.FebSales
WHERE Product like '%Headphones%'
GROUP BY Product;

#11 What was the average amount spent per account in February?

SELECT avg(quantity*price)
FROM BIT_DB.FebSales Feb
LEFT JOIN BIT_DB.customers cust
ON Feb.orderid=cust.order_id;

#12 What was the average quantity of products purchased per account in February?

SELECT sum(quantity)/count(cust.acctnum)
FROM BIT_DB.FebSales Feb
LEFT JOIN BIT_DB.customers cust
ON FEB.orderid=cust.order_id;

#13 Which product brought in the most revenue in January and how much revenue did it bring in total?

SELECT product,
sum(quantity*price)
FROM BIT_DB.JanSales
GROUP BY product
ORDER BY sum(quantity*price) desc
LIMIT 1;