You don't need to...

;WITH CTE AS 
(
    SELECT oven, 
           T.Hours,
      ...

Got no idea if this will work as you haven't posted any consumable data:

;WITH CTE AS 
(
    SELECT System, 
    ...

Python needs indentation to work.

Thanks for the reply.  This query took over 3 minutes to run and it still didn't produce a result so I cancelled it.  The run time on this one...

This is an equivalent query

SELECT T4.UNDERLYING_SYMBOL,
       T4.QUOTE_DATE,
       T4.EXPIRATION,
       T4.ROOT_SYMBOL
...

• This reply was modified 1 year, 5 months ago by  Jonathan AC Roberts. Reason: wrong alias

Your SQL looks a bit odd. There is no point in ordering by something you are partitioning by. You have Car, Direction in the partition and also in the order...

SELECT y.ArriveDate, y.Car, x.arrival, x.direction, x.totalIn, x.totalOut, x.StationId, x.StationName
  FROM [Ridership].[dbo].[Rail2019] x
 INNER JOIN (SELECT DISTINCT ArriveDate, Car
        ...

SELECT rp.* 
FROM returned_products rp
WHERE rp.returned_products_reason NOT LIKE '%reason_[2-3]%'
;

Johnathan that was not my...

As C compiles into an Assembly...

If you ever had to deal with Assembler then COBOL would look like the futuristic flying car.  When I was in college they taught us both Assembler and COBOL. ...

Maybe this?

DROP TABLE IF EXISTS #Data;

CREATE TABLE #Data
(
    CLNUM INT
   ,Model INT
   ,CLSTATUS CHAR(1)
   ,CLSTATDATE DATE
 ...

COBOL 1959, Oracle 1979, SQL Server 1989

For computing 1959 is very early, in 1960 there were fewer than 2,000...