It is a SQL practice repository covering basics to advanced topics. It includes exercises on SELECT statements, WHERE clauses, GROUP BY, JOINS, window functions (OVER(), PARTITION BY), ROW_NUMBER(), ...
,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Total' ,AVG(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Avg' ,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) AS ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback