Group by clause

• First item in the same line with GROUP BY keyword

• All items in the same line

  SELECT Subject, Semester, Count(*)
  FROM [Subject_Selection]
  GROUP BY Subject,Semester

• Stacked items with comma at the end of line

  SELECT Subject, Semester, Count(*)
  FROM [Subject_Selection]
  GROUP BY Subject,
           Semester

• Stacked items with comma at the begin of line, first item align with comma

  SELECT Subject, Semester, Count(*)
  FROM [Subject_Selection]
  GROUP BY Subject
           ,Semester

• Stacked items with comma at the begin of line, first item align with following items

  SELECT Subject, Semester, Count(*)
  FROM [Subject_Selection]
  GROUP BY Subject
          ,Semester

• Stacked items with comma at the begin of line, first item align with following items, space between comma and items is 1 to n

  SELECT Subject, Semester, Count(*)
  FROM [Subject_Selection]
  GROUP BY Subject
         , Semester

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

• All items in the same line

  SELECT Subject, Semester, Count(*)
  FROM [Subject_Selection]
  GROUP BY 
    Subject,Semester

• Stacked items with comma at the end of line

  SELECT Subject, Semester, Count(*)
  FROM [Subject_Selection]
  GROUP BY 
    Subject,
    Semester

• Stacked items with comma at the begin of line, first item align with comma

  SELECT Subject, Semester, Count(*)
  FROM [Subject_Selection]
  GROUP BY 
    Subject
    ,Semester

• Stacked items with comma at the begin of line, first item align with following items

  SELECT Subject, Semester, Count(*)
  FROM [Subject_Selection]
  GROUP BY 
     Subject
    ,Semester

• Stacked items with comma at the begin of line, first item align with following items, space between comma and items is 1 to n

  SELECT Subject, Semester, Count(*)
  FROM [Subject_Selection]
  GROUP BY 
      Subject
    , Semester