Project 1 4210 Sp 2019 Access Queries Nursing Home Show screenshots of the queries in design mode. Show all the relevant parts of the queries (e-g, top 5). 1) uist tag, tag description, and count of deficiencies (say of survey date) in sorted descending order by the count. show top 5 rows only. tag desc CountOfsurvey date output 0441 0371 0282 0062 0309 0431 Store, cook, and serve food in a safe and clean way Provide care by qualified persons according to each resident's written Automatic sprinkler systems that have been maintained in working Provide necessary care and services to maintain or improve the highest Maintain drug records and properly mark/label drugs and other similar 98 96 86 79 2) ist cities with maximum to minimum certified bed ratios. Sort in descending order and show the top five ratios CITY .. MaxOfBEDCERT . MinOfBEDCERT,"ii-Ratio. MIAMI HIALEAl GARDE POMPANO BEA AVENTURA HOLLYWOOD 422 214 194 46 27 36 7.9 5.4 3.6 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 and average complaints. Restrict the answer to top five sum of complaints. NORTH MIAMI BEACH NORTH MIAMI POMPANO BEACH 4.2 5.0 23 25 Project 1 4210 Sp 2019 Access Queries Nursing Home Show screenshots of the queries in design mode. Show all the relevant parts of the queries (e-g, top 5). 1) uist tag, tag description, and count of deficiencies (say of survey date) in sorted descending order by the count. show top 5 rows only. tag desc CountOfsurvey date output 0441 0371 0282 0062 0309 0431 Store, cook, and serve food in a safe and clean way Provide care by qualified persons according to each resident's written Automatic sprinkler systems that have been maintained in working Provide necessary care and services to maintain or improve the highest Maintain drug records and properly mark/label drugs and other similar 98 96 86 79 2) ist cities with maximum to minimum certified bed ratios. Sort in descending order and show the top five ratios CITY .. MaxOfBEDCERT . MinOfBEDCERT,"ii-Ratio. MIAMI HIALEAl GARDE POMPANO BEA AVENTURA HOLLYWOOD 422 214 194 46 27 36 7.9 5.4 3.6 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 and average complaints. Restrict the answer to top five sum of complaints. NORTH MIAMI BEACH NORTH MIAMI POMPANO BEACH 4.2 5.0 23 25
