+1 (845) 317-8489 [email protected]
  • Lets create 3 reports analyzing these problems. Below are the tables and attributes.


  • Open DB Browser, start a new database, choose folder, give it a name,
  • import csv tables (invoicing.cvs and receiving.cvs).File/Import.Make sure to click on column names in first line box
  • Write and run SQL code for the following Questions
  • What items match on PO, Item#, and what is the variance?Use SQL to create a table for matched items that calculates the variance.Add a criteria for PPV > $5. then export it
  • What inventory items did we receive but have no invoice?
  • What invoice did we receive but have not received the inventory items?