The Query (aka Kyle and Cody) here 👋

Here’s what we have for you today:

• A fun dataset for your next project 🥅

• A tip for working with NULLs in SQL 🤝

• It’s not too early to apply to these remote data jobs 💼

• Another funny SQL 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 @ Nest Health — $70-90k per year (apply here)

2. Data Analyst @ Edward Jones — $78-134k per year (apply here)

3. Senior Data Analyst @ Vroom — $96-144k per year (apply here)

freelance gigs

Need work experience? Get real experience with real projects.

1. Data Analysis in Excel — $35-60 per hour (apply here)

2. Excel Help — $10-50 per hour (apply here)

3. Small Business KPIs — $entry level (apply here)

def content_spotlight(🔦):

Here’s a fun dataset to for a data analysis project… ⚽️

This week we’re featuring a robust dataset of International Football (Soccer) Results from 1873 - 2023.

This dataset contains results of 45,315 games!

It would be interesting to see if there are any trends in the time goals were scored or periods of team dominance.

There is so much you could do with this dataset! Have fun and tag us on LinkedIn to let us know what you discover!

class MiniLesson:

Dealing with NULL Values in SQL

Kyle here 👋 — When working with data in SQL, you’ll inevitably encounter NULL values.

The COALESCE function is a handy tool that can help you out!

COALESCE can be particularly useful when you want to provide a default value for a column that may have NULL values.

Let's look at an example.

Suppose you have a table called products with product_id, name, price, and discount.

In this table, the discount column contains NULL values for some products.

You want to calculate the final price of each product after applying the discount.

If the discount is NULL, you want to treat it as 0.

You can use the COALESCE function to achieve this.

The COALESCE function ensures that if the discount is NULL, it is treated as 0, allowing you to calculate the final price correctly.

COALESCE is a powerful tool for handling NULL values, allowing you to provide default values when needed.

This can help you avoid unexpected results when performing calculations or displaying data, making it a useful tool for data analysts.

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

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