Considering the following tables
Books
Columns:
book_id (number, primary key), book_title (char), author_name (char)
Shops
Columns:
shop_id (number, primary key), shop_name (char), location (char)
Shop_Books
Columns:
shop_id (number), book_id (number)
Combination of values of shop_id and book_id in
Shop_Books table is unique.
Which SELECT statement shows all the books which author name contains 'Allen' and can be purchased in shops situated in USA (location = 'USA')?