select *,row_number() over (order by dayname) as row_numberx from weekday order by day

PRAGMA compile_options;