I am having troubles with the sql Quieries using both join and group funcitions for the following quieries.

A list of customer names with the number of orders that have ordered.

A list of all customers that have ordered a product within the last 30 days.

A list of customer name, order date, and product name ordered by the customer name.

A list of product name and the category name that they belong to.

A list of each product and the total amount that they have sold for along with their average number of units sold. Include products that have been sold.

A list of states with the number of units that have been sold to that state.

A list of month, year, and average order total for each month.

A list of mailing addresses that have at least 5 orders.

A list of the most popular products sold (consider quantity) with the number of items they have sold.

A list of product names that belong to the same category as the most popular product.

The table names are listed in the photo along with the fields withhin them.