Courses
Programs
Companies
Quiz
Prep
About
All Challenges
Course Hub
0% Completed
Index on department
Beginner
DB: intro_v1
Description
Create an index on department column.
Mission:
Practice core SQL concepts for this chapter.
Investigation:
Create an index on department column.
Expected Outcome:
Return the correct result set.
Concept tags:
#INDEX
Estimated: 3 min
Difficulty: Beginner
Database Schema
Relationships
No relationships documented.
Tables
employees
id
name
department
salary
email
Monaco SQL Editor
Beginner
3m
Share
Show Solution
Format SQL
Run Query
Ctrl/Cmd+Enter
Loading...
SCAN
FILTER
GROUP
SORT
RESULT
Pipeline elapsed: 0ms
Shortcuts: Ctrl/Cmd+Enter run, Ctrl/Cmd+/ comment, Ctrl/Cmd+Shift+F format
#INDEX
results
preview
schema
history
progress
employees
Result Summary
Hide Details
Expected:
1
Actual:
0
Needs update
Smart Hint: You returned fewer rows. Check JOIN/WHERE.
Progressive Hints
Hint 1: Follow the prompt carefully.
Unlock Next Hint
Run a query to see results.
Tip: Explore table previews first to understand data relationships.