Untitled

From Bitty Mockingjay, 10 Months ago, written in Plain Text, viewed 163 times.
URL http://codebin.org/view/1897475f Embed
Download Paste or View Raw
  1. SELECT c.name,
  2.        EXTRACT(MONTH FROM fr.funded_at)
  3. FROM company AS c
  4. LEFT OUTER JOIN funding_round AS fr ON c.id = fr.id
  5. WHERE category_code = 'social' AND EXTRACT(YEAR FROM funded_at) BETWEEN 2010 AND 2013 AND funding_total != 0

Reply to "Untitled"

Here you can reply to the paste above