ITSE 2309 Database Programming: Oracle Lab 6 Joining Data from Multiple Tables

I did everything I could to get the following question done right for Oracle 11g and the only result I got was "no rows selected."

ge iew Fuil Document Determine which books customer Jake Lucas has purchased. Perform the search using the customer name, not the customer number. If he has purchased multiple copies of the same book, unduplicate the results. SELECT Distinct Title From CUSTOMERS natural join ORDERS natural join ORDERITEMS natural join 'Jake' AND LastName = 'Lucas'; BOOKS Where FirstName l Title PAINLESS CHILD-REARING I HOW TO MANAGE THE MANAGER