diana-shealy

WITH t1 as (
  SELECT  
    rowid() as rowid,
    t.stateholiday, t.store, t.promo, t.dayofweek, t.date, t.schoolholiday, t.sales, 
    SUBSTR(t.date,1,4) as year,
    SUBSTR(t.date,6,2) as month,
    SUBSTR(t.date,9,2) as day
  FROM
    train_original t 
  WHERE sales != 0

diana-shealy

WITH t1 as (
  SELECT  
    rowid() as rowid,
    t.stateholiday, t.store, t.promo, t.dayofweek, t.date, t.schoolholiday, t.sales, 
    SUBSTR(t.date,1,4) as year,
    SUBSTR(t.date,6,2) as month,
    SUBSTR(t.date,9,2) as day
  FROM
    train_original t 
  WHERE sales != 0