3. Create the following tables to write the SQL queries below. The tables only show a subset of the data hence, your SQL queries answers should assume the tables contain more data rows. When necessary, use RoomID as the join attribute LOCATION and BOOK ISBN:number(3), Title:char(40), Author:char(30), RoomID:numbcr(3) > LOCATION BOOK ISBNTitle RoomIDHeight Subject Cookin Health Music uthor RoomID Zandate I Sun Cook AII TDa Rock of 40 NULLClose the Fridge!LincolnI 10 78 Ace Computin Ross a. Show the SQL inner join query that retrieves only the Title values that meet the following criteria: Title name(s) having b. Show the SQL outer join that displays all Author name(s) and Title name(s) (plus if there is a corresponding Subject c. Show the SQL outer join which retrieves all Author name(s) which do not have a corresponding Subject name value d. Show the command that creates a view named myview which consists of the Height and Author attributes having the letter 'e', Subject name(s) having 6 letters, and RoomID values greater than 4 name) such that the Title name(s) are shown in decreasing alphabetical order For example, given the data extract above, the author "Ross" does not have a corresponding Subject. ISBN numbers not equal to NULL. Perform the "select * from myview. SQL command to confirm correctness