Untitled

From Obese Iguana, 10 Months ago, written in Plain Text, viewed 125 times.
URL http://codebin.org/view/7e2df6cc Embed
Download Paste or View Raw
  1. SELECT f.name AS name_of_fund,
  2.        c.name AS name_of_company,
  3.        fr.raised_amount AS amount
  4. FROM fund AS f
  5. LEFT JOIN investment AS i ON f.id = i.fund_id
  6. LEFT JOIN funding_round AS fr ON i.funding_round_id = fr.id
  7. LEFT JOIN company AS c ON fr.company_id = c.id
  8.  
  9. WHERE c.name IN
  10. (SELECT c.name AS name_of_company
  11. FROM company AS c
  12. LEFT JOIN funding_round AS fr ON c.id = fr.company_id
  13. WHERE c.milestones > 6
  14. AND EXTRACT(YEAR FROM CAST(fr.funded_at as date)) BETWEEN 2012 AND 2013);

Reply to "Untitled"

Here you can reply to the paste above