Write a query that displays the title, ISBN, retail price, and cost of books whose cost is less than the average cost of all books. Format the cost with dollars and cents.

Write a query that displays the ISBN, order date, and customer# of the oldest order in the orders table. Format the date with the complete name of the month and a comma after the day of the month, like "January 3, 2011.

Write a query that shows the title and cost of books that are less than the average cost of books in the database.

Write a query that displays the names of the customers who purchased the oldest book in the database. Capitalize the first and last names.

Write a query that displays the first name and last name of each author along with the number of books he or she has written. Capitalize the first and last names.

what would these statements look like? could anyone do them by just using the aliases in the sentences, i want to see what the code would look like to run the subqueries. if the database structure is needed please let me know how to get to it. SQL oracle developer