Task 3 (Monthly Sale Information): List February's ordering information and sort the results in descending order based on the pay amount. Rename and format the column payAmount as the following output. *Output* Date paysethod Task 4 (Monthly Sale Analysis): List the total number and the total amount of orders placed in February 2024. Rename the columns and format one of the columns as indicated in the following output. ***Output** Orders in February 2024 (0.000 sec) Task 5 (Frequent purchasing customers): List the ID of customers with two or more orders in February 2024 and the total number of orders this month. Rename one of the columns as the following output. CustID 920111222 920111227 920111266 **Output* Number of Orders in February 2024 rows in set (0.001 sec) Assignment Submission Instructions: This is an individual assignment - no group submissions are allowed. Submit a script file that contains the SELECT statements by assigned date. The outline of the script file lists as follows: Name: YourNameGoesHere * Class: CST 235 * Section: Date: *I have not received or given help on this assignment: YourName USE RetailDB; ####### Tasks: Write SQL Queries ######### --Task 1 (Customer Information): --List your SELECT statement below. --Task 2 (Inventory Control): --List your SELECT statement below. --Task 3 (Monthly Sale Information): --List your SELECT statement below. --Task 4 (Monthly Sale Analysis): --List your SELECT statement below. --Task 5 (Frequent purchasing customers): -List your SELECT statement below. Let us consider the following relational database. The primary key column(s) of each table is denoted by an underline. The foreign keys are italicized. Schema: Customers (custID, fName, IName, password) Phones (custID, phone) Items (ilD, name, price, qtyInStock) Orders Places (olD, ordDate, shippingDate, receivalDate payAmount, payMethod, custID) Contain (o/D, iID, price, qty) Specifically, the foreign keys for this database are as follows: the column custID of relation Phones that references table Customers, the column custID of relation Orders Places that references table Customers, the column oID of relation Contain references table Orders Places, and the column iID of relation Contain references table Items, For your convenience, the SQL statements for creating these tables are available in the file retailDB.sql. Download it on your computer and run it to build the retailDB database on the MySQL database server. Write one SQL query statement for each of the following queries and run them on the MySQL Database Server. The query answers must not contain duplicates, and you should use the SQL keyword DISTINCT only when necessary. Execute your queries based on these tables. Please put query (SELECT) statements into a SQL script file and save it as lab4YourLastName.sql. Then, submit it to the Assignment Link - Lab 4 Assignment. Task 1 (Customer Information): Retrieve the ID and name of all customers and display the results as the following output. CustID 555000201 555000262 11666 **Output* Jazmine Elzey Jalen Harrison Clark Kent Peter Parker Alice Johnson Bob Seith John Doe Dante Grante Johnson Washington Jane Swith Lebron Smith Kevin Smith Jake Frost Anthony Seith Sarah Brown Terry Donaldson Jack Willians Larry Taylor Mary Price Nor Lee Alonzo Mckee Sarah Sheet Kyle Haskett Aiden Harber Miles Brown Jazmine Jenkins 27 rows in set (0.001 sec) Task 2 (Inventory Control): Retrieve information on items with a quantity in stock below 10. Its results should be the same as the following output. **Output* iID пале ❘ price qtyInStock @cr78 red boots 36.30 012 web shooters 42.30 11234 Flashlight 15.50 50002 Himalayan Salst 10.99 rows in set (0.000 sec)