the parent genre film noir has how many media genres?
(COUNT (AND media_common.media_genre (JOIN media_common.media_genre.parent_genre m.02xh1)))