Logical: AND &&

1. SELECT title, author_lname, released_year FROM books
2. WHERE author_lname='Eggers';
3.  
4. SELECT title, author_lname, released_year FROM books
5. WHERE released_year > 2010;
6.  
7. SELECT
8. title,
9. author_lname,
10. released_year FROM books
11. WHERE author_lname='Eggers'
12. AND released_year > 2010;
13.  
14. SELECT 1 < 5 && 7 = 9;
15. -- false
16.  
17. SELECT -10 > -20 && 0 <= 0;
18. -- true
19.  
20. SELECT -40 <= 0 AND 10 > 40;
21. --false
22.  
23. SELECT 54 <= 54 && 'a' = 'A';
24. -- true
25.  
26. SELECT *
27. FROM books
28. WHERE author_lname='Eggers'
29. AND released_year > 2010
30. AND title LIKE '%novel%';