Homework 3 Solutions
--------------------

1. SELECT type, avg(pages) FROM Titles GROUP BY type;

2. SELECT type, avg(pages) FROM Titles GROUP BY type HAVING avg(pages) >= 200;

3. SELECT type, avg(pages) FROM Titles GROUP BY type HAVING avg(price) >= 20;

4. SELECT title_name FROM Titles ORDER BY LEN(title_name), title_name;

5. SELECT title_name FROM Titles WHERE MONTH(pubdate) = 7 OR MONTH(pubdate) = 8;

6. SELECT title_name, pubdate FROM Titles
	WHERE YEAR(DATE()) - YEAR(pubdate) <= 4;

7. SELECT Left(au_fname, 1) + '. ' + au_lname FROM Authors
	WHERE au_fname IS NOT NULL AND au_lname is NOT NULL AND
	au_fname NOT LIKE '' AND au_lname NOT LIKE '';