Answer Happy

Posted: **Fri May 20, 2022 3:45 pm**

: 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 (11.25 KiB) Viewed 25 times

: Q2 10 Points Write A Query To Show Which Author Never Have Any Orders Placed On His Books Pull A List Q3 10 Point 2 (22.19 KiB) Viewed 25 times

: Q2 10 Points Write A Query To Show Which Author Never Have Any Orders Placed On His Books Pull A List Q3 10 Point 3 (27.94 KiB) Viewed 25 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?

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

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