hi guys,
first of all i would like to thank SKHANAL and all other members of this forum for helping me.

here is the question in my assignment:
List the most expensive book purchased by customer 1017?
i have these tables: books, customers, orders, orderitems.
my answer was:
SELECT MAX(retail) " Most Expensive Book"
FROM orders NATURAL JOIN orderitems NATURAL JOIN books
where customer#=1017
;
I get the right answer but i can't get both the book title and its price at the same time on the output. i only get this :

Most Expensive Book
--------------------
89.95

So, is there any other way to write the SQL code and get something like this:
Title
------------------------
Handcranked Computeres

Most Expensive Book
-------------------
89.95