Dhac date: 12-Oks-2017 Return dte: 24-400-2017 Sabeaission method nptines EASTS (ooliag) Task NOTES This asigmec requines you to . Fot ga dince on hos to insiali SoL.ite, natch nis dhon Youthibs viko opsuutubs.comhatchekuste Typng the sot statenests oe the mauks is NCIT acceptable lnstructio From Rescuces oder Mais Mere in stert 2 po to Asigramere S Folder Copy sqites.exe fle from de Assignnca 5 Fusder into a foldar in your mathine Crpy a st bon the Assigenest 5 Poldor iato the folder is your machine where yoar SOt.he ile i hom the SOLite Connanal Pmmpt esecule die is tot semp. To do this, dll SOLise Commend tm ype nnad a5 sxt fuo ceoare the tables you wil usc to anower bis asiginest's qestonss Ai the SQLite Command Lise type hoders os As the SQLte Command Live Sype mode column Write aed rue SOU statects to complete the falowing tasks 1. Show sams of line totals or eact invaios 2 Locate the recoed in the vender table thet does rant have a value for the stribuic V STATE 3 Find he eustoroers wose balonce ie greater than 200 bat Sess thas 300 4. Using natoral join nd baving list the castomers whouc isvoice total is grestor than 200 5. Show the sames of the customers for whom we have isvoioes 6 Using astarall join and heving, list the custonness whose imoice sotal is greater than the averige 1. Shiw the aames of the cistomers for whom we DO NOT have imvoices. Using nataral join ad having, lis the custoeners whosc insoice total is the am . List the first name aod st same of the cistomers snd bow many times a customer has 10, I1. List the sames of the vendors who prowided producs 12 Using iner join, list the details of tbe products which sold more then 10 units o are roqaired to ssbenit . The SQL tstomests for each query, which should be copiod thom your SQLite3 Command Line nd pasted ino yout smssios file.If you type echo os al dhe SQLne Command Line, SQLihe w with tie ielubs arthe q1aery muling easy to crpy ind peste hot. The scrocnabets of the ruts of the SOL staiemeats waich are to be oupiod fhrum your SQLites suhmission Ele immedotely afher you esecute the SQL query. If ted in your you ased an sutpuc tle piease sbnt only te outpat file Dhac date: 12-Oks-2017 Return dte: 24-400-2017 Sabeaission method nptines EASTS (ooliag) Task NOTES This asigmec requines you to . Fot ga dince on hos to insiali SoL.ite, natch nis dhon Youthibs viko opsuutubs.comhatchekuste Typng the sot statenests oe the mauks is NCIT acceptable lnstructio From Rescuces oder Mais Mere in stert 2 po to Asigramere S Folder Copy sqites.exe fle from de Assignnca 5 Fusder into a foldar in your mathine Crpy a st bon the Assigenest 5 Poldor iato the folder is your machine where yoar SOt.he ile i hom the SOLite Connanal Pmmpt esecule die is tot semp. To do this, dll SOLise Commend tm ype nnad a5 sxt fuo ceoare the tables you wil usc to anower bis asiginest's qestonss Ai the SQLite Command Lise type hoders os As the SQLte Command Live Sype mode column Write aed rue SOU statects to complete the falowing tasks 1. Show sams of line totals or eact invaios 2 Locate the recoed in the vender table thet does rant have a value for the stribuic V STATE 3 Find he eustoroers wose balonce ie greater than 200 bat Sess thas 300 4. Using natoral join nd baving list the castomers whouc isvoice total is grestor than 200 5. Show the sames of the customers for whom we have isvoioes 6 Using astarall join and heving, list the custonness whose imoice sotal is greater than the averige 1. Shiw the aames of the cistomers for whom we DO NOT have imvoices. Using nataral join ad having, lis the custoeners whosc insoice total is the am . List the first name aod st same of the cistomers snd bow many times a customer has 10, I1. List the sames of the vendors who prowided producs 12 Using iner join, list the details of tbe products which sold more then 10 units o are roqaired to ssbenit . The SQL tstomests for each query, which should be copiod thom your SQLite3 Command Line nd pasted ino yout smssios file.If you type echo os al dhe SQLne Command Line, SQLihe w with tie ielubs arthe q1aery muling easy to crpy ind peste hot. The scrocnabets of the ruts of the SOL staiemeats waich are to be oupiod fhrum your SQLites suhmission Ele immedotely afher you esecute the SQL query. If ted in your you ased an sutpuc tle piease sbnt only te outpat file