I want to know the information of all the publications.
select * from publication
Just tell me publishers from the tables above.
select publisher from publication
Thanks. Could you tell me who is the richest?
select publisher from publication order by price desc limit 1