I have database consist off Names table $,$ profession table $($contain names id and profession$),$ crew table$($ it contain all the unique combinations of names id and title id who $)$ title table contain title id and title of the movie and then the gerne table that contain the uniqie combination of titleid and genre. what i want is : Count the number of people involved $($in any job role$)$ with titles of each genre as well as the total

number of people involved $($again in any job role$)$ regardless of genre. so give me the query to generate this. at the end i should have to columns one for genra types and the other is the total numbr of people involved in each genre.