SQL 1

USE movies;

SELECT *
FROM movie;

-- Opalqnka

/* hihihi
hihih */

-- Wronggg
SELECT title, LENGTH / 60.0
FROM movie;

-- Gooodd
SELECT title, LENGTH / 60.0 AS MovieLen
FROM movie;

SELECT * FROM STUDIO;

SELECT ADDRESS FROM STUDIO WHERE NAME = 'MGM';


SELECT * FROM MOVIESTAR;

SELECT NAME, BIRTHDATE FROM MOVIESTAR WHERE NAME = 'Sandra Bulloc';

SELECT * FROM STARSIN;

SELECT MOVIETITLE FROM STARSIN WHERE MOVIEYEAR >= 1980 AND MOVIETITLE LIKE 'Empire';