This is database structure :

Field names
id (integer), title (char(70)), yr(decimal(4)), gross (integer), budget(integer)

I need query for this problem "List all of the Star Trek movies, include the id title and yr. (All of these movies include the words Star Trek in the title.)"

Thanks

I think query should be like this "SELECT id , title , yr from movie WHERE title like = 'Star Trek%'"