INFS 6330 - Project 1 Assignment Week 1-SQL Structured Query Language (SQL) Objective In this project, we are going to use MS Access to practice how to run SQL queries that help transform data into information to support managerial decision making. Task You are given a database in a MS Access file called "Clinic that contains data collected in a physician practice. The physician hired you as a data analyst to answer questions the physician needs answers to in order to help her make business decisions that will help the practice grow. Write the SQL statement for each query and save them in MS Access as Q1, Q2,... so that the physician can run them at a later time and submit the MS Access file in Blackboard. (to help you answer these questions, you shoud practice running the practice SQL queries shown in the videoes). invoice tem InvoiceItemID Invoiceltem blVisit Visit Patient VisitDate Reason Wakin Comments SELECT EbPatient PatientID LastName FirstName Parent BirthDate Phone Address City State Zip EmailAddress blBilling InvoiceNum VisitD InvoiceDate InvoiceAmt InvoiceItemID Invoice Paid Insurance FROM 1 WHERE GROUP BY HAVING ORDER BY 4 Query Question SQL Statement 1 Show the visit reason, date, and whether it was walkin 2 Show all fields in the visit table 3 List all reasons for visits (no redundancy) List the top 10 visits 5 List the top 5% visits Other Where Clause Operators The comparison operators available in SQL include the six operators (s, (not equals). > IN, LIKE, NOT, BETWEEN, NULL Values), which can be used to compare values in the Where clause. They are used to compare numeric expressions with other numeric expressions and string expressions with other string expressions. 6 List all visits taken place after 1/1/2016. 7 List all billings where invoice amounts are more than 100 8 9 9 List lastname, firstname, and city for patients from Windsor city. Show all billing columns and sort them by invoice number Show all billing columns and sort them by invoice amount gescendingly and by invoice number ascendingly 10