Heading : : 1 Font Exactly Ure ai acter, acter Push arly set ur Ure Or Tore Characters 19 List all visits in which reason/diagnosis starts with diabetes. 20 List all visits in which reason/diagnosis has monitoring in it. 21 List all invoices for invoice items that have b as the third letter from the left. 22 List all patients where emails are missing. 23 List all patients where emails are not missing. Aggregate functions: sum(), count(), avg(), max(), min() 24 What is the total amount paid by insurance? 25 What is the maximum, minimum, total, and average invoice amount in our facility? 26 How many billing records we have in the billing table. From how many unique cities are our patients? 27 28 Calculate the 20% increased invoice amount and call it IncreasedAmount. Sort by invoice number, and visitID. Show all. focus DR 29 Show the patient lastname, firstname in one column and call it FullName and patient email in another column so that we can send them emails about a new preventive medicine program. (...&", "&...) How many visits were there for each invoice item? 30 31 Show the number of visits for each invoice item where the number of visits is greater than 2. 32 33 Show the number of patients in each city and zip code. Sort by city and zip. Show the number of patients in every city and zip code where the number of patients is greater than 3. Sort by city and zip. Toing 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. For each of the queries listed, include in your response (a) a screenshot of the SQL screen showing the SQL command that was run and (b) a screenshot (or equivalent) of the results generated. Number your answers corresponding to the query number. Once completed, upload your assignment in MS Word document file to Blackboard. . sbilnvoiceltem InvoiceItemID InvoiceItem EblPatient Patient ID LastName FirstName Parent Birth Date Phone Address City State Zip EmailAddress blVisit VisitD Patient ID VisitDate Reason Walkin Comments ELECT tbl Billing InvoiceNum -VisitD InvoiceDate Invoice Art InvoiceItemID Invoice Paid Insurance SELECT FROM WHERE 2 GROUP BY HAVING ORDER BY