How to perform count(), count(distinct) in the same output using POSTGRESQL
WITH cte1 AS ( SELECT t1.keyword, t1.count(keyword) cnt
               FROM keyword t1, sent t2, tweets t3, users t4 
               WHERE t4.user_id='18839785' 
                 AND t3.id=t4.user_id 
                 AND t2.id=t3.id 
                 AND t2.id=t1.id 
                 AND t2.sent='Pos' 
               GROUP BY t1.keyword ),
     cte2 AS ( SELECT COUNT(DISTINCT keyword) cnt
               FROM cte1 )
SELECT cte2.cnt distinct_drivers, cte1.keyword positive_drivers, cte1.cnt countt
FROM cte1, cte2
ORDER BY cte1.cnt;