The Query (aka Kyle and Cody) here 👋 

If you’re new to The Query, welcome!

If you’re not, let us know if you like the new format of today’s newsletter.

Here’s what we have for you today:

• We brought back jobs to The Query!

• A new section of The Query featuring Joe Squire.

• A SQL function to help you be more precise.

• A meme with a great outlook 🤣 

Looking to become a Data Analyst? START HERE.

select * from data-jobs

remote, entry-level data jobs

Because who likes writing SQL from a busy office?

1. Healthcare Data Analyst @ FAIRHealth — $65k-80k (apply here)

2. Data Analyst, Crypto @ Mastercard — $69k-107k (apply here)

3. Business Data Analyst @ Arcos — $50k-75k (apply here)

freelance gigs

Need work experience? Get real experience with real projects.

1. PowerBI Dashboard Development — $40-75 per hour (apply here)

2. Supermetrics Marketing Dashboard — $40-60 per hour (apply here)

   1. Supermetrics is a simple ETL tool you can use with Google Sheets. If you don’t know it, you can still apply and learn it “just in time.”

3. Create reports and forms in Excel — $25-75 per hour (apply here)

def creator_content_spotlight(🔦):

Cody here 👋 — If you don’t follow Joe, do you even analyze?!

He just posted an excellent breakdown showing how to prepare for phone screen interviews.

When I was interviewing 6 months ago, I made it to the next round on 100% of my phone screens.

You can too.

The trick is preparing the right way and Joe shows you how.

Check it out 👇️ 

class SQLMiniLesson:

ROUND function in SQL

Kyle here 👋 

A common mistake Data Analysts make (and one I’ve made myself) is including too many decimal places and making l stakeholders.

SQL provides a versatile function called ROUND that helps you combat this.

The ROUND function takes two arguments:

1. The number you want to round

2. The number of decimal places to round to.

If you pass a positive value as the second argument, it rounds to that many decimal places.

A negative value will round to the left of the decimal point and passing zero will round the number to the nearest integer.

Here’s an example where we have a table named product_prices and we want to round the prices multiple ways:

In this example, the query uses the ROUND function to round the prices to 2 decimal places, the nearest integer, and the nearest multiple of 10.

As a result, we can see the rounded prices for each product in our dataset.

Happy rounding 🟠 

import memes as 😂 

Pun level 💯 Can we hire this person to help us with The Query on X?

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!

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