Q4. (10 Points) Write a transaction to delete records for all the orders which were 'cancelled' and show the output then
Posted: Fri May 20, 2022 3:45 pm
Tables > address address_status author Columns > author_id author_name > Indexes Foreign Keys Triggers book Columns book_id .title isbn13 language_id • num_pages publication_date publisher_id Indexes Foreign Keys Triggers book author Columns book_id • authorid > Ga Indexes Foreign Keys > Triggers > > 2
book_language country > customer customer_address customers > > > > 100% cust_order employees new_table offices orderdetails order_history order_line orders Los Columns orderNumber order Date requiredDate shippedDate status Action O V • comments > customerNum... > Indexes > Foreign Keys > Triggers order_status payments productlines products publisher shipping method > >