AMS_Airline_sprint1_sql_1

--use case 1

UPDATE Booking
SET Status = 'Cancelled'
WHERE BookingID = <your_booking_id>;

UPDATE FlightSchedule
SET TicketsBooked = TicketsBooked - 1
WHERE FlightID = (SELECT FlightID FROM Booking WHERE BookingID = <your_booking_id>)
AND BookingDate = (SELECT BookingDate FROM Booking WHERE BookingID = <your_booking_id>);

BEGIN TRANSACTION;

-- Update Booking status to Cancelled
UPDATE Booking
SET Status = 'Cancelled'
WHERE BookingID = <your_booking_id>;

-- Decrement the ticket booked count for the given flight ID and booking date
UPDATE FlightSchedule
SET TicketsBooked = TicketsBooked - 1
WHERE FlightID = (SELECT FlightID FROM Booking WHERE BookingID = <your_booking_id>)
AND BookingDate = (SELECT BookingDate FROM Booking WHERE BookingID = <your_booking_id>);

COMMIT;