solve all the questions from 7 to 10 and write in a proper sql programming codes

7) Create a SELECT statement that returns vendor-name e invoice number invoice date eline item amount e account_description for all invoices where the balance due is greater than O [invoice minus credit minus payment). Order by both vendor name and line item amount in descending order. Should return 11 rows Dook Printina Costs Book Printng Costs 201407-23 20551 1 201407-31 1097506 202407-21 9.42 201407-24 03. 2014-07-22 67.92 201407-21 14-07225 201407-22 30.75 201407-10 85.3 ngram 1361833 Books. Dues. and Subecretions Motor Credt Comoan 8277 federal txoress Corporation 263253270 Federal Exeres Coroaon Federal Express Corporation 96325326 263253268 37 Exoress Corporation 263253273 Data Reoroductions Cor 9104 140728 903 201408-01 224.00 Book Printino Cot Drect Mal Advertisino Group Insurance Businecs Meda. inc 13416 Blue Cross 547102 8) Create a query that produces the following output (No further explanation should be necessary) unber of Lowest Invoice Highest Invoice Tota 879.741356 9) Display the vendor name and average invoice totals for each vendor that has submitted an invoice where the average invoice total is greater than $1000. Display the average to two decimal points. Sort by average invoice total in descending order. Should get 12 rows. Average inwoice Uthoorachino Inc Dioita Dreamworks 125.34 Tesmed. Inc 49012 2575 33 2433.00 Parcel Service Cahners Publishing Companv 2184.50 750.00 Tax Board ean Witter Renolds 1%7.50 077.21 Display the number of vendors who submitted an invoice. Number of vendors who subitted an 7) Create a SELECT statement that returns vendor-name e invoice number invoice date eline item amount e account_description for all invoices where the balance due is greater than O [invoice minus credit minus payment). Order by both vendor name and line item amount in descending order. Should return 11 rows Dook Printina Costs Book Printng Costs 201407-23 20551 1 201407-31 1097506 202407-21 9.42 201407-24 03. 2014-07-22 67.92 201407-21 14-07225 201407-22 30.75 201407-10 85.3 ngram 1361833 Books. Dues. and Subecretions Motor Credt Comoan 8277 federal txoress Corporation 263253270 Federal Exeres Coroaon Federal Express Corporation 96325326 263253268 37 Exoress Corporation 263253273 Data Reoroductions Cor 9104 140728 903 201408-01 224.00 Book Printino Cot Drect Mal Advertisino Group Insurance Businecs Meda. inc 13416 Blue Cross 547102 8) Create a query that produces the following output (No further explanation should be necessary) unber of Lowest Invoice Highest Invoice Tota 879.741356 9) Display the vendor name and average invoice totals for each vendor that has submitted an invoice where the average invoice total is greater than $1000. Display the average to two decimal points. Sort by average invoice total in descending order. Should get 12 rows. Average inwoice Uthoorachino Inc Dioita Dreamworks 125.34 Tesmed. Inc 49012 2575 33 2433.00 Parcel Service Cahners Publishing Companv 2184.50 750.00 Tax Board ean Witter Renolds 1%7.50 077.21 Display the number of vendors who submitted an invoice. Number of vendors who subitted an