Aggregate functions: MIN and MAX

1. SELECT MIN(released_year)
2. FROM books;
3.  
4. SELECT MIN(released_year) FROM books;
5.  
6. SELECT MIN(pages) FROM books;
7.  
8. SELECT MAX(pages)
9. FROM books;
10.  
11. SELECT MAX(released_year)
12. FROM books;
13.  
14. SELECT MAX(pages), title
15. FROM books;

/

/

1. SELECT * FROM books
2. WHERE pages = (SELECT Min(pages)
3. FROM books);
4.  
5. SELECT title, pages FROM books
6. WHERE pages = (SELECT Max(pages)
7. FROM books);
8.  
9. SELECT title, pages FROM books
10. WHERE pages = (SELECT Min(pages)
11. FROM books);
12.  
13. SELECT * FROM books
14. ORDER BY pages ASC LIMIT 1;
15.  
16. SELECT title, pages FROM books
17. ORDER BY pages ASC LIMIT 1;
18.  
19. SELECT * FROM books
20. ORDER BY pages DESC LIMIT 1;