Home Work Question… For mysql, need some help answering it….attached is the same questions but with a

picture of the table.

 The SQL Relational Set operators can greatly simplify certain query tasks. However, not every relational database management system, such as MySQL, implements all of the relational set operators. Given the following partial ERD showing the BOOKS and ORDER_ITEMS tables, discuss how queries equivalent to the MINUS operator can be crafted, and provide an example SQL query, using the tables provided. Your answer should both characterize the general approach for replacing this relational set operator, as well as the specific SQL query to replace it in order to generate an equivalent result set.

The ORDER_ITEMS table contains records of all books that have ever been ordered. The BOOKS table contains a list of all books available for sale through the store. The following SQL will show BOOKIDs for those books currently available that have never been ordered previously.
SELECT BOOKID
FROM BOOKS
MINUS
SELECT BOOKID
FROM ORDER_ITEMS;

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"