Q2. (10 Points) Write a query to show which author never have any orders placed on his books (pull a list) Q3. (10 Point

[answerhappygod]

Q2 10 Points Write A Query To Show Which Author Never Have Any Orders Placed On His Books Pull A List Q3 10 Point 1 (17.65 KiB) Viewed 34 times

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