CommencerCommencez gratuitement

How do the tables relate?

The connection to the MySQL database con has already been created for you. tables, a list containing the three tables as data frames that you've created in the previous exercise, is also available.

If you have a closer look at these tables, you'll see that the tweats table, for example, contains a column user_id. The ids in the column refer to the users that have posted the tweat. Similarly, the comments contain both a user_id and a tweat_id column. It specifies which user posted a comment on which tweat.

With this new knowledge, can you tell who posted the tweat on which somebody commented "awesome! thanks!" (comment 1012)?

Cet exercice fait partie du cours

<cours>Intermediate Importing Data in R</cours>
Voir le cours

Exercice interactif pratique

Transformez la théorie en action avec l’un de nos exercices interactifs

Commencer l’exercice