SQLize | PHPize | SQLtest

-- select * from film; -- commenting the lines -- select title,length, rating,rental_rate from film; -- select rating from film -- select distinct rating from film -- order by rating; -- select title, length from film -- order by length desc; -- select title ,length from film -- order by 2; -- select title,length, rating,rental_rate from film -- where rating = 'G' -- select title,length, rating,rental_rate from film -- where rating = 'G' and rental_rate= 2.99 -- select title,length, rating,rental_rate from film -- where rating in( 'G' ,'PG'); -- select title,length, rating,rental_rate from film -- where length >= 100 and rating Not in('G','R') -- select title,length, rating,rental_rate from film -- where title like 's%' -- select title,length, rating,rental_rate from film -- where title like '%r_t' -- select * from film -- limit 5; select rating, count(title) from film group BY rating;