Created a new page showing the hometowns of members and a ranking of prefectures.
Wrote a script that tabulates the hometowns of members in the database. I wanted to display the prefectures from north to south, so I downloaded “prefecture codes” used by the Japanese government and put them in a table. An INNER JOIN was used in the SQL query to combine the two tables, and ORDER BY based on the prefecture codes was used to display the results from north to south.