CONSUMER TABLE
CUS_CODE
CUS_LNAMECUS_FNAMECUS_INITIALCUS_AREACODECUS_PHONECUS_BALANCE10010RamasAlfredA615844-2573010011DunneLeonaK713894-1238010012SmithKathyW615894-2285345.8610013OlowskiPaulF615894-2180536.7510014OrlandoMyron615222-1672010015O’BrianAmyB713442-3381010016BrownJamesG615297-1228221.1910017WilliamsGeorge615290-2556768.9310018FarrissAnneG713382-7185216.5510019SmithOletteK615297-38090EMP TABLEEMP_NUMEMP_TITLEEMP_LNAMEEMP_FNAMEEMP_INITIALEMP_DOBEMP_HIRE_DATEEMP_AREACODEEMP_PHONEEMP_MGR100Mr.KolmyczGeorgeD1942-06-151985-03-15615324-5456101Ms.LewisRhondaG1965-03-191986-04-25615324-4472100102Mr.VanDamRhett1958-11-141990-12-20901675-8993100103Ms.JonesAnneM1974-10-161994-08-28615898-3456100104Mr.LangeJohnP1971-11-081994-10-20901504-4430105105Mr.WilliamsRobertD1975-03-141998-11-08615890-3220106Mrs.SmithJeanineK1968-02-121989-01-05615324-7883105107Mr.DianteJorgeD1974-08-211994-07-02615890-4567105108Mr.WiesenbachPaulR1966-02-141992-11-18615897-4358109Mr.SmithGeorgeK1961-06-181989-04-14901504-3339108110Mrs.GenkaziLeighlaW1970-05-191990-12-01901569-0093108111Mr.WashingtonRupertE1966-01-031993-06-21615890-4925105112Mr.JohnsonEdwardE1961-05-141983-12-01615898-4387100113Ms.SmytheMelanieP1970-09-151999-05-11615324-9006105114Ms.BrandonMarieG1956-11-021979-11-15901882-0845108115Mrs.SarandaHermineR1972-07-251993-04-23615324-5505105116Mr.SmithGeorgeA1965-11-081988-12-10615890-2984108INVOICE TABLEINV_NUMBERCUS_CODEINV_DATEINV_SUBTOTALINV_TAXINV_TOTAL1001100142008-01-1624.91.9926.891002100112008-01-169.980.810.781003100122008-01-16153.8512.31166.161004100112008-01-1734.972.837.771005100182008-01-1770.445.6476.081006100142008-01-17397.8331.83429.661007100152008-01-1734.972.837.771008100112008-01-17399.1531.93431.08LINE TABLEINV_NUMBERLINE_NUMBERP_CODELINE_UNITSLINE_PRICELINE_TOTAL1001113-Q2/P2114.9914.991001223109-HB19.959.951002154778-2T24.999.98100312238/QPD138.9538.95100321546-QQ2139.9539.951003313-Q2/P2514.9974.951004154778-2T34.9914.971004223109-HB29.9519.910051PVC23DRT125.8770.4410061SM-1827736.9920.97100622232/QTY1109.92109.921006323109-HB19.959.951006489-WRE-Q1256.99256.991007113-Q2/P2214.9929.981007254778-2T14.994.9910081PVC23DRT55.8729.3510082WR3/TT33119.95359.851008323109-HB19.959.95PRODUCT TABLEP_CODEP_DESCRIPTP_INDATEP_QOHP_MINP_PRICEP_DISCOUNTV_CODE23114-AASledge hammer, 12 lb.1/2/20088514.40.0554778-2TRat-tail file, 1/8-in. fine12/15/200743204.9902134489-WRE-QHicut chain saw, 16 in.2/7/2008115256.990.0524288PVC23DRTPVC pipe, 3.5-in., 8-ft2/20/2008188755.870SM-182771.25-in. metal screw, 253/1/2008172756.99021225SW-231162.5-in. wd. screw, 502/24/20082371008.45021231WR3/TT3Steel matting, 4’x8’x1/6″, .5″ mesh1/17/2008185119.950.12559511QER/31Power painter, 15 psi., 3-nozzle11/3/200785109.9902559513-Q2/P27.25-in. pwr. saw blade12/13/2007321514.990.052134414-Q1/L39.00-in. pwr. saw blade11/13/2007181217.490213441546-QQ2Hrd. cloth, 1/4-in., 2×501/15/200815839.950231191558-QW1Hrd. cloth, 1/2-in., 3×501/15/200823543.990231192232/QTYB&D jigsaw, 12-in. blade12/15/200785109.920.05242882232/QWEB&D jigsaw, 8-in. blade12/24/20076599.870.05242882238/QPDB&D cordless drill, 1/2-in.1/20/200812538.950.052559523109-HBClaw hammer1/20/200823109.950.12122523114-AASledge hammer, 12 lb.1/2/20088514.40.05VENDOR TABLEV_CODEV_NAMEV_CONTACTV_AREACODEV_PHONEV_STATEV_ORDER21225Bryson, Inc.Smithson615223-3234TNY21226SuperLoo, Inc.Flushing904215-8995FLN21231D&E SupplySingh615228-3245TNY21344Gomez Bros.Ortega615889-2546KYN22567Dome SupplySmith901678-1419GAN23119Randsets Ltd.Anderson901678-3998GAY24004Brackman Bros.Browning615228-1410TNN24288ORDVA, Inc.Hakford615898-1234TNY25443B&K, Inc.Smith904227-0093N25501Damal SuppliesSmythe615890-3529TNN25595Rubicon SystemsOrton904456-0092FLY
Write and run SQL statements to complete the followingtasks
Show sums of line units for each invoice.
Show the details of the products that do not have a value forthe attribute v_code.
Show the
PayPal Gateway not configured
PayPal Gateway not configured