mysql-集合操作符

1.

SELECT country_id,city_id,city FROM city WHERE country_id IN (1,86);

2.

SELECT f.title,ca.name,fc.category_id FROM film_category fc 
RIGHT JOIN film f ON f.film_id=fc.film_id
LEFT JOIN category ca ON fc.category_id=ca.category_id
WHERE ca.category_id=3 AND f.rental_duration=6
UNION ALL
SELECT f.title,ca.name,fc.category_id FROM film_category fc 
RIGHT JOIN film f ON f.film_id=fc.film_id
LEFT JOIN category ca ON fc.category_id=ca.category_id
WHERE ca.category_id=5 AND f.rental_duration=5;

3.

SELECT c.customer_id FROM customer c LEFT JOIN rental r ON c.customer_id=r.customer_id
WHERE r.inventory_id <>100 group by customer_id ORDER BY customer_id DESC;