账号

三轮测试小区

登录名：GEhQuccmadmin

密码：QRG43ls@

账号：

[问题描述]

1-统计数量未去掉逻辑删除数据！

##登记长期车辆数

select count(distinct plate_no) from b_car where community_id=140

and deleted_flag=0

and type in (0,1,4); ## 0-私家车 1-月卡车 4-白名单车

##登记的临时车辆数

select count(distinct plate_no) from b_car where community_id=140

and deleted_flag=0

and type in (2) ## 2-临时车

2-在停车辆分类有误

进出场记录未做逻辑删除，若做了逻辑删除，请剔除逻辑删除数据！

##在停车辆总数

select count(distinct plate_no) from b_car_inout where out_type=0;

##在停长期车辆数

select count(distinct plate_no) from b_car_inout where out_type=0

and plate_no in (

select plate_no from b_car where community_id=140

and deleted_flag=0

and type in (0,1,2,4)) ## 0-私家车 1-月卡车 2-临时车 4-白名单车

【需求】