Question paper (build 07.05.20.19)
-- test case 2 -> TotalAmount of the order with OrderID = 6 will be updated
8 of 8
Paper No: 10
delete from OrderDetails where OrderID = 6 and ItemID = 1
Question 10:
Write SQL statements to create a new reservation for a customer. The reservation should be
made for CustomerID = 7, with 5 guests, on November 20, 2025, at 19:15 PM. The
ReservationID should be 210.
After inserting the reservation into the Reservations table, assign the reservation to a table in
the Reservation Tables table. The assigned table should be the one with the smallest
TableID among all tables that have a capacity greater than or equal to 5.
