Login / Sign Up

SQL Questions

View All Languages
Filters:
Easy

Products-Categories Join

Open to read the full question, answer, code and follow-ups.

SQL61
#practice#learning
Read
Tricky

Sales Reporting Queries

Open to read the full question, answer, code and follow-ups.

SQL62
#practice#learning
Read
Hard

Recursive Joins

Open to read the full question, answer, code and follow-ups.

SQL63
#practice#learning
Read
Hard

Execution Plan for Joins

Open to read the full question, answer, code and follow-ups.

SQL64
#practice#learning
Read
Medium

Composite Key Join

Open to read the full question, answer, code and follow-ups.

SQL65
#practice#learning
Read
Tricky

COUNT

Open to read the full question, answer, code and follow-ups.

SQL66
#practice#learning
Read
Easy

SUM

Open to read the full question, answer, code and follow-ups.

SQL67
#practice#learning
Read
Easy

AVG

Open to read the full question, answer, code and follow-ups.

SQL68
#practice#learning
Read
Tricky

MIN

Open to read the full question, answer, code and follow-ups.

SQL69
#practice#learning
Read
Easy

MAX

Open to read the full question, answer, code and follow-ups.

SQL70
#practice#learning
Read
Medium

GROUP BY

Open to read the full question, answer, code and follow-ups.

SQL71
#practice#learning
Read
Tricky

HAVING

Open to read the full question, answer, code and follow-ups.

SQL72
#practice#learning
Read
Medium

Conditional Aggregation

Open to read the full question, answer, code and follow-ups.

SQL73
#practice#learning
Read
Medium

Aggregate with CASE

Open to read the full question, answer, code and follow-ups.

SQL74
#practice#learning
Read
Medium

Running Total

Open to read the full question, answer, code and follow-ups.

SQL75
#practice#learning
Read
Medium

Monthly Sales Report

Open to read the full question, answer, code and follow-ups.

SQL76
#practice#learning
Read
Medium

Dashboard Aggregations

Open to read the full question, answer, code and follow-ups.

SQL77
#practice#learning
Read
Tricky

Distinct Count

Open to read the full question, answer, code and follow-ups.

SQL78
#practice#learning
Read
Hard

Aggregate Performance

Open to read the full question, answer, code and follow-ups.

SQL79
#practice#learning
Read
Hard

Aggregate Optimization

Open to read the full question, answer, code and follow-ups.

SQL80
#practice#performance#learning
Read
Tricky

ROW_NUMBER

Open to read the full question, answer, code and follow-ups.

SQL81
#practice#learning
Read
Tricky

RANK

Open to read the full question, answer, code and follow-ups.

SQL82
#practice#learning
Read
Tricky

DENSE_RANK

Open to read the full question, answer, code and follow-ups.

SQL83
#practice#learning
Read
Medium

LEAD

Open to read the full question, answer, code and follow-ups.

SQL84
#practice#learning
Read
Tricky

LAG

Open to read the full question, answer, code and follow-ups.

SQL85
#sql#practice#learning
Read
Tricky

FIRST_VALUE

Open to read the full question, answer, code and follow-ups.

SQL86
#practice#learning
Read
Tricky

LAST_VALUE

Open to read the full question, answer, code and follow-ups.

SQL87
#practice#learning
Read
Tricky

OVER Clause

Open to read the full question, answer, code and follow-ups.

SQL88
#practice#learning
Read
Tricky

PARTITION BY

Open to read the full question, answer, code and follow-ups.

SQL89
#practice#learning
Read
Tricky

Running Total

Open to read the full question, answer, code and follow-ups.

SQL90
#practice#learning
Read