Corporate Employee Directory

MEDIUM Other 50 questions

A corporate employee directory with 10 employees for SQL practice.

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

Practice Questions

1

List all employees in the Engineering department

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

Count employees per department

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

List employees hired before 2022

EASY SELECT 5 pts
0 attempts 0% success
Start Solving
4

Find the highest salary

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

Calculate average salary by department

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

List Sales employees sorted by salary (high-low)

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

Find second-highest salary

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

Count employees hired per year

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

List employees with "Manager" in position

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

Calculate total salary expenditure

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

Find earliest hire date

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

Find salary difference from average

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

Count positions with "Engineer"

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

Find department with most employees

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

List employees A-Z

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

Backup old employees (>3y tenure)

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

List employees in Marketing department

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

Show all employees and their salary bonus (10% for >2y tenure)

HARD SELECT 20 pts
0 attempts 0% success
1 hint available
Start Solving
19

Find employees hired after 2020

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

Show all employees and their department, sorted by department

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

Find employees earning more than their department average

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

Show employees with salary rank within their department

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

Find top 2 highest paid employees in each department

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

Calculate salary percentile for each employee

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

Show salary growth trend using LAG window function

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

Find department with highest average salary using CTE

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

Show employees with salary above company median using CTE

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

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
29

Find employees with salary above 80th percentile in their department

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

Show salary distribution within each department using NTILE window function

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

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
32

Show employees with their salary rank within department

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

Find departments with average salary above $80,000

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

Calculate salary range (max - min) by department

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

Find employees hired in 2020 or later

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

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

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

Find employees in Engineering or Product departments

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

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
39

Find employees whose name contains "John" using LIKE

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

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

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

Find employees in the same department using self-join

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

Show employees with their department average salary using join

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

Find employees with similar salaries using self-join

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

Show employees with their hire year using join

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

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

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

Show employees with their department ranking using window function and join

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

Find employees with highest salary in each department using join

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

Show employees with their department statistics using multiple joins

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

Find employees hired in the same year using self-join

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

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

A corporate employee directory with 10 employees for SQL practice.

Key Features

  • MEDIUM difficulty level
  • OTHER category
  • 50 practice questions
  • 0 downloads
  • 0.0 average rating

Schema & Sample Data

Sample Data (First 3 Rows)

salary position hire_date last_name department first_name manager_id employee_id
95000.0 Software Engine… 2021-03-15 Wilson Engineering James 105 101
78000.0 Digital Strateg… 2022-06-01 Johnson Marketing Sarah 108 102
85000.0 Account Executi… 2020-11-30 Chen Sales Robert 108 103
110000.0 DevOps Speciali… 2019-08-22 Davis Engineering Emily 105 104
135000.0 Tech Lead 2018-05-10 Thompson Engineering Michael 110 105

Related Datasets

Employee Management System

EASY

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

53 questions 0 downloads
View Dataset

Bookstore Inventory

EASY

A sample bookstore inventory with 10 books.

49 questions 0 downloads
View Dataset

Statistics

0.7%
Avg Score
50
Questions
0
Downloads
2%
Completion
Easy Questions
3/50
Medium Questions
3/50
Hard Questions
44/50