andrey_vetrov

project_6

Apr 8th, 2022
26
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. SELECT c.country_code,
  2. SUM(fr.raised_amount)
  3. FROM company as c
  4. LEFT OUTER JOIN funding_round AS fr ON c.id = fr.company_id
  5. GROUP BY c.country_code
  6. ORDER BY SUM(fr.raised_amount) ASC;
  7.  
  8.  
Advertisement
Add Comment
Please, Sign In to add comment