【变态难】找出每部电影和单部电影销售冠军之间的销售差，列出电影名，销售额差额

 

 

select title,
(select max(Domestic_sales+International_sales) 
from movies m join boxoffice b 
on m.id = b.movie_id )-(Domestic_sales+International_sales) as diff_sales

from movies  m join boxoffice b 
on m.id = b.movie_id
order by diff_sales desc