healthcare database query

Sample Project 1: Access Queries Nursing Home

HIM6865 2022

Show screenshots of the queries in design mode. Show all the relevant parts of the queries (e.g., top 5).

1) List tag, tag description, and count of deficiencies (say of survey date) in sorted descending order by the count. Show top 5 rows only.

2) List cities with maximum to minimum certified bed ratios. Sort in descending order and show the top five ratios.

3) Find out providers in Broward county that have been faulted for deficiency 0365. Show the result in ascending order by provnum.

4) List cities along with sum of number of complaints, average complaints, and count of complaints. Display the answer by descending order of sum of complaints. Show top 5 rows only.

1