I have a database built in Oracle and need some help with 2 queries on my homework assignments that I can not figure out. There are more tables in the database but these questions only involve these two: INVENTORY PK,FK book_code PK,FK branch_num on_hand BOOK PK book_code title FK publisher_code type price paperback The 2 questions I can not figure out are as follows: 1.Find the book code and book title for each book whose price is greater than the price of at least one book that has the type HOR. This one I am not too sure what to do. I started by creating a mirror table thing (not sure what it is called) and beyond that I am lost. SELECT b.book_code, b.title FROM book b, book bb WHERE b.book_code = bb.book_code AND b.title = bb.title AND b.publisher_code = bb.publisher_code AND b.type = bb.type AND b.price = bb.price AND b.paperback = bb.paperback AND b.price > bb.price (where b.type = (‘hor’)) 2. List the book code, book title and units on hand for each book in branch number 3. Be sure each book is included, regardless of whether there are any copies of the book currently on hand in branch 3. Order the output by book code. For this one I don't know what I am doing wrong. I think my join statement is right, but I should be getting tons of evtra rows in the output with null in the on_hand colum, but I get none. SELECT b.book_code, b.title, i.on_hand FROM book b FULL OUTER JOIN inventory i ON b.book_code = i.book_code WHERE i.branch_num = 3 ORDER BY b.book_code Any help would be much appreciated.