Hello
I have this querys:
SELECT genre
FROM movies
WHERE genre="Animation"
SELECT COUNT(genre) AS Total
FROM movies
WHERE genre="Animation";
SELECT SUM(rating) AS SUMX
FROM movies
WHERE (genre="Animation");
The querys are working well separately, but now i want the result= SUMX/Total
Genre |SUMX |TOTAL |RESULT
Animation 6 2 3
Anyone knows help me?
Thanks!