Read Time: 3 minutes

Hey crunchers! The Query here — the data newsletter that's like Excel for your data career, organizing and simplifying complex career information making it simple for you to continue your growth.

Here’s what we have for you today:

• An inspiring story of how an accountant transitioned into data 🧾 

• Our favorite e-commerce dataset 🏪 

• A Lengthy SQL Function

• A classic Meme

New to data analysis? START HERE.

def learn_data_analysis(👨‍💻):

1. Samuel Harting transitioned from being an accountant to an analytics engineer. Like many millennials and younger generations who were encouraged by their parents to pursue "safe" careers, Samuel initially chose accounting. However, upon recognizing that this path wasn't fulfilling his passion, he bravely shifted to a career in data. His journey is inspiring. Check it out here.

2. If you're looking to sharpen your SQL window functions skills, check out windowfunctions.com. They have great quizzes that'll help you get a grasp on those tricky SQL interview questions and refine your expertise.

select * from dataset-of-the-week

This week’s dataset is the Olist (largest department store in Brazilian marketplaces) E-commerce Dataset!

We mentioned this dataset earlier in the year, but we have so many new subscribers it’s worth mentioning again.

This dataset is perfect for a portfolio project AND for obtaining experience:

• Analyzing real-world, sales data

• Practicing SQL JOINS (there are 9 CSVs you’ll need to JOIN together)

Upload these CSVs into your database of choice and write SQL to bring your tables together.

Here are some questions to get your analysis started:

• How often is the average order value for a second purchase, larger than the first purchase?

• What is the average order value by city?

• What’s the total value of orders that haven’t been delivered?

class MiniLesson:

LENGTH Function in SQL

While analyzing data in SQL, you might need to find the number of characters in a text column.

One useful function for this purpose is the LENGTH function.

In this tip, we'll introduce you to the LENGTH function and explain how it can be helpful in your SQL queries.

What is LENGTH?

The LENGTH function is used to calculate the number of characters in a given string or column value.

It returns an number based the length of the input string.

The basic syntax for the LENGTH function is easy:

LENGTH(string)

Suppose we have a table called products with the following columns: product_id, product_name, and description.

We want to create a query that returns the product name and the length of its description.

Here's an example query using the LENGTH function:

In this query, we use the LENGTH function to calculate the length of the description column.

The result is aliased as description_length.

The LENGTH function is a helpful tool for calculating the length of strings or column values in SQL.

By using this function, you can easily find the number of characters in a text column or a specific string, which can be useful for data validation, text processing, or generating new values based on the length of existing data.

import memes as 😂 

When you’ve been taken hostage by Excel’s Artificial Intelligence…

Our 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!

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