\a
SELECT * FROM actedIn ORDER BY id DESC LIMIT 10;
id|movie_id|person_id
239|162|146
238|162|163
237|162|77
236|162|165
235|162|164
234|162|71
232|161|71
230|159|148
229|159|160
228|159|71
(10 rows)
SELECT * FROM actedIn WHERE movie_id = 0;
id|movie_id|person_id
7|0|8
3|0|4
2|0|3
1|0|2
0|0|1
(5 rows)
SELECT * FROM actedInWithCustomWhere1 WHERE movie = 'The Matrix' AND actor = 'Keanu Reeves';
actor|movie
Keanu Reeves|The Matrix
(1 row)
SELECT * FROM actedInWithCustomWhere2 WHERE movie = 'The Matrix' AND actor = 'Keanu Reeves';
actor|movie
Keanu Reeves|The Matrix
(1 row)
SELECT * FROM actedInWithCustomWheres WHERE movie = 'The Matrix' AND actor = 'Keanu Reeves';
actor|movie
Keanu Reeves|The Matrix
(1 row)
select * from actedInWithCustomWhere1 where actor IN ('Keanu Reeves','Thom Hamks');
actor|movie
Keanu Reeves|Something's Gotta Give
Keanu Reeves|Johnny Mnemonic
Keanu Reeves|The Replacements
Keanu Reeves|The Devil's Advocate
Keanu Reeves|The Matrix Revolutions
Keanu Reeves|The Matrix Reloaded
Keanu Reeves|The Matrix
(7 rows)
select * from actedInWithCustomWhere2 where actor IN ('Keanu Reeves','Thom Hamks');
actor|movie
Keanu Reeves|Something's Gotta Give
Keanu Reeves|Johnny Mnemonic
Keanu Reeves|The Replacements
Keanu Reeves|The Devil's Advocate
Keanu Reeves|The Matrix Revolutions
Keanu Reeves|The Matrix Reloaded
Keanu Reeves|The Matrix
(7 rows)