Issues with a mysql query , sub query?

Hello

Im not sure how to solve this but i want my query to only count totalaverage if number of webhosting ratings are more than "3"

But im not sure how to do this and would really appreciate if someone could help me.

SELECT 
SQL_CALC_FOUND_ROWS 
COUNT(c.reliability), 
a.packetname, 
a.drivespace, 
a.traffic, 
a.yearlyprice, 
b.title, 
b.logoimage, 
b.urlsafe, 
(AVG(c.reliability) + AVG(c.support) + AVG(c.cost)) / 3 AS totalaverage 
FROM 
webhosting_companies_packets AS a 
LEFT JOIN 
webhosting_companies AS b ON a.wid = b.id 
LEFT JOIN 
webhosting_companies_rating AS c ON c.wid = a.wid 
WHERE 1 
GROUP BY 
a.id 
ORDER BY 
totalaverage DESC

Code (markup):

I guess you cant have another condition on left join? like

LEFT JOIN 
webhosting_companies_rating AS c ON c.wid = a.wid AND COUNT(c.reliability) > 3

Code (markup):

Best Regards

John

 

How about this?

WHERE 1 GROUP BY a.id AND totalaverage > 3 ORDER BY totalaverage DESC

Code (markup):