SQL Server 2019 (Linux)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Orders (
    OrderID INT,
    CustomerID INT,
    OrderDate DATE,
    TotalAmount DECIMAL(10, 2),
    PRIMARY KEY (CustomerID, OrderID)
);

INSERT INTO Orders (OrderID, CustomerID, OrderDate, TotalAmount)
VALUES
    (1, 101, '2023-08-01', 150.00),
    (2, 102, '2023-08-02', 75.50),
    (3, 101, '2023-08-03', 200.00),
    (4, 103, '2023-08-04', 50.00),
    (5, 102, '2023-08-05', 120.00),
    (6, 104, '2023-08-06', 300.00),
    (7, 101, '2023-08-07', 75.00),
    (8, 103, '2023-08-08', 250.00),
    (9, 102, '2023-08-09', 180.00),
    (10, 105, '2023-08-10', 90.00);
10 rows affected

SELECT * FROM Orders;


OrderID
CustomerID
OrderDate
TotalAmount


1
101
2023-08-01
150.00

3
101
2023-08-03
200.00

7
101
2023-08-07
75.00

2
102
2023-08-02
75.50

5
102
2023-08-05
120.00

9
102
2023-08-09
180.00

4
103
2023-08-04
50.00

8
103
2023-08-08
250.00

6
104
2023-08-06
300.00

10
105
2023-08-10
90.00


SELECT CustomerID
	,OrderID
	,TotalAmount
FROM Orders
WHERE TotalAmount > 100;


CustomerID
OrderID
TotalAmount


101
1
150.00

101
3
200.00

102
5
120.00

102
9
180.00

103
8
250.00

104
6
300.00


SELECT CustomerID
	,OrderID
	,SUM(TotalAmount) AS TotalAmount
FROM Orders
GROUP BY CustomerID
	,OrderID
HAVING SUM(TotalAmount) > 100;


CustomerID
OrderID
TotalAmount


101
1
150.00

101
3
200.00

102
5
120.00

102
9
180.00

103
8
250.00

104
6
300.00

OrderID	CustomerID	OrderDate	TotalAmount
1	101	2023-08-01	150.00
3	101	2023-08-03	200.00
7	101	2023-08-07	75.00
2	102	2023-08-02	75.50
5	102	2023-08-05	120.00
9	102	2023-08-09	180.00
4	103	2023-08-04	50.00
8	103	2023-08-08	250.00
6	104	2023-08-06	300.00
10	105	2023-08-10	90.00