Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
select x.*, (SELECT ratingsum / filenamecount) as divnumber from ( 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 FROM mytable AS a ) x ORDER BY divnumber DESC
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.