Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using Microsoft Access, can someone help with the full sql statements based on their respective question to ensure it properly functions? Thank you You are
Using Microsoft Access, can someone help with the full sql statements based on their respective question to ensure it properly functions? Thank you
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 busines:s decisions that will help the practice grow. Write the SQL statement for each query and save them in MS Access as Q1, Q2,.. (including those that we covered in the practice and those that were left for you to solve highlighted in blue) so that the physician can run them at a later time and submit the MS Access file in Blackboard blPatient PatientID bVisit VisitID bllnvoiceltem InvoiceltemID blBill FirstName Parent BirthDate Phone Address City State Zip EmailAddress Reason WalkIn InvoiceltemID InvoicePaid Colm SELECT sabinet FROM Condonal Expressn WHERE2 GROUP BY 3ondion HAVING ORDER BY6 Query Question SQL Statement 1 Show all fields in the billing table 2 List all cities of our patients (no redundancy) 3 List all billings created after 1/1/2016 List all billings where invoice amounts are more than 200 We want to know the number of visits patients from Bloomfield made, who have the following patient ID 22501, 22506, 22513, 22521, 2252, 22522, 22549 22557 We want to know the number of visits patients from 4 6 Bloomfield made? What if we do not know their patient IDs? Can you create a subquery to using the two above using the SQL IN Keyword? Can you show an example of an SQL cross join 7 8 (Cartesian product) for the iovoiceitem and billing tablesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started