SQL

Using the naming system in the image,

Write a query to count the number of movies directed by people whose names contain the letter $\text{'}$a$\text{'}$ and the number of movies directed by people whose names do not contain an $\text{'}$a$\text{'}.$

Hint: You can use GROUP BY to from the two groups, and you can use COUNT to count the number of movies in the two groups. E$.$g$.$ SELECT COUNT$(*)...$