Csc 345 lab 5 1 - Study guides, Class notes & Summaries

CSC 345 Lab 5-1 Exam | Questions with Verified Answers Task 1: For each invoice, list the invoice number and invoice date along with the ID, first name, and last name of the customer for which the invoice was created. SELECT INVOICE_NUM, INVOICE_DATE, CUSTOMER.CUST_ID, FIRST_NAME, LAST_NAME FROM INVOICES, CUSTOMER WHERE INVOICES.CUST_ID = CUSTOMER.CUST_ID; Task 2: For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name, and last name of the customer...