/*SELECT title, YEAR, LENGTH
FROM MOVIE
WHERE YEAR=2000 OR LENGTH>120 OR LENGTH IS NULL*/

/*SELECT name, gender
FROM MOVIESTAR
WHERE name LIKE 'J%' AND BIRTHDATE > 1948
ORDER BY name DESC*/

/*SELECT studioname, COUNT(DISTINCT starname) as num_actors
FROM movie
JOIN STARSIN
ON title=MOVIETITLE
GROUP BY STUDIONAME*/

/*SELECT STARNAME, COUNT(movietitle) as num_films
FROM STARSIN
GROUP BY STARNAME*/

SELECT studioname, MOVIETITLE, MOVIEYEAR
FROM movie
JOIN STARSIN
ON title=MOVIETITLE
GROUP BY STUDIONAME, MOVIETITLE, MOVIEYEAR