CODE EXAMPLE FOR SQL

Aktor yang pernah terlibat di film bergenre Aksi di sql

SELECT actor.act_fname, movie.mov_title, genres.gen_title FROM actor, movie, genres, movie_cast, movie_genres 
WHERE actor.act_id=movie_cast.act_id AND movie.mov_id=movie_genres.mov_id AND genres.gen_id=movie_genres.gen_id='action';