How can i do the operation

influxql

#1

i have a measurement with format as below:

time available hostname pri_cat product sub_cat type
1 1.1.1.1 pro x php web
1 1.1.1.1 pro x nginx web

i need to calculate my sla,now i can get the sla of each individual sub_cat .

the sla of php: select mean(“available”) from “os” where “hostname”=‘1.1.1.1’ and “product”=‘x’ and “subcat”=‘php’ and “type”=‘web’ and $timeFilter

the sla of nginx: select mean(“available”) from “os” where “hostname”=‘1.1.1.1’ and “product”=‘x’ and “subcat”=‘nginx’ and “type”=‘web’ and $timeFilter

but how can i get the minimum value of these two queries ?