SELECT Year, Quarter, OrdersNum Q_Orders, 
            SUM(OrdersNum) OVER (PARTITION BY Year 
                                                    ORDER BY Quarter) AS Running_Q_Orders
FROM (
            SELECT calendaryear AS Year, calendarquarter AS Quarter, 
                        COUNT(DISTINCT orderkey) AS OrdersNum
            FROM factonlinesales fos INNER JOIN dimdate dd
                ON fos.orderdatekey = dd.datekey 
            INNER JOIN dimproduct dp ON dp.productkey = fos.productkey
            WHERE categoryname = 'Bikes' AND calendaryear IN (2023, 2024)
            GROUP BY calendaryear, calendarquarter
            )
ORDER BY 1, 2 ;