use sakila;

SELECT * FROM city where city like "s%" order by city_id;
SELECT title FROM film where release_year="2000";
SELECT country FROM country where country like "a%";
SELECT title,description FROM film where rating="PG" group by title;
SELECT staff_id,first_name,last_name FROM staff where first_name like "jo%" group by staff_id order by first_name;

update film SET rating="PG-13" Where film_id=1;

INSERT INTO city VALUES (601,'Stavanger',90,'2006-02-15 04:45:25');

CREATE VIEW MoviesForChildren AS SELECT title, description, length FROM film WHERE rating="G";