SQL

The salesDB database contains 5 tables, and you can find the database diagram below. 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 all customer and product information for all products sold in January 2016 to customers whose last name starts with the letter o. You must use the EXTRACT datetime function to extract the month and year from the date. Details with examples of the EXTRACT function are available at https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_extract HINT: Use Tablel.*, Table2.* if you want to display all columns from 2 tables when joining 3 or more tables together. Required: EXTRACT JOIN