Employee Management System

EASY Other 53 questions

Comprehensive SQL practice dataset with employee data covering all major SQL SELECT concepts

0
Columns
0+
Sample Rows
Aug 2025
Last Updated
0%
Completion Rate

Practice Questions

1

Show the number of employees for each position

MEDIUM Aggregate 8 pts
0 attempts 0% success
1 hint available
Start Solving
2

List all employees in the Engineering department

EASY SELECT 5 pts
0 attempts 0% success
1 hint available
Start Solving
3

Show employee names and their salaries

EASY SELECT 5 pts
0 attempts 0% success
1 hint available
Start Solving
4

Find employees earning more than $80,000

EASY SELECT 5 pts
0 attempts 0% success
1 hint available
Start Solving
5

List employees sorted by salary (highest first)

EASY SELECT 5 pts
0 attempts 0% success
1 hint available
Start Solving
6

Show top 5 highest paid employees

MEDIUM SELECT 8 pts
0 attempts 0% success
1 hint available
Start Solving
7

Count total number of employees

EASY Aggregate 5 pts
0 attempts 0% success
1 hint available
Start Solving
8

Calculate average salary of all employees

EASY Aggregate 5 pts
0 attempts 0% success
1 hint available
Start Solving
9

Find minimum and maximum salaries

EASY Aggregate 5 pts
0 attempts 0% success
1 hint available
Start Solving
10

Count employees per department

MEDIUM Aggregate 8 pts
0 attempts 0% success
1 hint available
Start Solving
11

Calculate average salary per department

MEDIUM Aggregate 8 pts
0 attempts 0% success
1 hint available
Start Solving
12

Find departments with more than 3 employees

MEDIUM Aggregate 10 pts
0 attempts 0% success
1 hint available
Start Solving
13

List employees hired after 2020

MEDIUM SELECT 8 pts
0 attempts 0% success
1 hint available
Start Solving
14

Find employees with names starting with 'J'

MEDIUM SELECT 8 pts
0 attempts 0% success
1 hint available
Start Solving
15

List unique departments

EASY SELECT 5 pts
0 attempts 0% success
1 hint available
Start Solving
16

Find employees in Sales or Marketing departments

MEDIUM SELECT 8 pts
0 attempts 0% success
1 hint available
Start Solving
17

Calculate total salary expense per department

MEDIUM Aggregate 8 pts
0 attempts 0% success
1 hint available
Start Solving
18

Show employees sorted by hire date (newest first)

EASY SELECT 5 pts
0 attempts 0% success
1 hint available
Start Solving
19

Calculate salary statistics (min, max, avg, count)

MEDIUM Aggregate 10 pts
0 attempts 0% success
1 hint available
Start Solving
20

List employees by department and salary (department first, then salary desc)

MEDIUM SELECT 10 pts
0 attempts 0% success
1 hint available
Start Solving
21

Count employees hired each year

HARD SELECT 15 pts
0 attempts 0% success
1 hint available
Start Solving
22

Find departments with average salary above company average

HARD Subquery 15 pts
0 attempts 0% success
1 hint available
Start Solving
23

Rank employees by salary within each department

HARD Window Function 15 pts
0 attempts 0% success
1 hint available
Start Solving
24

Find employees earning more than their department average

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
25

Show employees with salary rank within their department

MEDIUM Window Function 15 pts
0 attempts 0% success
2 hints available
Start Solving
26

Find top 2 highest paid employees in each department

HARD Window Function 20 pts
0 attempts 0% success
2 hints available
Start Solving
27

Calculate salary percentile for each employee

HARD Window Function 20 pts
0 attempts 0% success
2 hints available
Start Solving
28

Show salary growth trend using LAG window function

HARD Window Function 20 pts
0 attempts 0% success
3 hints available
Start Solving
29

Find department with highest average salary using CTE

HARD CTE 20 pts
0 attempts 0% success
3 hints available
Start Solving
30

Show employees with salary above company median using CTE

HARD CTE 20 pts
0 attempts 0% success
2 hints available
Start Solving
31

Calculate salary growth rate for each employee using LAG window function

HARD Window Function 20 pts
0 attempts 0% success
3 hints available
Start Solving
32

Find employees with salary above 80th percentile in their department

HARD Window Function 20 pts
0 attempts 0% success
2 hints available
Start Solving
33

Show salary distribution within each department using NTILE window function

HARD Window Function 20 pts
0 attempts 0% success
2 hints available
Start Solving
34

Find employees with salary above the 90th percentile in their department

HARD Window Function 20 pts
0 attempts 0% success
2 hints available
Start Solving
35

Show employees with their salary rank within department

MEDIUM Window Function 15 pts
0 attempts 0% success
2 hints available
Start Solving
36

Find departments with average salary above $80,000

MEDIUM Aggregate 15 pts
0 attempts 0% success
2 hints available
Start Solving
37

Calculate salary range (max - min) by department

EASY Aggregate 10 pts
0 attempts 0% success
2 hints available
Start Solving
38

Find employees hired in 2020 or later

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
39

Show employees with salary between $70,000 and $90,000

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
40

Find employees in Engineering or Product departments

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
41

Calculate average salary by department and show only departments with average above $80,000

MEDIUM Aggregate 15 pts
0 attempts 0% success
2 hints available
Start Solving
42

Find employees whose name contains "John" using LIKE

EASY SELECT 10 pts
0 attempts 0% success
2 hints available
Start Solving
43

Show employees with their salary grade (A, B, C, D)

MEDIUM SELECT 15 pts
0 attempts 0% success
2 hints available
Start Solving
44

Find employees in the same department using self-join

MEDIUM JOIN 15 pts
0 attempts 0% success
3 hints available
Start Solving
45

Show employees with their department average salary using join

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
46

Find employees with similar salaries using self-join

MEDIUM JOIN 15 pts
0 attempts 0% success
3 hints available
Start Solving
47

Show employees with their hire year using join

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
48

Find employees with above-average salary in their department using join

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
49

Show employees with their department ranking using window function and join

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
50

Find employees with highest salary in each department using join

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
51

Show employees with their department statistics using multiple joins

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
52

Find employees hired in the same year using self-join

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving
53

Show employees with their salary percentile using window function and join

HARD JOIN 20 pts
0 attempts 0% success
3 hints available
Start Solving

Dataset Overview

Description

Comprehensive SQL practice dataset with employee data covering all major SQL SELECT concepts

Key Features

  • EASY difficulty level
  • OTHER category
  • 53 practice questions
  • 0 downloads
  • 0.0 average rating

Schema & Sample Data

Sample Data (First 3 Rows)
No sample data available.

Related Datasets

Corporate Employee Directory

MEDIUM

A corporate employee directory with 10 employees for SQL practice.

50 questions 0 downloads
View Dataset

Bookstore Inventory

EASY

A sample bookstore inventory with 10 books.

49 questions 0 downloads
View Dataset

Statistics

0.0%
Avg Score
53
Questions
0
Downloads
0%
Completion
Easy Questions
3/53
Medium Questions
3/53
Hard Questions
47/53