Hello fellow data cruncher!

The Query here (aka Kyle and Cody) 👋

Here’s what we have for you today:

• Happy Pi Day! 3️⃣.1️⃣4️⃣

• A simpler alternative to CASE statements 📊

• A SQL window functions tutorial 👨‍💻

• Data analyst jobs 💼

• A healthy dose of memes 🤣

Looking to become a Data Analyst? START HERE.

select * from data-jobs

remote, data jobs

Open to exploring new job opportunities?

We cultivate the best data analyst jobs from around the internet to make your search easier.

Check out this week’s featured jobs here.

1. Data Analyst @ Live Nation Entertainment — $66-83k per year

2. Senior Data Analyst @ Calendly — $103-140k per year

3. Data Analyst, Growth Marketing @ Age of Learning — $90-125k per year

freelance gigs

Need work experience? Get real experience with real projects.

1. Customer Analytics — $3-30 per hour (apply here)

2. Data Analyst Needed — $entry-level (apply here)

3. Data Analysis with Python and MySQL— $intermediate (apply here)

HAPPY PI DAY!

Today is Pi Day!

The image below shows the first 2023 digits of PI — the darker the color the higher the number.

Can you spot the impressive sequence of 9’s near the middle?

def content_spotlight(🔦):

Window functions are one of the most powerful features of SQL.

They allow you to do calculations across rows instead of only working with data on the same row.

But they can be confusing especially when you’re first exposed to them.

Here is a free website dedicated to helping you understand them.

It has practice questions and other explanations that I think you’ll find helpful.

Enjoy practicing!

class SQLMiniLesson:

A Simpler Alternative to CASE Statements

Kyle here 👋 —

Sometimes CASE statements in SQL can get long and hard to read.

In certain SQL dialects (e.g. BigQuery), you can use the IF() function as a cleaner alternative.

Here’s an example:

Suppose we have the following employees table:

We want to add a column indicating if an employee is younger than 40 or not.

The code below shows how to write that with both CASE and IF().

The IF() function takes three arguments: a condition, the value to return if the condition is true, and the value to return if the condition is false.

I’m not saying you should ALWAYS use IF over CASE statements. I think it works best to use IF when the logic is very simple like the example above.

If you’ve never used it, try out IF next time you are about to write a CASE statement!

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. Open Data Analyst Jobs: Find your next data job here!

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

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

That’s it for today.

Stay crunchin’ folks and see you next week!

— Kyle & Cody

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