Divide Queries

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!

Solved.

SELECT genre, SUM (rating) AS TOTAL_SUM, COUNT(genre) AS TOTAL_GENRE, SUM(rating)/COUNT(genre) AS Total
FROM movies
WHERE Genre="Animation"
GROUP BY genre

Thanks anw

you can replace COUNT(genre) with COUNT(*) since genre will never be NULL in this query

you can also replace SUM(rating)/COUNT(genre) with AVG(rating)