The Chartio Blog

Expert advice on business intelligence to help drive data at your company.
Sign up to get the latest data tips delivered to your inbox.

tutorial

Grouping with a Case Statement

Using GROUP BY allows you to group columns to run specific SQL queries like aggregating data into a SUM, AVG or COUNT. Read this data tutorial to learn how to use a CASE STATEMENT to GROUP a column with an alias or new string.

Pivoting a Table with Amazon Redshift or PostgreSQL

A pivot table reorganizes or summarizes data in a relational table. Learn how to pivot a table with Amazon Redshift or PostgreSQL.