Untitled

From Bulky Cockroach, 10 Months ago, written in Plain Text, viewed 94 times.
URL http://codebin.org/view/b4901905 Embed
Download Paste or View Raw
  1. WITH
  2. fr AS (SELECT company_id,
  3.               SUM(raised_amount) AS amount
  4.        FROM funding_round
  5.        GROUP BY company_id
  6.        HAVING SUM(raised_amount) != 0),
  7. a AS (SELECT *
  8.       FROM acquisition
  9.       WHERE price_amount != 0)
  10. SELECT c_1.name AS acquiring_company,
  11.        a.price_amount AS price,
  12.        c_2.name AS acquired_company,
  13.        fr.amount AS amount,
  14.        round(a.price_amount / a.acquired_company_id) AS part
  15. FROM a LEFT OUTER JOIN company AS c_1 ON a.acquiring_company_id = c_1.id
  16. LEFT OUTER JOIN company AS c_2 ON a.acquired_company_id = c_2.id
  17. INNER JOIN fr ON c_2.id = fr.company_id
  18. ORDER BY a.price_amount DESC, c_2.name ASC
  19. LIMIT 10;

Reply to "Untitled"

Here you can reply to the paste above