create table t_ykc ( 
c_l2i8lidec INTEGER ,
c_txh TEXT ,
c_xlfd1o TEXT ,
c_qs5uppjb TEXT NOT NULL,
c_v7 TEXT ,
c_z5hhod3 TEXT NOT NULL,
c_yjt7yefm INTEGER NOT NULL,
c_royiwby INTEGER ,
c_ar7my8 TEXT NOT NULL,
primary key(c_yjt7yefm),
unique(c_yjt7yefm),
check(((t_ykc.c_yjt7yefm / t_ykc.c_yjt7yefm) = t_ykc.c_l2i8lidec) 
  or (t_ykc.c_l2i8lidec = t_ykc.c_l2i8lidec))
);

alter table t_ykc rename column c_royiwby to c_i8a;

insert into t_ykc values 
(87, 'sn80qzp', cast(coalesce(cast(null as CHAR),
  'ajz') as CHAR), 'fy', 'rcmb', 'wlj6ni', cast(coalesce(84,
  19) as SIGNED), ( 42 * 80), 'qu'
  );

select
  LAG(cast(ref_0.c_xlfd1o as CHAR)) over (partition by ref_0.c_z5hhod3 order by ref_0.c_yjt7yefm) in (
        select  
            ref_1.c_qs5uppjb as c0
          from 
            t_ykc as ref_1) as c1 
from 
  t_ykc as ref_0
;
