Aggregate functions MIN and MAX with GROUP BY

1. SELECT author_fname,
2. author_lname,
3. Min(released_year)
4. FROM books
5. GROUP BY author_lname,
6. author_fname;
7.  
8. SELECT
9. author_fname,
10. author_lname,
11. Max(pages)
12. FROM books
13. GROUP BY author_lname,
14. author_fname;
15.  
16. SELECT
17. CONCAT(author_fname, ' ', author_lname) AS author,
18. MAX(pages) AS 'longest book'
19. FROM books
20. GROUP BY author_lname,
21. author_fname;