在一个中合并多个两个查询

Question

I have 3 working independently query, how I can but them as one

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()

first query results looks like that:

Answer 1

try this:

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