Logical: IN and NOT IN

1. show databases();
2. use book_shop;
3.  
4. SELECT
5. title,
6. author_lname
7. FROM books
8. WHERE author_lname='Carver' OR
9. author_lname='Lahiri' OR
10. author_lname='Smith';
11.  
12. SELECT title, author_lname FROM books
13. WHERE author_lname IN ('Carver', 'Lahiri', 'Smith');
14.  
15. SELECT title, released_year FROM books
16. WHERE released_year IN (2017, 1985);
17.  
18. SELECT title, released_year FROM books
19. WHERE released_year != 2000 AND
20. released_year != 2002 AND
21. released_year != 2004 AND
22. released_year != 2006 AND
23. released_year != 2008 AND
24. released_year != 2010 AND
25. released_year != 2012 AND
26. released_year != 2014 AND
27. released_year != 2016;
28.  
29. SELECT title, released_year FROM books
30. WHERE released_year NOT IN
31. (2000,2002,2004,2006,2008,2010,2012,2014,2016);
32.  
33. SELECT title, released_year FROM books
34. WHERE released_year >= 2000
35. AND released_year NOT IN
36. (2000,2002,2004,2006,2008,2010,2012,2014,2016);
37.  
38. SELECT title, released_year FROM books
39. WHERE released_year >= 2000 AND
40. released_year % 2 != 0;
41.  
42. SELECT title, released_year FROM books
43. WHERE released_year >= 2000 AND
44. released_year % 2 != 0 ORDER BY released_year;