Pinned Loading

1. migratorr migratorr Public

   R and PostgreSQL template project to get help with data migrations for Workday ERP/SIS systems

   PLpgSQL

2. ufo-uap-data-science-project ufo-uap-data-science-project Public

   Exploration of the NUFORC dataset that shows UFO/UAP reports up to December 2021

   R 3

3. datapointsr datapointsr Public

   Painless QC analysis for big statistical tables

   R

4. dbr dbr Public

   Facade for common database connections like SQL Server, Amazon Redshift, PostgresSQL and SQLite databases

   R

5. SQL Essentials SQL Essentials

   1

   -- SELECT WITH GROUP BY AND JOIN

   2

   SELECT 

   3

       C.country, 

   4

       C.team, 

   5

       SUM(M.goals) 

6. SQL Tables SQL Tables

   1

   INSERT INTO TargetTable

   2

   SELECT * FROM SourceTable;

   3

   4

   INSERT INTO Orders (CustomerID, OrderDate, TotalAmount)

   5

   VALUES