#SolveWithSQL

SolveWithSQL

@solvewithsql.bsky.social

2 months ago

SQL Beginner Challenge 7: Filter Groups with HAVING Learn how to filter grouped results in SQL using the HAVING clause. In this beginner challenge, you’ll practice keeping only groups that meet a condition—an essential concept for working with aggre…

SQL Beginner Challenge #7

The product manager asks:
“Show me only the categories that have at least 2 products.”

This challenge introduces HAVING — essential when WHERE isn’t enough.

Solve it 👉 solvewithsql.com/beginner-sql... #sql #solvewithsql

SolveWithSQL

@solvewithsql.bsky.social

2 months ago

SQL Beginner Challenge 5: Remove Duplicates with DISTINCT Learn how to remove duplicate values in SQL using the DISTINCT keyword. In this beginner challenge, you’ll practice returning unique categories from a table—a common task in reporting and data prep…

SQL Beginner Challenge #5

The product manager asks:
“Which product categories do we have?”

Learn how to clean up query output using DISTINCT.
Try the challenge 👉 solvewithsql.com/beginner-sql... #sql #python #solvewithsql

SolveWithSQL

@solvewithsql.bsky.social

2 months ago

SQL Beginner Challenge 4: Count Rows with COUNT() Learn how to count rows in SQL using the COUNT() function. In this beginner challenge, you’ll write a simple query to calculate how many records exist in a table—a fundamental skill for reporting a…

SQL Beginner Challenge #4

The product manager asks:
“How many products are in our catalog?”

Starting the year 2026 with strong fundamentals.
Solve it 👉 solvewithsql.com/beginner-sql... #sql #learning #solvewithsql

SolveWithSQL

@solvewithsql.bsky.social

2 months ago

SQL Beginner Challenge 2: Filter Rows with WHERE Learn how to filter rows in SQL using the WHERE clause. In this beginner challenge, you’ll write a simple query to return only products from a specific category—an essential skill for working with …

SQL Beginner Challenge #2

The product manager asks:
“I only want to see products that belong to the Accessories category?”

Simple question.
Foundational skill.

Solve it 👉 solvewithsql.com/beginner-sql... #sql #solvewithsql

SolveWithSQL

@solvewithsql.bsky.social

2 months ago

Challenge 1: Select Specific Columns (Without Overfetching) Learn how to select only the columns you need in SQL without using SELECT *. In this beginner-friendly challenge, you’ll practice writing a clean SELECT query to return product names, prices, and c…

SQL Challenge #1 is live 👇

The product manager asks:
“Show me the product name and price for all products.”

No hints. No solution upfront.
Just you and SQL.

Start here → solvewithsql.com/beginner-sql... #SQL #LearnSQL #DataSkills #SolveWithSQL