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

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: enter image description here

try this:

SELECT * , SUM(summa) AS papp FROM rent WHERE  date > NOW()
group by liige_id
SELECT *, SUM(summa) AS papp9 
FROM rent 
WHERE liige_id IN (7,8,9) 
AND date > NOW()
GROUP BY liige_id