create table t_ykc ( 
c_l2i8lidec INTEGER ,
c_axl TEXT ,
c_xlfd1o TEXT ,
c_qs5uppjb TEXT NOT NULL,
c_v7 TEXT ,
c_z5h8od3 TEXT NOT NULL,
c_yjt7yefm INTEGER NOT NULL,
c_romiwby INTEGER ,
c_amkfi3 TEXT ,
primary key(c_yjt7yefm),
unique(c_yjt7yefm),
check(t_ykc.c_l2i8lidec <> (t_ykc.c_l2i8lidec * t_ykc.c_yjt7yefm))
);

create index t_cauc on t_ykc (c_l2i8lidec, c_yjt7yefm, c_romiwby);

create table t_wy_ as 
select  
    1 as c0 
  from 
    (select  
          ref_0.c_axl as c6 
        from 
          t_ykc as ref_0
        group by ref_0.c_axl limit 127
    ) as subq_0
;

insert into t_ykc values 
(4, 'q', 'refs_1pf', 'dr', 'e', substr(
    cast('y2pgzhpob' as CHAR),
    cast(cast(nullif(14,
      33) as SIGNED) as SIGNED),
    cast(63 as SIGNED))
  , 40, 62, 's5fh6'), 
(89, 'nxfc', 'qrfgxbg', 'c4868', 'vi5jvca', 'c6wgr0h6', 84, 66, cast(null as CHAR));

create table t_qhbsejtlf ( 
c_ar0 INTEGER NOT NULL,
c_xf5kly2 TEXT ,
c_v63r INTEGER ,
c_m4gzepbt TEXT ,
primary key(c_v63r)
);

select  
  1 as c0  
  from 
    t_ykc as ref_5
  where ref_5.c_yjt7yefm < ( 
    select  
          ref_5.c_romiwby as c0
        from 
          t_qhbsejtlf as ref_6
        where ref_5.c_romiwby <= ref_5.c_yjt7yefm
      union all
      select  
          ref_7.c_yjt7yefm as c0
        from 
          (t_ykc as ref_7
            cross join t_wy_ as ref_8
            )
        window j8kz as ( partition by ref_5.c_l2i8lidec order by ref_7.c_qs5uppjb asc)
) limit 107
;

