SQL Server 2022

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

-- Create Table DDL
CREATE TABLE ExpenseTable (
    Expense_Type VARCHAR(255),
    Amount DECIMAL(18, 2),
    Date_Of_Payment DATE
);

-- Insert Statements
INSERT INTO ExpenseTable (Expense_Type, Amount, Date_Of_Payment)
VALUES
    ('Consultancy Expenditure', 5000.00, '2022-05-15'),
    ('Criminal Law', -2500.50, '2022-08-22'),
    ('External Training', 7500.75, '2022-11-10'),
    ('Consultancy Expenditure', 12000.00, '2023-01-05'),
    ('External Training', -5000.25, '2023-04-18'),
    ('Criminal Law', 80000.00, '2023-07-02'),
    ('Consultancy Expenditure', -3000.50, '2023-09-14'),
    ('External Training', 6000.25, '2023-12-28'),
    ('Criminal Law', 3500.00, '2023-02-08'),
    ('Criminal Law', -10000.00, '2022-06-30'),
    ('Consultancy Expenditure', 9500.00, '2022-04-20'),
    ('External Training', -7500.75, '2022-10-05'),
    ('Criminal Law', 3000.50, '2022-12-15'),
    ('Consultancy Expenditure', -18000.00, '2023-01-25'),
    ('External Training', 2000.25, '2023-03-12'),
    ('Criminal Law', -60000.00, '2023-05-28'),
    ('Consultancy Expenditure', 4500.50, '2023-08-07'),
    ('External Training', 3000.75, '2023-10-19'),
    ('Criminal Law', 12000.00, '2023-01-02'),
    ('Criminal Law', -5000.00, '2022-07-15'),
    ('Consultancy Expenditure', 6000.00, '2022-09-28'),
    ('External Training', -3000.25, '2023-11-10'),
    ('Criminal Law', 9000.50, '2023-04-01'),
    ('Consultancy Expenditure', -12000.00, '2023-06-14'),
    ('External Training', 1500.25, '2023-09-26'),
    ('Criminal Law', 5500.00, '2023-12-09'),
    ('Consultancy Expenditure', 8000.50, '2023-02-22'),
    ('External Training', -4500.75, '2022-05-03'),
    ('Criminal Law', 18000.00, '2022-08-17'),
    ('Consultancy Expenditure', -3000.00, '2022-11-30'),
    ('External Training', 2500.75, '2023-02-14'),
    ('Criminal Law', -7500.50, '2023-05-01'),
    ('Consultancy Expenditure', 7000.25, '2023-08-14'),
    ('External Training', -2000.25, '2023-10-27'),
    ('Criminal Law', 4000.00, '2023-01-09'),
    ('Consultancy Expenditure', -6000.50, '2022-07-22'),
    ('External Training', 3500.75, '2022-09-04'),
    ('Criminal Law', 15000.00, '2023-11-17'),
    ('Consultancy Expenditure', 2000.50, '2023-04-05'),
    ('External Training', -1200.25, '2023-07-18'),
    ('Criminal Law', -3000.00, '2023-09-30'),
    ('Consultancy Expenditure', 10000.25, '2023-12-13'),
    ('External Training', 5000.00, '2023-02-28'),
    ('Criminal Law', -4500.50, '2022-06-13'),
    ('Consultancy Expenditure', 3000.75, '2022-10-26'),
    ('External Training', -2500.75, '2022-12-08'),
    ('Criminal Law', 6000.00, '2023-03-23'),
    ('Consultancy Expenditure', -1500.00, '2023-06-06'),
    ('External Training', 1200.25, '2023-09-19'),
    ('Criminal Law', 2500.50, '2023-12-02');

50 rows affected

FromDate	ThruDate	Expense_Type	SumAmount	AvgSumAmount
2022-04-01 00:00:00.000	2022-09-30 00:00:00.000	Consultancy Expenditure	14499.50	3166.166666
2022-10-01 00:00:00.000	2023-03-31 00:00:00.000	Criminal Law	28500.50	12500.666666
2023-04-01 00:00:00.000	2023-09-30 00:00:00.000	Criminal Law	18500.00	4000.250000
2023-10-01 00:00:00.000	2024-03-31 00:00:00.000	Criminal Law	23000.50	12333.750000