Symfony Profiler

SELECT
  (
    SELECT
      COUNT(*)
    FROM
      dbo.Messages
    WHERE
      [TimeStamp] >= DATEADD(
        MONTH,
        -12,
        CAST(
          GETDATE() AS DATE
        )
      )
      AND Role NOT IN ('system')
      AND [TimeStamp] IS NOT NULL
  ) AS total_messages,
  (
    SELECT
      COUNT(*)
    FROM
      dbo.Sessions
    WHERE
      CreatedAt >= DATEADD(
        MONTH,
        -12,
        CAST(
          GETDATE() AS DATE
        )
      )
  ) AS total_sessions,
  (
    SELECT
      ISNULL(
        SUM(Tokens),
        0
      )
    FROM
      dbo.Messages
    WHERE
      [TimeStamp] >= DATEADD(
        MONTH,
        -12,
        CAST(
          GETDATE() AS DATE
        )
      )
      AND Role NOT IN ('system')
      AND [TimeStamp] IS NOT NULL
  ) AS total_tokens,
  (
    SELECT
      ISNULL(
        AVG(
          CAST(msg_count AS FLOAT)
        ),
        0
      )
    FROM
      (
        SELECT
          SessionId,
          COUNT(*) AS msg_count
        FROM
          dbo.Messages
        WHERE
          [TimeStamp] >= DATEADD(
            MONTH,
            -12,
            CAST(
              GETDATE() AS DATE
            )
          )
          AND Role NOT IN ('system')
          AND SessionId IS NOT NULL
        GROUP BY
          SessionId
      ) t
  ) AS avg_msgs_per_session,
  (
    SELECT
      ISNULL(
        AVG(
          CAST(tok_sum AS FLOAT)
        ),
        0
      )
    FROM
      (
        SELECT
          SessionId,
          SUM(Tokens) AS tok_sum
        FROM
          dbo.Messages
        WHERE
          [TimeStamp] >= DATEADD(
            MONTH,
            -12,
            CAST(
              GETDATE() AS DATE
            )
          )
          AND Role NOT IN ('system')
          AND SessionId IS NOT NULL
        GROUP BY
          SessionId
      ) t
  ) AS avg_tokens_per_session

SELECT
                (SELECT COUNT(*)
                 FROM dbo.Messages
                 WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                   AND Role NOT IN ('system')
                   AND [TimeStamp] IS NOT NULL
                ) AS total_messages,

                (SELECT COUNT(*)
                 FROM dbo.Sessions
                 WHERE CreatedAt >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                ) AS total_sessions,

                (SELECT ISNULL(SUM(Tokens), 0)
                 FROM dbo.Messages
                 WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                   AND Role NOT IN ('system')
                   AND [TimeStamp] IS NOT NULL
                ) AS total_tokens,

                (SELECT ISNULL(AVG(CAST(msg_count AS FLOAT)), 0)
                 FROM (
                     SELECT SessionId, COUNT(*) AS msg_count
                     FROM dbo.Messages
                     WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                       AND Role NOT IN ('system')
                       AND SessionId IS NOT NULL
                     GROUP BY SessionId
                 ) t
                ) AS avg_msgs_per_session,

                (SELECT ISNULL(AVG(CAST(tok_sum AS FLOAT)), 0)
                 FROM (
                     SELECT SessionId, SUM(Tokens) AS tok_sum
                     FROM dbo.Messages
                     WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
                       AND Role NOT IN ('system')
                       AND SessionId IS NOT NULL
                     GROUP BY SessionId
                 ) t
                ) AS avg_tokens_per_session
        ;

SELECT
  DATEFROMPARTS(
    YEAR([TimeStamp]),
    MONTH([TimeStamp]),
    1
  ) AS period,
  COUNT(*) AS period_value
FROM
  dbo.Messages
WHERE
  [TimeStamp] >= DATEADD(
    MONTH,
    -12,
    CAST(
      GETDATE() AS DATE
    )
  )
  AND Role NOT IN ('system')
  AND [TimeStamp] IS NOT NULL
GROUP BY
  DATEFROMPARTS(
    YEAR([TimeStamp]),
    MONTH([TimeStamp]),
    1
  )
ORDER BY
  period ASC

SELECT DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1) AS period, COUNT(*) AS period_value
            FROM dbo.Messages
            WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND Role NOT IN ('system') AND [TimeStamp] IS NOT NULL
            GROUP BY DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1)
            ORDER BY period ASC
        ;

SELECT
  DATEFROMPARTS(
    YEAR(CreatedAt),
    MONTH(CreatedAt),
    1
  ) AS period,
  COUNT(*) AS period_value
FROM
  dbo.Sessions
WHERE
  CreatedAt >= DATEADD(
    MONTH,
    -12,
    CAST(
      GETDATE() AS DATE
    )
  )
  AND 1 = 1
GROUP BY
  DATEFROMPARTS(
    YEAR(CreatedAt),
    MONTH(CreatedAt),
    1
  )
ORDER BY
  period ASC

SELECT DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1) AS period, COUNT(*) AS period_value
            FROM dbo.Sessions
            WHERE CreatedAt >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND 1=1
            GROUP BY DATEFROMPARTS(YEAR(CreatedAt), MONTH(CreatedAt), 1)
            ORDER BY period ASC
        ;

SELECT
  DATEFROMPARTS(
    YEAR([TimeStamp]),
    MONTH([TimeStamp]),
    1
  ) AS period,
  ISNULL(
    SUM(Tokens),
    0
  ) AS period_value
FROM
  dbo.Messages
WHERE
  [TimeStamp] >= DATEADD(
    MONTH,
    -12,
    CAST(
      GETDATE() AS DATE
    )
  )
  AND Role NOT IN ('system')
  AND [TimeStamp] IS NOT NULL
GROUP BY
  DATEFROMPARTS(
    YEAR([TimeStamp]),
    MONTH([TimeStamp]),
    1
  )
ORDER BY
  period ASC

SELECT DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1) AS period, ISNULL(SUM(Tokens), 0) AS period_value
            FROM dbo.Messages
            WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE)) AND Role NOT IN ('system') AND [TimeStamp] IS NOT NULL
            GROUP BY DATEFROMPARTS(YEAR([TimeStamp]), MONTH([TimeStamp]), 1)
            ORDER BY period ASC
        ;

SELECT
  DATEPART(HOUR, [TimeStamp]) AS hour_of_day,
  COUNT(*) AS msg_count
FROM
  dbo.Messages
WHERE
  [TimeStamp] >= DATEADD(
    MONTH,
    -12,
    CAST(
      GETDATE() AS DATE
    )
  )
  AND Role NOT IN ('system')
  AND [TimeStamp] IS NOT NULL
GROUP BY
  DATEPART(HOUR, [TimeStamp])
ORDER BY
  hour_of_day ASC

SELECT DATEPART(HOUR, [TimeStamp]) AS hour_of_day, COUNT(*) AS msg_count
            FROM dbo.Messages
            WHERE [TimeStamp] >= DATEADD(MONTH, -12, CAST(GETDATE() AS DATE))
              AND Role NOT IN ('system')
              AND [TimeStamp] IS NOT NULL
            GROUP BY DATEPART(HOUR, [TimeStamp])
            ORDER BY hour_of_day ASC
        ;