Ok, I am completely stumped on how to get this to display the profit as a currency. I can get my query output to look like this:

Here's my current code:

select order#,
books.retail - books.cost AS profit
from orders, books 
where order# = 1002;
Nvm, I figured it out, and for everyone who's stumped on how to do this, use this:
to_char(number/columnname/formula(i.e. column1-column2, etc.), $9,999.00) AS Columnname