php - 将两个以上的查询合并为一个

Question

我有 3 个独立工作的查询，我怎么能把它们作为一个呢

SELECT * , SUM(summa) AS papp9 FROM rent WHERE liige_id = 9 AND date > NOW()
SELECT * , SUM(summa) AS papp8 FROM rent WHERE liige_id = 8 AND date > NOW()
SELECT * , SUM(summa) AS papp7 FROM rent WHERE liige_id = 7 AND date > NOW()

第一个查询结果是这样的:

Answer 1

试试这个:

SELECT * , SUM(summa) AS papp FROM rent WHERE  date > NOW()
group by liige_id