Logical: BETWEEN & NOT BETWEEN

1. SELECT title, released_year FROM books WHERE released_year >= 2004 && released_year <= 2015;
2.  
3. SELECT title, released_year FROM books
4. WHERE released_year BETWEEN 2004 AND 2015;
5.  
6. SELECT title, released_year FROM books
7. WHERE released_year NOT BETWEEN 2004 AND 2015;
8.  
9. SELECT CAST('2017-05-02' AS DATETIME);
10.  
11. show databases;
12.  
13. use new_testing_db;
14.  
15. SELECT name, birthdt FROM people WHERE birthdt BETWEEN '1980-01-01' AND '2000-01-01';
16.  
17. SELECT
18. name,
19. birthdt
20. FROM people
21. WHERE
22. birthdt BETWEEN CAST('1980-01-01' AS DATETIME)
23. AND CAST('2000-01-01' AS DATETIME);