SQL Databases For dplyr Users: Grouping And Summarizing Data Using GROUP BY

[@Peter-zy5ox]

Hi Ethan, thanks for the training videos! Do you have anything similar with Joins? What if you want to join tables, add or replace columns, etc.

[@weecology]

You're welcome! Yes, we've got two videos on joins:
1. ruclips.net/video/8ir57LRKV9A/видео.html
2. ruclips.net/video/3Hw80Gl6Bgs/видео.html
For adding or replacing columns you want our video on mutate from dplyr:
ruclips.net/video/RFuJ6mgu-Ug/видео.html
which builds on this video on select.

[@TURALOWEN]

I feel like I have found a hidden treasure in these videos.

[@weecology]

That's awesome! So glad you're finding them useful

[@fabioandresvargasantonio4613]

hola con que comando del teclado ejecutas codigo SQL en el panel de R-SQL ?????????????????????

[@weecology]

Probably Ctrl-Enter (Cmd-Enter on macOS)