select * from VW_HS_YXGH00 a where (BRID00 = 524535) and ghrq00 between '20210105' and '20220105'