DML Sub Query, Set Operator and Multitable Query. Write the command:

1. A. With Inner Join, to display the name of the Customer who has done shopping and the book title purchased B. With Outer Join, to display book titles that have not and have been purchased

Please answer according to question

Author Name varchar(255) N Address varchar(255) N URL varchar(255) N Publisher Name varchar(255) N Address varchar(255) N Phone varchar(255) N URL integer(10) N Customer 9 Email varchar(255) Name varchar(255) Phone varchar(255) Address varchar(255) N zzz N Book ISBN varchar(255) PublisherName varchar(255) AuthorName varchar(255) AuthorAddress varchar(255) Year integer(10) Title varchar(255) Price numeric(19,0) N Shopping Basket Book Shopping Basket1D integer(10) Book ISBN varchar(255) Count integer(10) Shopping Basket ID integer(10) Customer Email varchar(255) zzz Warehouse Book WarehouseCode inte ger(10) Book ISBN varchar(255) integer(10) Warehouse Code integer (10) Phone varchar(255) N Address varchar(255) N Count N Sumber: www.visual-paradigm.com%2Fguide%2Fdata-modeling%2Fwhat-is-entity-relationship-diagram