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."
Complete the 
Complete the order payment after filling in the order form. We’ll receive your order and assign it to a writer.
The assigned writer will complete your paper and forward it to our Editing Team for review and approval.
Once approved by the editor, the completed paper will be uploaded to your account for you to download, review and approve.