4. Create a text file called nnnn_query.txt (where nnnn is your student number). The file should include the SQL statements necessary to display the following reports: a. List all details of all the records in the customers table, sorted by suburb in ascending order.b. List all the titles of all the items in inventory with their supplier's name, suburb and postcode.c. List all the actors who are deceased. Print their name as one column with a suitable heading, their date of birth and their date of death.d. List all of the inventory by genre. Display the title and the genre of each.e. List all the DVDs in the shop. Include DVD name, genre, classification, star rating and director name.f. List all genres that have no titles.g. Delete the customer Pat Jones.h. Change customer Mary Spring's name to Mary Fitzpatrick.i. List all the DVDs titles with their cast and their director. Print the name of the actors and the directors in one column for each with an appropriate title.j. Insert a book with the title "Food Forests for Dummies" (genre gardening) written byFlora Birch in 2016. The author was born in Sherwood (UK) on the 1st of April 1950. The book was published by Green and Friendly Publications at 123 Poplar Dr, Oakwood, 3546, email [email protected], phone 4561327895, and contact Daisy Appleyard. The wholesale price is $20 and the mark up is 40%. The shop has 5 in stock and there is no discount applicable to this item.k. List all the inventory with its title, its quantity on hand and its sales price (wholesale plus markup).l. List every item in inventory with its title, genre and whether it is a book or a dvd.