0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

CREATE TABLE #customers(
customer_id INT,
name VARCHAR(100));

CREATE TABLE #orders(
order_id INT,
quantity INT,
order_date DATETIME, customer_id INT);

INSERT INTO #customers(customer_id, name) VALUES (1, 'COMPANY_A')

INSERT INTO #customers(customer_id, name) VALUES (2, 'COMPANY_B')

INSERT INTO #orders(order_id, quantity, order_date, customer_id) VALUES (1, 5, '2019-01-01', 1)

INSERT INTO #orders(order_id, quantity, order_date, customer_id) VALUES (2, 2, '2019-01-05', 1)


INSERT INTO #orders(order_id, quantity, order_date, customer_id) VALUES (3, 4, '2019-01-05', 2)

INSERT INTO #orders(order_id, quantity, order_date, customer_id) VALUES (4, 9, '2019-01-10', 2)


SELECT c.name, o.order_date, sum(o.quantity)
    OVER(PARTITION BY c.name) FROM #customers c
    INNER JOIN #orders o
    ON c.customer_id = o.customer_id
    GROUP BY c.name, o.order_date, o.quantity

fork query

edited feb 28 19

created feb 28 19 anonymous