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

[@PPPP-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. kzbin.info/www/bejne/bprVZmqCh7CJb6M 2. kzbin.info/www/bejne/aXnaaWN9oZt1ndU For adding or replacing columns you want our video on mutate from dplyr: kzbin.info/www/bejne/iHfYe2mjnNpgi8k 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)