i'd like some help writing an sql statement that brings back the shows in a specific category.

For example an sql statement that will bring back shows from the action genre in the tables below

NPFXq.png