Oracle PL/SQL Project

I need someone to create the PL/SQL scripts that are included in description below. The database is already created i just need someone to make the PL/SQL scripts. I also need you to fix up some of the queries that are not functioning properly. So feel free to change some of the tables or alter them. It also has to be done within 24hrs. SQL quires: · Show how many orders were made in September 2016 ( or other month matching your data) · Show the item name which is on a greatest number of orders · Show the shop name with the total cost of all orders greater than average · Retrieve the names of a items which are not on any order · List all order details (customer name, item name, quantity, and date ) for all orders in the nearest month (the last month matching your data) · Update a particular order changing its dispatch date to later ( make up the date) plsql: 1. Create a procedure display_orders() that takes a customer id as a parameter and displays all the orders’ details for this customer (customer name, item name, quantity, total price, and order date). Create also anonymous block to prompt for customer id and to run the procedure. 2. Create a procedure to insert a new order for a customer. Use all required values as input parameters. Create also anonymous block to prompt for customer id and run the procedure 3. Create a procedure to update a certain item changing quantity in stock. Use all required values as input parameters. Create also anonymous block to prompt for item id and to run the procedure. 4. Create a procedure which displays all suppliers for a particular item. Use item id as an input parameter. Create also anonymous block to prompt for item id and to run the procedure