21 задача проект

From Николай, 4 Months ago, written in Plain Text, viewed 53 times.

URL http://codebin.org/view/39dd2762 Embed

Download Paste or View Raw

SELECT c.name,
       tab1.month
FROM company AS c
RIGHT JOIN (
             SELECT company_id,
             EXTRACT(MONTH FROM funded_at) AS month
             FROM funding_round
             WHERE EXTRACT(YEAR FROM funded_at) BETWEEN 2010 AND 2013
            ) AS tab1 ON c.id = tab1.company_id
WHERE c.category_code LIKE 'social';

Reply to "21 задача проект"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?