Using the WHERE and HAVING clauses, filter the track table for the tracks with the media$\_$type$\_$id set to $1,$ grouped by the genre$\_$id having the number of tracks greater than $10.$ Provide the list of genre$\_$id's and the count of tracks that fit these criteria.

Which of the following queries would provide the correct results?

a$.)$

SELECT genre$\_$id$,$ count$($track$\_$id$)$

FROM track

WHERE media$\_$type$\_$id $=1$

GROUP BY genre$\_$id

HAVING count$($track$\_$id$)>10$

b$.)$

SELECT genre$\_$id$,$ count$($track$\_$id$)$

FROM track

WHERE media$\_$type$\_$id $=1$

HAVING count$($track$\_$id$)>10$

GROUP BY genre$\_$id

c$.)$

SELECT genre$\_$id$,$ sum$($track$\_$id$)$

FROM track

WHERE media$\_$type$\_$id $=1$

GROUP BY genre$\_$id

HAVING sum$($track$\_$id$)>10$

d$.)$

SELECT genre$\_$id$,$ count$($track$\_$id$)$

FROM track

WHERE count$($track$\_$id$)>10$

GROUP BY genre$\_$id

HAVING media$\_$type$\_$id $=1$