Answer Happy

Q2. (10 Points) Write a query to show which author never have any orders placed on his books (pull a list) Q3. (10 Points) Write a stored procedure to pass a book name and find out which calendar year it made the best business (money wise NOT no of books) and how much money was it? Q4.(10 Points) Write a transaction to delete records for all the orders which were 'cancelled' and show the output then rollback and show the output

2 book_language country customer > 2 > > > > customer_address customers cust_order employees new_table offices orderdetails order_history order_line orders o Columns orderNumber order Date requiredDate • shippedDate • status 100% > Action O comments customer Num... Indexes > > > Foreign Keys > Triggers order_status payments productlines products publisher shipping method A

2 book_language country customer > 2 > > > > customer_address customers cust_order employees new_table offices orderdetails order_history order_line orders o Columns orderNumber order Date requiredDate • shippedDate • status 100% > Action O comments customer Num... Indexes > > > Foreign Keys > Triggers order_status payments productlines products publisher shipping method A