Considering the following tables
Columns: book_id (number, primary key), book_title (char), author_name (char)
Columns: shop_id (number, primary key), shop_name (char), location (char)
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')?