$1.$ Write a SELECT statement to list PatientID, First Name and Last Name from the Patients. table, use appropriate aggregate function to count PatientID for females.

$2.$ Write a SELECT statement to list DoctorID, Name, Specialization, and Email from the Doctors table, use appropriate aggregate function to count the number of doctors with the specialization of 'Heart Surgeon'.

$3.$ Find minimum, maximum and average Consulation$\_$fee from Medical$\_$Records table.

$4.$Display the total number of visits and consultation fees for all patients

Help to solve sql questions