select a.avg + b.avg - c.avg from
(select avg(XX) from table1)a ,
(select avg(XX) from table2)b ,
(select avg(XX) from table3)c
若字段类型不是数字类型,可以使用CAST(字段名 AS FLOAT)转换,即AVG(CAST(字段名 AS FLOAT))
select a.avg + b.avg - c.avg from
(select avg(XX) from table1)a ,
(select avg(XX) from table2)b ,
(select avg(XX) from table3)c
若字段类型不是数字类型,可以使用CAST(字段名 AS FLOAT)转换,即AVG(CAST(字段名 AS FLOAT))