Page 1 of 1
Q2. (10 Points) Write a query to show which author never have any orders placed on his books (pull a list) Q3. (10 Point
Posted: Fri May 20, 2022 3:01 pm
by 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 35 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