SQLize Online / PHPize Online  /  SQLtest Online

-- select * from film; -- title, length, rating, rental_rate -- select title, length, rating, rental_rate from film; -- select distinct rating from film; -- order by rating; -- select title, length from film -- order by 2; -- select title, rental_rate, length, rating from film -- where rating = 'G'; -- select title, rental_rate, length, rating from film -- where rental_rate = '2.99' and rating = 'G'; -- select title, rental_rate, length, rating from film -- where rating = 'G' or rating = 'PG'; -- select title, rental_rate, length, rating from film -- where rating in ('G', "PG", "PG-13"); select title, rental_rate, length, rating from film where rating in ('G', "R") and length > 100;