Insert data into the database $(2$ Points$)$

Insert the following data in the tables using insert into statements:

customer:

$10010,$ Ramas, Alfred, A$,615,8442573$

$10011,$ Dunne, Leona, K$,713,8941238$

$10012,$ Smith, Kathy, W$,615,8942285$

$10013,$ Olowski, Paul,F$,615,2221672$

$10014,$ Orlando, Myron, NULL, $615,2971228$

invoice:

$1001,10011,2008-08-03$

$1002,10014,2008-08-04$

$1003,10012,2008-03-20$

$1004,10011,2008-09-23$

line:

$1001,12321,1$

$1001,65781,3$

$1002,34256,6$

$1003,12321,5$

$1002,12333,6$

product:

$12321,$ hammer, $189,20,232$

$65781,$ chain, $12,45,235$

$34256,$ tape, $35,60,235$

$12333,$ hanger, $200,10,232$

vendor:

$232,$ Bryson, Smith, $615,2233234$

$235,$ SuperLoo, Anderson, $615,2158995$ SQL Queries $(6$ Points$)$

For each of the following, write SQL statement to produce the required output:

List the invoice number and invoice date for all invoices of customer number $10011$

List the product number and product quantity for products in invoice number $1001$

List all product description and product price supplied by vendor whose vendor contact name is Smith

Produce a list of product description, vendor name, and vendor phone for all products with price less than $50.$

For each product bought by a customer, list product description and customer's first name and last name.

How many vendors supplied products that are cheaper than $50?$

For each vendor, find the cheapest product.

For each invoice, find the total price.

Find how many products are there in each invoice.

Find how many invoices are made by each customer.

Find how many products are bought by each customer.

Find vendor code, vendor contact and the number of product supplied by each vendorDatabase MySQL using workbenge

please do all the following and step by step show me how to do it as im beginner to this.