SQL

vendor V_CODE INT(11) V_NAME VARCHAR(35) V_CONTACT VARCHAR(15) V_AREACODE CHAR(3) V_PHONE CHAR(8) V_STATE CHAR(2) V_ORDER CHAR(1) Indexes customer CUS_CODE INT(11) CUS_LNAME VARCHAR(15) CUS_FNAME VARCHAR(15) CUS_INITIAL CHAR(1) CUS AREACODE CHAR(3) CUS_PHONE CHAR(8) CUS_BALANCE DECIMAL(9,2) CUS_PPBAL DECIMAL(9,2) Indexes product P_CODE VARCHAR(10) P_DESCRIPT VARCHAR(35) P_INDATE DATETIME P_QOH INT(11) P_MIN INT(11) P_PRICE DECIMAL(8,2) P_DISCOUNT DECIMAL(4,2) V_CODE INT(11) PREORDER INT(11) Indexes + line INV_NUMBER INT(11) LINE_NUMBER DECIMAL(2,0) P_CODE VARCHAR(10) LINE_UNITS DECIMAL(9,2) LINE_PRICE DECIMAL(9,2) Indexes Triggers invoice INV_NUMBER INT(11) CUS_CODE INT(11) INV_DATE DATETIME Indexes List the names of products and their total units sold during the month of January 2016 (Hint: use "YYYY-MM-DD' as the date format) Your output should be: Product Units Sold 11.00 1.00 7.25-in. pwr. saw blade Hrd. doth, 1/4-in., 2x50 B&D jigsaw, 12-in. blade B&D cordless drill, 1/2-in. Claw hammer 1.00 1.00 5.00 6.00 1.00 Rat-tail file, 1/8-in. fine Hicut chain saw, 16 in. PVC pipe, 3.5-in., 8-ft 1.25-in. metal screw, 25 Steel matting, 4x8'x1/6", .5* mesh 17.00 3.00 3.00 Required: BETWEEN GROUP BY SUM