1) Create a view 'VIEW BEST_RATED_DOCTOR' that shows the average rating and total count of ratings...

Transcribed Image Text:

1) Create a view 'VIEW BEST_RATED_DOCTOR' that shows the average rating and total count of ratings for each Doctor. a. Display attributes as "Doctor ID" "Doctor Name" - with space between first name and last name • "Number of ratings" for each doctor "Average Rating" for each doctor-rounded to 2 decimal places b. Only consider ratings from start of 2020 c. Sort results by average rating in descending order. 1) Create a view 'VIEW BEST_RATED_DOCTOR' that shows the average rating and total count of ratings for each Doctor. a. Display attributes as "Doctor ID" "Doctor Name" - with space between first name and last name • "Number of ratings" for each doctor "Average Rating" for each doctor-rounded to 2 decimal places b. Only consider ratings from start of 2020 c. Sort results by average rating in descending order.

Answer rating: 100% (QA)

Assuming we have a database with the following schema DOCTOR DoctorID DoctorName RATING DoctorID Rat... View the full answer