Select Code to Download

select id, url, images, Total
from (
...
    limit 10
) last10
order by Total desc;

  select Customers.name, sales.amount                     -- select na
+me and total amount spent. 
  from Customers, 
...
  ) sales                                                 -- we name t
+his sub-select "sales".
  where sales.customer_id = Customers.id                  -- we INNER 
+JOIN the two "tables", 
                                                          -- so we can
+ cross-reference Orders against Customers.