The Query (aka Kyle and Cody) here 👋

Here’s what we have for you today:

• Remote data jobs 💼

• Using CASE statements to pivot data 📈

• A useful SQL JOINS resource 🤝

• A festive meme 🤣🎅🏻

Looking to become a Data Analyst? START HERE.

select * from data-jobs

remote, data jobs

Because who likes writing SQL from a busy office?

1. Data Analyst @ Milliman — $66-129k per year (apply here)

2. Data Analyst II @ Renaissance — $61-85k per year (apply here)

3. Senior Data Analyst @ Misfits Market — $105-120k per year (apply here)

freelance gigs

Need work experience? Get real experience with real projects.

1. Help comparing 2 Excel files — $intermediate (apply here)

2. Short term Data Analyst needed — $100 fixed price (apply here)

3. Excel Help wanted — $intermediate (apply here)

def content_spotlight(🔦):

Joins are foundational in SQL. But for beginners, comprehending them can be daunting. You’ll need a lot of practice writing joins before the concept is second nature.

In the meantime, bookmark this article on understanding SQL joins and use it as a reference whenever you’re confused about joining two tables.

Keep this in mind — Joins should list the left table first (i.e. the table you’re joining data to). It’ll be easier for you to visualize the joins when you structure them this way.

class MiniLesson:

Pivot Data with CASE Statements

Kyle here 👋 — One useful feature of CASE statements is to pivot data dynamically.

CASE statements can transform data in ways beyond simple conditional expressions.

One interesting application of CASE statements + aggregate functions is to pivot data dynamically, creating a more readable and structured view of your dataset.

Pivoting data means converting rows into columns, which can be especially useful when dealing with categorical data.

Here's an example of how you can use the CASE statement to pivot data:

In this query, we used SUM functions and CASE statements to pivot the age_group column, converting it into separate columns for each age group's dog count.

Here is what that looks like before & after the pivot:

import memes as 😂 

content & resources 🤓 

1. Become a Data Analyst Guide: Our full guide on what it takes to land a job as a data analyst.

2. Download our SQL Cheatsheet as a PDF and desktop wallpaper here. 

3. LinkedIn: We create content on LinkedIn daily. You can follow Cody here and Kyle here.

4. Courses: Our course on showcasing your data portfolio is live!

That’s it for today.

Stay crunchin’ folks and see you next week!

— Kyle & Cody

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -