Muhammed

what is the best way to write this type of queries?

SELECT user_id, COUNT(*) AS clients_commented_for FROM (SELECT user_id, COUNT(*) FROM comments WHE...

I used fromSub method, I think it's the best way

SELECT id, name, (SELECT COUNT(*) FROM commentsWHEREusers.id=comments.user_idANDcreated_at>= '2...

Error Code: 1242. Subquery returns more than 1 row

try > composer dumpautoload