Exercise

Joining question and answer counts

We can also determine how many questions actually yield answers. If we count the number of answers for each question, we can then join the answers counts with the questions table.

Instructions

100 XP

Count and sort the question_id column in the answers table to create the answer_counts table.
Join the questions table with the answer_counts table.
Replace the NA values in the n column with 0s.

Take Hint (-30 XP)