Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
SELECT filename, rating, (SELECT SUM(rating) AS Expr1 FROM mytable AS GV WHERE GV.filename = a.filename) AS ratingsum, (SELECT COUNT(*) AS Expr2 FROM mytable AS GV WHERE GV.filename = a.filename) AS filenamecount, (SELECT COALESCE(ratingsum,1) / COALESCE(filenamecount,1)) as divnumber FROM mytable AS a
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!