Write SQL statements to answer questions 1.1, 1.2, 1.3 and 1.4 based on the following schema. Primary keys are (BOLD and italicized) and attributes with the same names in different tables are foreign keys.

Doctors(doctorId INT, doctorName VARCHAR, specialty)

Patients(patientId, patientName, sex, patientBalance, numberOfVisits)

Records(doctorId, patientId, date, diagnosis, visitCost)

1.1) Create a view, called DoctorSmithsPatients, to list all the patients Dr. Smith has.

1.2) Write a trigger, each time a row is inserted in the table Records, the numberOfVisits in the corresponding Patient row is updated by 1 (i.e. add 1 to the numberOfVisits). Hint: Consider using Update statement.

1.3) Find the cost of the most expensive visit (Remember: Aggregate functions)

1.4) For each doctor, list doctor identifier, doctor name and the total number of visits that were administered by the doctor. (Remember: Aggregate/GROUP BY)