Database

DECLARE @months TABLE
(
   MonthNum int NOT NULL
)
 
INSERT INTO @months
SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT 3 UNION ALL
SELECT 4 UNION ALL
SELECT 5 UNION ALL
SELECT 6 UNION ALL
SELECT 7 UNION ALL
SELECT 8 UNION ALL
SELECT 9 UNION ALL
SELECT 10 UNION ALL
SELECT 11 UNION ALL
SELECT 12

DECLARE @classes TABLE
(
   ClassName varchar(5) NOT NULL
)
 
INSERT INTO @classes
SELECT 'First' UNION ALL
SELECT 'Third'

 Class | Month | Reservations
-----------------------------
 First |  Jan  |   130
 First |  Feb  |   500
 First |  Mar  |   320
 First |  Apr  |   112
  ...
 First |  Dec  | count
 Third |  Jan  | count
 Third |  Feb  | count
  ...
 Third |  Dec  | count

SELECT
  ClassName AS Class,
  DATENAME(month, DATEADD(m, MonthNum - 1, '20040101')) AS Month,
  COUNT(TKTNO) AS [Count]
FROM
  Tickets_Purchased TP
RIGHT JOIN
  (
     SELECT ClassName, MonthNum
     FROM @classes CROSS JOIN @months
  ) Crit
   ON TP.CLASS = Crit.ClassName AND MONTH(TP.DATEPURCHASE) = Crit.MonthNum
GROUP BY
  ClassName, MonthNum
ORDER BY
  ClassName, MonthNum

SELECT CLASS, DATENAME([month], RSRVDATE) AS Month, COUNT(*) AS Total<br />
FROM RESERVED_LEGS <br />
INNER JOIN Tickets_Purchased ON RESERVED_LEGS.PNR = Tickets_Purchased.TKTNO<br />
GROUP BY CLASS, MONTH(RSRVDATE)<br />
ORDER BY CLASS, MONTH(RSRVDATE)

SELECT CLASS, <br />
(SELECT COUNT(*) FROM RESERVED_LEGS INNER JOIN Tickets_Purchased AS TP ON RESERVED_LEGS.PNR = TP.TKTNO WHERE MONTH(RSRVDATE) = 1) AND TP.CLASS = TicketsPurchased.CLASS) AS Jan, <br />
(SELECT COUNT(*) FROM RESERVED_LEGS INNER JOIN Tickets_Purchased AS TP ON RESERVED_LEGS.PNR = TP.TKTNO WHERE MONTH(RSRVDATE) = 2) AND TP.CLASS = TicketsPurchased.CLASS) AS Feb,<br />
(SELECT COUNT(*) FROM RESERVED_LEGS INNER JOIN Tickets_Purchased AS TP ON RESERVED_LEGS.PNR = TP.TKTNO WHERE MONTH(RSRVDATE) = 3) AND TP.CLASS = TicketsPurchased.CLASS) AS Mar,<br />
...<br />
...<br />
...<br />
FROM Tickets_Purchased<br />
GROUP BY CLASS<br />
ORDER BY CLASS