using my sql

Use the Northwind database schema and generate the following SQL statements:

1. (4 points) List the product name and supplier id for all products that cost more than $20.

2. (4 points)List all products whose names start with letter "c" and are not discontinued.

3. (4 points)List all supplier names, the number of products that each supplier provides, and

the average price for the products provided by the same supplier. 4. (4 points) Find all suppliers' name, city, and country for those who provide non-

discontinued products.

5. (4 points) List all suppliers who provide at least two different products. 6. (5 points) Add a new product record to the products table. You must provide

values for

the following fields in the new product record: ProductID, productName, SupplierID, and CategoryID.

7. (5 points) Increase the reorder level by 20% and reduce the prices by 10% for all products