Some hints to make up for some limited/bad diagnostic messages in the challenge answer engine..

If any of you have gotten this far (and are still struggling) let me advise you that

some of the Bummer! messages that say something about your "count" being wrong

or unhelpful messages saying error near such and such

will probably not be as helpful in getting to the right answer as

re-watching the video that immediately precedes the challenge question.

This SQL Reporting course (unlike many at Treehouse) does really try to provide

a reasonably tight "coupling" between the SQL code presented in the videos

and what SQL code is expected in the challenges (as least better than using google

to search for relevant SQL code --since their are many different SQL language variations possible).

This course tends toward using SQLite mostly,

but the cheat sheets it provides (in lieu of not having a downloadable zip file for the course)

do include links to multiple types/flavors of SQL:

https://github.com/treehouse/cheatsheets/blob/master/sql_basics/cheatsheet.md

https://github.com/treehouse/cheatsheets/blob/master/reporting_with_sql/cheatsheet.md

A few selected "hints" for the SQL code of various challenges in this aggregate and number functions section:

Link to challenge:

https://teamtreehouse.com/library/reporting-with-sql/aggregate-and-numeric-functions/counting-groups

SELECT genre, COUNT(*) AS genre_count FROM books GROUP BY genre;

SELECT COUNT(DISTINCT genre) AS total_genres FROM books;

Link to challenge:

https://teamtreehouse.com/library/reporting-with-sql/aggregate-and-numeric-functions/calculating-the-minimum-and-maximum-values

SELECT MIN(rating) AS star_min, MAX(rating) AS star_max FROM reviews WHERE movie_id = 6;

Link to challenge:

https://teamtreehouse.com/library/reporting-with-sql/aggregate-and-numeric-functions/performing-math

SELECT name, ROUND(price/1.4,2) AS price_gbp FROM products;

Link to challenge:

https://teamtreehouse.com/library/reporting-with-sql/aggregate-and-numeric-functions/averaging-values

SELECT AVG(rating) AS average_rating FROM reviews WHERE movie_id = 6;

SELECT SUM(rating) AS starman_total_ratings FROM reviews WHERE movie_id = 6;

More hints for the next (data and time) section can be found here:

https://teamtreehouse.com/community/some-hints-to-make-up-for-some-limitedbad-diagnostic-messages-in-the-challenge-answer-engine-2