select 

val1.station_code, val1.fail,val2.total

from

(

select 

count(guid)  fail ,

station_code

from

`sqm`.`sqm_value_quality_station`

WHERE

result='PASS'

GROUP BY

station_code

) 

val1

left join

(

select 

count(guid) total,

station_code

from

`sqm`.`sqm_value_quality_station`

GROUP BY

station_code

) 

val2

on 

val1.station_code = val2.station_code