sql中通过teamId条件在选着显示查询结果或者让查询结果为空

SELECT
teamId,
sum(sensor_income) AS sensorIncome,
sum(first_income) AS firstIncome,
sum(second_income) AS secondIncome,
sum(third_income) AS thirdIncome,
sum(fourth_income) AS fourthIncome,
sum(fifth_income) AS fifthIncome
FROM
(
SELECT
team_id AS teamId,
id
FROM
t_order
WHERE
STATUS = 2
OR STATUS = 3
) t1
RIGHT JOIN t_income_history t2 ON t1.id = t2.order_id
GROUP BY
teamId

如果teamId = 1 则结果不显示sensorIncome或者让sensorIncome为空

SELECT
teamId,
(case when teamId=1 then null else sum(sensor_income) end) AS sensorIncome,
sum(first_income) AS firstIncome,
sum(second_income) AS secondIncome,
sum(third_income) AS thirdIncome,
sum(fourth_income) AS fourthIncome,
sum(fifth_income) AS fifthIncome
FROM
(SELECT team_id AS teamId,id FROM t_order WHERE STATUS = 2 OR STATUS = 3) t1
RIGHT JOIN t_income_history t2 ON t1.id = t2.order_id
GROUP BY teamId