Answer Happy

MYSQL database: Provide the screenshot of the query and
output.
Please solve it in 2 hrs.
Tables address Columns address_id street_number street_name city country_id Indexes PRIMARY fk_addr_ctry Foreign Keys fk_addr_ctry Triggers address_status Columns status_id address_status Indexes PRIMARY Foreign Keys Triggers author Columns author_id author_name Indexes PRIMARY Foreign Keys Triggers

book Columns book_id title isbn13 language_id num_pages publication_date publisher_id Indexes PRIMARY fk_book_lang fk_book_pub Foreign Keys fk_book_lang fk_book_pub Triggers book_author Columns book_id author_id Indexes PRIMARY fk_ba_author Foreign Keys fk_ba_author fk_ba_book Triggers book_language Columns language_id language_code language_name Indexes PRIMARY Foreign Keys Triggers

country Columns country_id country_name Indexes PRIMARY Foreign Keys Triggers cust_order Columns order_id order_date customer_id shipping_method_id dest_address_id Indexes PRIMARY fk_order_cust fk_order_ship fk_order_addr Foreign Keys fk_order_addr fk_order_cust fk_order_ship Triggers customer Columns customer_id first_name last_name email Indexes PRIMARY Foreign Keys Triggers

customer_address Columns customer_id address_id status_id Indexes PRIMARY fk_ca_addr Foreign Keys fk_ca_addr fk_ca_cust Triggers order_history Columns history_id order_id status_id status_date Indexes PRIMARY fk_oh_order fk_oh_status Foreign Keys fk_oh_order fk_oh_status Triggers order_line Columns line_id order_id book_id price Indexes PRIMARY fk_ol_order fk_ol_book Foreign Keys fk_ol_book fk_ol_order Triggers

order_status Columns status_id status_value Indexes PRIMARY Foreign Keys Triggers payments Columns customerNumber checkNumber paymentDate amount Indexes PRIMARY Foreign Keys payments_ibfk_1 Triggers publisher Columns publisher_id publisher_name Indexes PRIMARY Foreign Keys Triggers shipping_method Columns method_id method_name cost Indexes PRIMARY Foreign Keys Triggers

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