With the entity relationship diagram in mind, is it possible to answer these questions using joins in SQL server and if so to show scripts used? If not, what is the correct way?

1.Doc Rob Belkin is retiring. We need to inform all his patients, and ask them to select a new doctor. For this purpose, Create a VIEW that finds the names and Phone numbers of all of Rob's patients.

2.Create a view which has First Names, Last Names of all doctors who gave out a prescription for Panadol

3.Create a view which Shows the First Name and Last name of all doctors and their specialtys

4.Modify the view created in Q3 to show the First Name and Last name of all doctors and their specialties ALSO include doctors who DO NOT have any specialty

Person Personi FirstName Speciality Speciality SpecialityName LastName StreetAddress City Doctor Doctorid MedicalDegrees State Tip Personi PhoneNumber SSN DoctorSpeciality 8 Doctorib 8 Speciality D PVisitPrescription % Visit 8 PrescriptionID Patient 8 Patients SecPhone Number DOB Personi Patient Visit 8 VisitID Patienti Doctor VisitDate DocNote Prescription 8 Prescription PrescriptionName Test TestiD TestName PVisitTest 8 VisitD 8 TestID