Breaking News: Grepper is joining You.com. Read the official announcement!

postgres sql subquery variable nested query

DreamCoder answered on February 14, 2023 Popularity 6/10 Helpfulness 2/10

answer postgres sql subquery variable nested query

related postgres sql subquery variable nested query

postgres sql subquery variable nested query

Comment

WITH regional_sales AS (
    SELECT region, SUM(amount) AS total_sales
    FROM orders
    GROUP BY region
), top_regions AS (
    SELECT region
    FROM regional_sales
    WHERE total_sales > (SELECT SUM(total_sales)/10 FROM regional_sales)
)
SELECT region,
       product,
       SUM(quantity) AS product_units,
       SUM(amount) AS product_sales
FROM orders
WHERE region IN (SELECT region FROM top_regions)
GROUP BY region, product;

Popularity 6/10 Helpfulness 2/10 Language sql

Source: www.postgresql.org

Tags: nested-query sql subquery

Link to this answer
Share Copy Link

Contributed on Feb 14 2023

DreamCoder

0 Answers Avg Quality 2/10

Closely Related Answers

postgres sql subquery variable nested query

Comment

WITH RECURSIVE t(n) AS (
    VALUES (1)
  UNION ALL
    SELECT n+1 FROM t WHERE n < 100
)
SELECT sum(n) FROM t;

Popularity 5/10 Helpfulness 1/10 Language sql

Source: www.postgresql.org

Tags: nested-query subquery sql

Link to this answer
Share Copy Link

Contributed on Feb 14 2023

DreamCoder

0 Answers Avg Quality 2/10

postgres sql subquery variable nested query

Comment

WITH RECURSIVE included_parts(sub_part, part, quantity) AS (
    SELECT sub_part, part, quantity FROM parts WHERE part = 'our_product'
  UNION ALL
    SELECT p.sub_part, p.part, p.quantity * pr.quantity
    FROM included_parts pr, parts p
    WHERE p.part = pr.sub_part
)
SELECT sub_part, SUM(quantity) as total_quantity
FROM included_parts
GROUP BY sub_part

Popularity 4/10 Helpfulness 1/10 Language sql

Source: www.postgresql.org

Tags: sql nested-query subquery

Link to this answer
Share Copy Link

Contributed on Feb 14 2023

DreamCoder

0 Answers Avg Quality 2/10

postgres sql subquery variable nested query

Contents

More Related Answers

postgres sql subquery variable nested query

Closely Related Answers

postgres sql subquery variable nested query

postgres sql subquery variable nested query

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.