解决方案

你创建的视图一定有问题。
这应该足以产生适当的结果：

SELECT
     side_id
    ,side_name
    ,COUNT(*) AS total_count
FROM dbo.orders
GROUP BY side_id, side_name

boostrapping（sql server）

引导示例的脚本：

IF NOT EXISTS (SELECT 1 FROM sys.tables t WHERE t.object_id = OBJECT_ID('dbo.orders'))
BEGIN
    CREATE TABLE orders
    (
        order_id INT,
        side_id INT NOT NULL,
        side_name NVARCHAR(100) NOT NULL,
        ordered_quantity INT NOT NULL,
        total_cost MONEY NOT NULL
    );
END;

INSERT INTO orders (order_id, side_id, side_name, ordered_quantity, total_cost)
VALUES 
(10, 1, '390ml Coke', 1, 3.00),
(5, 2, '1.25l Coke', 2, 10.00),
(8, 3, 'Lava Cake', 3, 8.85),
(7, 4, 'Chicken Wings', 4, 14.00),
(6, 5, 'Garlic Bread', 4, 7.80),
(5, 6, 'Healthy Kale Chips', 3, 16.50),
(5, 6, 'Healthy Kale Chips', 2, 11.00),
(4, 5, 'Garlic Bread', 1, 1.95),
(3, 4, 'Chicken Wings', 1, 3.50),
(2, 3, 'Lava Cake', 2, 5.90);