Untitled

From Queen Water Vole, 10 Months ago, written in Plain Text, viewed 88 times.
URL http://codebin.org/view/0892767a 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 investment AS i
  5. LEFT JOIN company AS c ON c.id = i.company_id
  6. LEFT JOIN fund AS f ON f.id = i.fund_id
  7. LEFT JOIN funding_round AS fr ON i.funding_round_id = fr.id
  8. WHERE f.milestones > 6
  9.       AND EXTRACT(YEAR FROM fr.funded_at) BETWEEN 2012 AND 2013

Reply to "Untitled"

Here you can reply to the paste above