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 3 years, 3 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...

Having supported a COBOL application for over 10 years, COBOL is a good language. Yes, it is wordy compared to modern programming languages, but that doesn't mean...

Having supported a COBOL application for over 10 years, COBOL is a good language. Yes, it is wordy compared to modern programming languages, but that doesn't mean it isn't...

Okay you and I will have to agree to disagree on this one. Not that...