-- Database schema
| authors : au_id [ TEXT ] primary_key , au_lname [ TEXT ] , au_fname [ TEXT ] , phone [ TEXT ] , address [ TEXT ] , city [ TEXT ] , state [ TEXT ] , zip [ TEXT ] , contract [ TEXT ] | jobs : job_id [ INTEGER ] primary_key , job_desc [ TEXT ] , min_lvl [ INTEGER ] , max_lvl [ INTEGER ] | publishers : pub_id [ TEXT ] primary_key , pub_name [ TEXT ] , city [ TEXT ] , state [ TEXT ] , country [ TEXT ] | employee : emp_id [ TEXT ] primary_key , fname [ TEXT ] , minit [ TEXT ] , lname [ TEXT ] , job_id [ INTEGER ] employee.job_id = jobs.job_id , job_lvl [ INTEGER ] , pub_id [ TEXT ] employee.pub_id = publishers.pub_id , hire_date [ DATETIME ] | pub_info : pub_id [ TEXT ] primary_key pub_info.pub_id = publishers.pub_id , logo [ BLOB ] , pr_info [ TEXT ] | stores : stor_id [ TEXT ] primary_key , stor_name [ TEXT ] , stor_address [ TEXT ] , city [ TEXT ] , state [ TEXT ] , zip [ TEXT ] | discounts : discounttype [ TEXT ] , stor_id [ TEXT ] discounts.stor_id = stores.stor_id , lowqty [ INTEGER ] , highqty [ INTEGER ] , discount [ REAL ] | titles : title_id [ TEXT ] primary_key , title [ TEXT ] , type [ TEXT ] , pub_id [ TEXT ] titles.pub_id = publishers.pub_id , price [ REAL ] , advance [ REAL ] , royalty [ INTEGER ] , ytd_sales [ INTEGER ] , notes [ TEXT ] , pubdate [ DATETIME ] | roysched : title_id [ TEXT ] roysched.title_id = titles.title_id , lorange [ INTEGER ] , hirange [ INTEGER ] , royalty [ INTEGER ] | sales : stor_id [ TEXT ] sales.stor_id = stores.stor_id , ord_num [ TEXT ] , ord_date [ DATETIME ] , qty [ INTEGER ] , payterms [ TEXT ] , title_id [ TEXT ] sales.title_id = titles.title_id | titleauthor : au_id [ TEXT ] titleauthor.au_id = authors.au_id , title_id [ TEXT ] titleauthor.title_id = titles.title_id , au_ord [ INTEGER ] , royaltyper [ INTEGER ] |
-- -- In the books published by US publishers, which book has the highest royalty? List these books in the descending order of royalty.

SELECT T1.title FROM titles AS T1 INNER JOIN publishers AS T2 ON T1.pub_id = T2.pub_id INNER JOIN roysched AS T3 ON T1.title_id = T3.title_id WHERE T2.country = 'USA' ORDER BY T1.royalty DESC;