Pinned Loading

1. tables4tableau tables4tableau Public

   Putting 538 league results into a google sheet into a tableau public worksheet

   Jupyter Notebook

2. materialized_view_6.sql materialized_view_6.sql

   1

   CREATE MATERIALIZED VIEW xpert.england_unified_team_mv AS

   2

     WITH unified_teams AS (

   3

       SELECT

   4

         id,

   5

         home_team AS team

3. view_example_4.sql view_example_4.sql

   1

   CREATE VIEW xpert.england_view AS

   2

     WITH last_rows AS (

   3

       SELECT

   4

         MAX(id) AS id

   5

       FROM xpert.england

4. view_qa.sql view_qa.sql

   1

   SELECT

   2

     COUNT (DISTINCT t.id) AS table_row_count,

   3

     COUNT (DISTINCT v.id) AS view_row_count

   4

   FROM xpert.england t

   5

   LEFT JOIN xpert.england_view v USING (id)

5. materialized_view_7.sql materialized_view_7.sql

   1

   SELECT

   2

     team,

   3

     SUM(full_time_goals_scored) AS goals_scored,

   4

     SUM(full_time_goals_scored - full_time_goals_conceded) AS goal_difference,

   5

     3 * SUM(wins) + SUM(draws) AS points

6. ContraCostaCivic/BARTRidership ContraCostaCivic/BARTRidership Public archive

   Python 1