SELECT DISTINCT uid, MIN(user_level) over(partition by uid) as user_level FROM( SELECT t1.uid, t1.ovd_days, t2.ovd_days as ovd_days_config, t2.user_level FROM ( SELECT * FROM dwd_trd_loan_tb_dd WHERE dt='20241011' )t1, dim_ovd_config_dd t2 )t3 WHERE ovd_days<=ovd_days_config;