SELECT * FROM FILM;

SELECT * FROM  FILM FIL
JOIN FILM_ACTOR FACT ON FIL.FILM_ID=FACT.ACTOR_ID
JOIN ACTOR ACT ON FACT.ACTOR_ID=ACT.ACTOR_ID
WHERE ACT.first_name='Johnny';

SELECT * FROM  FILM FIL
JOIN FILM_ACTOR FACT ON FIL.FILM_ID=FACT.ACTOR_ID
JOIN ACTOR ACT ON FACT.ACTOR_ID=ACT.ACTOR_ID
WHERE ACT.first_name='Johnny' OR ACT.first_name='PENELOPE' ;

SELECT * FROM  FILM FIL
JOIN FILM_ACTOR FACT ON FIL.FILM_ID=FACT.ACTOR_ID
JOIN ACTOR ACT ON FACT.ACTOR_ID=ACT.ACTOR_ID
WHERE ACT.first_name='Johnny' AND ACT.first_name='PENELOPE' ;

SELECT * FROM FILM_CATEGORY FI
JOIN CATEGORY CA ON CA.CATEGORY_ID=FI.CATEGORY_ID
WHERE CATEGORY_ID='ACTION'AND CATEGORY_ID='COMEDY';


SELECT * FROM FILM
WHERE TITLE LIKE 'A%';


SELECT * FROM FILM
WHERE TITLE LIKE '%B';

SELECT * FROM PAYMENT
WHERE AMOUNT BETWEEN 0 AND 5;

SELECT * FROM FILM
WHERE NOT TITLE='ANALYZE HOOSIERS';