Logical: GREATER THAN

1. SELECT title, released_year FROM books ORDER BY released_year;
2.  
3. SELECT title, released_year FROM books
4. WHERE released_year > 2000 ORDER BY released_year;
5.  
6. SELECT title, released_year FROM books
7. WHERE released_year >= 2000 ORDER BY released_year;
8.  
9. SELECT title, stock_quantity FROM books;
10.  
11. SELECT title, stock_quantity FROM books WHERE stock_quantity >= 100;
12.  
13. SELECT 99 > 1;
14.  
15. SELECT 99 > 567;
16.  
17. 100 > 5
18. -- true
19.  
20. -15 > 15
21. -- false
22.  
23. 9 > -10
24. -- true
25.  
26. 1 > 1
27. -- false
28.  
29. 'a' > 'b'
30. -- false
31.  
32. 'A' > 'a'
33. -- false
34.  
35. 'A' >= 'a'
36. -- true
37.  
38. SELECT title, author_lname FROM books WHERE author_lname = 'Eggers';
39.  
40. SELECT title, author_lname FROM books WHERE author_lname = 'eggers';
41.  
42. SELECT title, author_lname FROM books WHERE author_lname = 'eGGers';