Identifying Same-Day Hospital Admissions and Discharges

Monthly Sales Trends (chinook database)

Filtering Patients by Specific First Name Criteria in SQLite

Filter and Sort Unique Cities Starting with a Vowel from Patient Data

Filtering and Sorting Customer Data by City and Contact Name in SQLite

Finding the Tallest Patient's Name and Height

Calculating Average Unit Price, Total Stock, and Discontinued Products in SQLite

Artists Without Albums (chinook database)

Identifying Patients with Multiple Admissions for the Same Diagnosis

Retrieve Most Recent Admission Details for a Specific Patient in SQLite

Counting and Sorting Patients by City in SQLite

Top Selling Artists (chinook database)

Track Length Categories (chinook database)

Joining Patients and Province Names to Retrieve Full Details

Track names (chinook database)

Customer names (chinook database)

Finding Patients from Hamilton with Allergies Using SQL

Data Deduplication with DISTINCT

Identifying Duplicate Patient Records by First and Last Names

Filtering Patients by Specific IDs in a Hospital Database

Calculating Weight Difference for Maroni Patients in SQLite

Albums per Artist (chinook database)

Incomplete Albums (chinook database)

Identifying Provinces with More Male Patients than Female

Combining Patient and Doctor Data Using SQL UNION

Invoices by Year (chinook database)

Aggregating Data with Window Functions

Filtering Patients by Weight Range in SQLite

Multi-table Subquery

Customers Without Invoices (chinook database)

Customers by Country (chinook database)

Invoice Line Count (chinook database)

Category-Wise Average Product Price in Northwind

Playlist Duration (chinook database)

Complex Filtering using Common Table Expressions (CTE)

Calculating Admission Costs Based on Insurance Status in a Hospital Database

Aggregating Admissions Attended by Each Doctor

Filtering Customers by Country in Northwind Database

Analyzing Daily Hospital Admissions and Their Variations

Merging Customer and Supplier Data with Table Origin Column

Prioritizing 'Ontario' in Ascending Province Sort

Tracks with Multiple Genres (chinook database)

Counting Total Admissions for a Specific Patient in a Hospital Database

Working with Subqueries

Distinct city names (chinook database)

Pivoting Rows to Columns with CASE

Tracks without Purchase (chinook database)

Most Active Customers (chinook database)

Identifying Patients Without Hospital Admissions

Retrieve Even-Numbered Order IDs from the Orders Table

50 Days of SQL

Practice SQL for free and build your data science skills with these 50 problems, one problem every day. Take up this free SQL challenge and get better at programming.

50 Days of SQL

Challenges