7 of 7
Paper No: 12
values (70,'Van Chien', 'Nguyen', '0928367812', '
[email protected]', null),(71, 'Thi Binh', 'Nguyen', '0989278127', '
[email protected]',5)
select * from Doctors where DoctorID in (70,71)
DoctorID
70
FirstName
LastName
Phone Number Email
1
2 71
DepartmentID
0928367812
[email protected] 1
Van Chien Nguyen Thi Binh Nguyen
0989278127
Picture 9.1
[email protected] 5
Question 10:
Write statements to delete from the Tests table two tests named 'Blood Test' and 'CT Scan'and to delete also from the AppointmentTests table all rows corresponding to those two tests.
Zoom
+ 100%
Close
