Mysql 充电站SQL查询1--171221--mysql-sql

来源：互联网发布：地面站软件下载编辑：程序博客网时间：2024/05/06 19:27

--当月至现在查询支付成功后未成功充电的情况

select c.a 失败数,c.b 总数,c.a1,c.cs 失败率,c.cc 成功率,c1.name from (
   select a,a1,b,b1,round(a/b*100,2) cs,100-round(a/b*100,2) cc from (
       select count(t1.serial_number) a,serial_number a1 from (
           select * from t_charge_record t
           where t.create_time > '2017-12-01 00:00:00'
       ) t1
       where t1.start_time is null
       group by t1.serial_number
       ) t,
       (select count(t1.serial_number) b,serial_number b1 from (
           select * from t_charge_record t
           where t.create_time > '2017-12-01 00:00:00'
       ) t1
       group by t1.serial_number
       ) tt
       where t.a1 = tt.b1
   )c
left join t_charge_box c1
   on c.a1 = c1.serial_number
order by cs desc

阅读全文

0 0