Query 15. Puzzle answer density by season and puzzle

Puzzle answer density by season and puzzle.

capture the result grid in phpMyAdmin after running the query.

SELECT
    s.season_label,
    gp.puzzle_name,
    COUNT(DISTINCT gpc.row_position, gpc.column_position) AS cells,
    COUNT(gpa.person_id) AS total_answers,
    ROUND(COUNT(gpa.person_id) / NULLIF(COUNT(DISTINCT gpc.row_position, gpc.column_position), 0), 1) AS answers_per_cell
FROM grid_puzzles gp
INNER JOIN seasons s ON s.season_id = gp.season_id
INNER JOIN grid_puzzle_cells gpc ON gpc.grid_puzzle_id = gp.grid_puzzle_id
LEFT JOIN grid_puzzle_answers gpa
    ON gpa.grid_puzzle_id = gpc.grid_puzzle_id
   AND gpa.row_position = gpc.row_position
   AND gpa.column_position = gpc.column_position
GROUP BY s.season_id, s.season_label, gp.grid_puzzle_id, gp.puzzle_name
HAVING COUNT(gpa.person_id) >= 5
ORDER BY s.season_id DESC, answers_per_cell DESC, gp.puzzle_name ASC;