Project: Java Filmorate

SQL requests example:

SELECT u.name
FROM user u
ORDER BY u.id
LIMIT 10;

SELECT f.duration
FROM film f
WHERE EXTRACT(YEAR FROM CAST(f.release_date AS date)) = '2009';

SELECT f.name, g.name
FROM film AS f
LEFT OUTER JOIN genre AS g ON f.genre_id = g.id;