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 and include all observations from the questions table.
  • Replace the NA values in the n column with 0s.