Group by clause

• First item in the same line with GROUP BY keyword

  SELECT SalesOrderID, SUM(LineTotal) AS SubTotal
  FROM Sales.SalesOrderDetail AS sod
  GROUP BY SalesOrderID

• First item in new line, indented by 1 or n

  SELECT SalesOrderID, SUM(LineTotal) AS SubTotal
  FROM Sales.SalesOrderDetail AS sod
  GROUP BY 
    SalesOrderID