Write the SQL commands based on the tables given below. a)Display the list of Patientscontaining PatientName, PatientContactand PatientEmailwith Patient’s name begin with ‘S’. b)Display the AppointmentDate, AppointmentTime, PatientName and DentistNamefor all appointmentsin month ofSeptember. c)Add a new attribute called Statusin the Appointments table. The length is 20 characters the default value is ‘Active’.
Write the SQL commands based on the tables given below.
a)Display the list of Patientscontaining PatientName, PatientContactand PatientEmailwith Patient’s name begin with ‘S’.
b)Display the AppointmentDate, AppointmentTime, PatientName and DentistNamefor all appointmentsin month ofSeptember.
c)Add a new attribute called Statusin the Appointments table. The length is 20 characters the default value is ‘Active’.
d)Display the Patient Name and the total number of appointments for every patientso farand sort according to the patient’s name.
e)Display how much Dentist called Faezahhave charged for the patients’ treatments so far.
f)Display the cheapest treatment price.
g)Azmi require another follow up appointment for teeth cleaning. Create an SQL statement to add the appointment. The appointment should on the 5thDecember 2021and the time should be the same time for the previous appointment and attended by the same doctor.
h)Display all patients that have been treated by ‘Filling and Repairs’ and ‘Teeth Cleaning’.Use the IN keyword in your answer.
i)Shahir need to reschedule to appointment from 7thSeptember to 9thSeptember. Create an SQL statement to change the appointment.
Step by step
Solved in 3 steps with 1 images