---

SELECT name
FROM playlist
WHERE name LIKE '%Classic%';


SELECT billing_address, billing_country
FROM invoice
WHERE billing_country IN ('USA', 'India', 'Canada', 'Argentina', 'France');



SELECT billing_address, billing_country
FROM invoice
WHERE billing_country IN ('USA', 'India', 'Canada', 'Argentina', 'France')
  AND billing_city NOT IN ('Redmond', 'Lyon', 'Delhi');


SELECT *
FROM invoice
WHERE DATE(invoice_date) BETWEEN '2009-03-04' AND '2012-02-09'
  AND total < 5
  AND billing_country NOT IN ('Canada', 'Brazil', 'Finland');



SELECT title
FROM film
WHERE description LIKE '%Mexico'
  AND (rental_rate < 2 OR rating <> 'PG-13');



SELECT name
FROM track
WHERE (
        milliseconds > 300000
        AND composer LIKE '%Bono%'
        AND genre_id IN (7, 8, 9, 10)
      )
   OR bytes > 1000000000;