Lesson Code: http://www.developphp.com/video/SQL/SQL-Select-Most-Common-Record-Occurrence-List
Learn the SQL syntax of a very useful database query. This single query is full of logic that you can carry into other queries you need to write. Learn to group occurrences, count, order and limit the result set. It is useful for finding the most popular occurrences in your databases and rendering a list of them.