Question: Write SQL code please. Tables are attached with input fields for reference. Business Problem #1 The Marketing Department would like to send out a communication
Business Problem #1 The Marketing Department would like to send out a communication to all vendors that have no business activities with the firm (i.e. no Payment Total records). Prepare a SQL query that will list all vendors who should be contacts? Output the following: Vendor Name Payment Total Business Problem #2 Prepare a listing that shows summary totals for all vendors by Credit Totals. Output fields that interest you besides Vendor Name. Business Problem #3 The Fraud Department suspects that invoice numbers in the range of 989319-427 thru 989319-999 could be fraud. They require the Data Analyst team to prepare a detailed listing with the following . Vendor Name . Invoice Number Invoice Date Invoice Total Invoice Due Date Business Problem #4 ral Ledger Accounts' table contains information about accounts. The 'Invoice_Line_Items' table contains details about Invoice Line Item Amount. The business requires a report that identifies all Invoice Line Items for Account Description 'Book Production. Create a report that has the following fields: Account Description . AccountNo Line_Item_Amt Business Problem #5 Using the 'Invoices' table, identify all Invoice Totals that is greater than $100 and Payment Totals less than $5000.00. Lastly sort the output by 'Invoice Due Date
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
