MS Access SQL Query
Description
Write SQL queries based on the database in excel.
1. Create a Relationships between all the tables imported in part A as per your understanding.
2. Display Invoice item ids, Invoice names, and average invoice for each invoice item in descending order, If the item average is greater than $200.
3. Provide billing details (Invoice number, visitID, date, item name and id, amount) for those invoices which are not billed for ‘Lab work’, ‘Pharmacy’ and ‘Office visit’ and whose payment is not made. Also calculate the 7 % interest on the billed amount and display both interest amount as Late Penalty and the new billed amount.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
