WRITE IN SQL LANGUAGE:

Consider the following ER diagram:

The relations will contain $($but are not limited to$)$ the following attributes:

DOCTORS $($first$\_$name, last$\_$name, specialty$)$

APPOINTMENTS $($date$,$ start$\_$time, end$\_$time, price$)$

PATIENTS $($first$\_$name, last$\_$name, date$\_$of$\_$birth$)$

Write a statement that will generate the following result and explain the relational algebra

operations which are required: "Display the doctors' full names, specialties, number of appointments

and average appointment price for the current month ordered by the appointment date in ascending

order". The result will include the following attributes: