I have a database of Theaters and Movies. Each Theater has a theaterID and each Movie has a theaterID to match it to its theater. I'm wanting to select a list of distinct genres from the database within a following theater and count the movies that are within the genre. 

Basically formatted like this

```
Genre    | Count
----------------
Action   |    10
Comedy   |     5
Thriller |     7

```

So far I've tried this code:

```
SELECT DISTINCT GENRE, (
    select count(distinct movie) from movies where genre = GENRE
) genre_count
from movies where theaterID = 7 SORT BY GENRE ASC;

```

and it does get a list of all the genres at that theater but for the count column it returns a count of all movies at that theater instead of the movies that match that genre. Is there a way to match those values in the inner query or I've also heard `JOIN` might work but I'm not sure how within the same table.