sum,count,group by

 

select  sum(guid)  from `sqm`.`sqm_value_quality_station` WHERE result='PASS'
  GROUP BY station_code

 

 

 

select  count(guid)  from `sqm`.`sqm_value_quality_station` WHERE result='PASS'
  GROUP BY station_code