I need help creating SQL statements for each of the following.

1.I need help with a report that will list all the categories in our database and the total number of products we have for each category. Generate a report that will display the category ID, category name and the total number of products for each category. Note: There are an equal number of products under each category in our database.

2.A report that will let us know who our repeat customers are. We want to be able to track customer loyalty and provide benefits to these customers who have made our company a success. Generate a report that will display the customer ID, their first and last name and the number of orders that each customer has placed on our website. The report should only show customers that have ordered from us more than once.

3.Need a report that will show the total sales for the week of October 12, 2014. This report should include the total sales amount for each day from October 12to October 18. Generate a report that will display the date and total sales for each day for the week of October 12, 2014.

4.I need help writing two reports should use the eCommerce tables development. Write a brief explanation of each query, what it is supposed to do and how it should be used by the users. Below are the minimum requirements for each report.

Report 1: This report must join two or more tables together. You may use an inner join our outer join. The number of attributes you select and the filtering criteria are up to you.

Report 2: This report must contain an advanced SQL function (aggregate or scalar). You may select results from a single table or join multiple tables together.