Exercise

Finding gaps between questions and answers

Now we'll join together questions with answers so we can measure the time between questions and answers.

Instructions

100 XP

Use an inner join to combine the questions and answers tables using the suffixes "_question" and "_answer", respectively.
Subtract creation_date_question from creation_date_answer within the as.integer() function to create the gap column.

Take Hint (-30 XP)