select 

  val1.serial_no beanKey,

  val1.fail beanValNeed,

  val2.total beanValTotal

  from

  (

  select 

  count(guid)  fail ,

  serial_no

  from

   `sqm`.`sqm_value_quality_station` 

  WHERE

  result='1'

  GROUP BY

  serial_no

  ) 

  val1

  left join

  (

  select 

  count(guid) total,

  serial_no

  from

   `sqm`.`sqm_value_quality_station` 

  GROUP BY

  serial_no

  ) 

  val2

  on 

  val1.serial_no = val2.serial_no 

 

 

  select 

  val1.serial_no beanKey,

           val1.station,

  val1.fail beanValNeed,

  val2.total beanValTotal

  from

  (

  select 

  count(guid)  fail ,

  serial_no,

            station

  from

   `sqm`.`sqm_value_quality_station` 

  WHERE

  result='1'

  GROUP BY

  serial_no

  ) 

  val1

  left join

  (

  select 

  count(guid) total,

  serial_no

  from

   `sqm`.`sqm_value_quality_station` 

  GROUP BY

  serial_no

  ) 

  val2

  on 

  val1.serial_no = val2.serial_no 

 

  select 

  val1.serial_no SN,

           val1.station Station,

  val1.fail beanValNeed,

  val2.total beanValTotal

  from

  (

  select 

  count(guid)  fail ,

  serial_no,

            station

  from

   `sqm`.`sqm_value_quality_station` 

  WHERE

  result='1'

  GROUP BY

  station

  ) 

  val1

  left join

  (

  select 

  count(guid) total,

  serial_no,

          station

  from

   `sqm`.`sqm_value_quality_station` 

  GROUP BY

  station

  ) 

  val2

  on 

  val1.station = val2.station

 

select * from

`sqm`.`sqm_alarm`

where createtime

in

( select min(createtime)  from `sqm`.`sqm_alarm` group by  type)