in which video game genre has a child genre that has a child genre of light gun shooter?
(AND cvg.cvg_genre (JOIN media_common.media_genre.child_genres (JOIN media_common.media_genre.child_genres m.03yn5x5)))