I need help with the Format for the SQL Script, can someone break down the logic for me?

Complete the following exercise: Write SQL statements for questions given below for the PetStore database (Script for Pet Store database is available in the Resources section). Save your SELECT statements as Qry1, Qry2, ..., Qry7 in a MS Word document. In the MS Word document, undereach SQL query statement include tire result-set gene rate the query. If the result-set has more than 20 rows then include in your MS Word document part of tire result-set. Submit printout of the MS Word document containing your SQL SELECT statements and result-sets. Please upload text file containing your SQL SELECT statements and MS Word document to TRACS. List tire Item ID, Description, Quantity on hand, and List price for all merchandise items for category cat with quantity on hand of more than 50 and list price of greater than or equal to $5.00. Display re suit-set in descending order of the list price. List tire number of dogs sold and tire total sales generated by dogs sold between January^st, 2007 and April 15^th, 2007. Display tire number of dogs sold and total sales amount with appropriate column headings. Based on tire sale price of tire animals sold, find tire most expensive dog(s) sold during January 2007. Display the animal D, breed, category, gender, list price, and sale price. List all cats that were sold for at least 65% more than their cost (Cost column in Animal Item table) during tire first three months of 2007 (Sale Date column). Display Animal ID, Category, Breed, Cost, Sale Price, and Profit made for each of tire see cats sold in descending order of tire amount of Profit (Sale Price - Cost). List animal categories for which tire Pet Store sold five or more animals during tire first six months of year 2007. Display animal category and number of annuals sold for each of these categories in descending order of tire number of animals sold. Which cat breed(s) was purchased most by customers during tire first three months of 2007? Display tire Category, Breed, and tire average Sale price of this cat breed(s). List Animal ID, Category, Bleed, Gender, and Sale Price for all dogs that sold (sale price) for more than tire average sale price of all dogs sold by tire Pet Store. Display result in descending order of sale price. Complete the following exercise: Write SQL statements for questions given below for the PetStore database (Script for Pet Store database is available in the Resources section). Save your SELECT statements as Qry1, Qry2, ..., Qry7 in a MS Word document. In the MS Word document, undereach SQL query statement include tire result-set gene rate the query. If the result-set has more than 20 rows then include in your MS Word document part of tire result-set. Submit printout of the MS Word document containing your SQL SELECT statements and result-sets. Please upload text file containing your SQL SELECT statements and MS Word document to TRACS. List tire Item ID, Description, Quantity on hand, and List price for all merchandise items for category cat with quantity on hand of more than 50 and list price of greater than or equal to $5.00. Display re suit-set in descending order of the list price. List tire number of dogs sold and tire total sales generated by dogs sold between January^st, 2007 and April 15^th, 2007. Display tire number of dogs sold and total sales amount with appropriate column headings. Based on tire sale price of tire animals sold, find tire most expensive dog(s) sold during January 2007. Display the animal D, breed, category, gender, list price, and sale price. List all cats that were sold for at least 65% more than their cost (Cost column in Animal Item table) during tire first three months of 2007 (Sale Date column). Display Animal ID, Category, Breed, Cost, Sale Price, and Profit made for each of tire see cats sold in descending order of tire amount of Profit (Sale Price - Cost). List animal categories for which tire Pet Store sold five or more animals during tire first six months of year 2007. Display animal category and number of annuals sold for each of these categories in descending order of tire number of animals sold. Which cat breed(s) was purchased most by customers during tire first three months of 2007? Display tire Category, Breed, and tire average Sale price of this cat breed(s). List Animal ID, Category, Bleed, Gender, and Sale Price for all dogs that sold (sale price) for more than tire average sale price of all dogs sold by tire Pet Store. Display result in descending order of sale price