Write SQL queries and DML statements to do these tasks

a. List the total value of all the Land Before Time movies on hand. Rename the column headings in the results table so that the report is easy to understand.

b. List order numbers of the orders with at least 3 different parts ordered.

c. List the names of all the employees and all the customers. (Hint: Think set theory)

d. Find the names and cities of employees who have taken orders for parts costing more than $20.00.

e. Find the names of customers who have ordered parts from employees living in Wichita.

f. Find the names of parts along with the number of orders they appear in, sorted in decreasing order of the number of orders.

g. Find the names of customers who have placed the highest number of orders.

h. Decrease by 15 percent the prices of all parts that cost less than $20.00.

i. Change the street address of the customer with the customer number 3333 to 321 Fir Rd.

j. Add a customer, Mary, with no address or phone number to the customers table.

Qdetails Ono Pno 1020 105061 1020 105071 1020 10508 2 1020 10509 3 1021 10601 4 1022 10601 1 1022 10701 1023 10800 1 1023 10900 2 1023 10506 1 Parts Png 10506Land Before Time I 10507Land Before Time II 15619.99 20 10508Land Before Time III 19019.99 20 10509Land Before Time VI 20019.9920 10601 10701When Harry Met Sally 120 19.9930 10800 10900 Pname QOH Price Level 200 19.99 20 Sleeping Beauty 300 24.99 20 Dirty Harry Dr. Zhivago 140 14.99 30 100 24.9930 Emplovees Customers Cno Cname 1111 Charles123 Main St 67226 316-636-5555 2222 Bertram 237 Ash Ave. 67226 316-689-5555 3333Barbara 111 Inwood St. 60606 316-111-1234 Street ZIP Phone Eno Ename ZIP 1000 Jones67226 12-DEC-95 1001 Smith6060601-JAN-92 1002 Brown 50302 01-SEP-94 Zipcodes ZIP 67226Wichita 60606 Fort Dodge 50302 Kansas City 54444 Columbia 66002 Liberal 61111 Fort Hays Orders Ono CnoEno Reived Shipped 1020 111 1000 10-DEC-94 12-DEC-94 1022 2222 1001 13-FEB-95 20-FEB-95 1023 3333 1000 20-JUN-97 null