I need a list of the titles of books.
select title from book
Can you give me the price of those books?
select t2.price from book as t1 join publication as t2 on t1.book_id = t2.book_id
can you list those in ascending order?
select t2.price from book as t1 join publication as t2 on t1.book_id = t2.book_id order by t2.price asc
Can you list the prices along with the books?
select t2.price, t1.title from book as t1 join publication as t2 on t1.book_id = t2.book_id order by t2.price asc
Now can you list the titles of the books and the prices but in descending order?
select t2.price, t1.title from book as t1 join publication as t2 on t1.book_id = t2.book_id order by t2.price desc