1 select * from film where film_id < 10 or title like ‘%ARK‘ and length = 50\G

1 select * from film where film_id < 10 or (title like ‘%ARK‘ and length = 50)\G

1 select concat(‘title: ‘, title, ‘ description: ‘, description) as info from film\G

1 select title, 
2 case 
3     when length <= 70 then ‘short‘ 
4     when length > 70 then ‘long‘ 
5 end 
6 as info from film where film_id = 1\G

1 select film_id, title from film order by rand() limit 5\G

1 select film_id, title from film where title is null\G

1 select film_id, coalesce(title, ‘‘) as title from film\G