0% Completed

Employee + department

BeginnerDB: intro_v1

Description

Join employees with departments and show employee name and department name.

Mission:Practice the core SQL concept for this chapter.

Investigation:Join employees with departments and show employee name and department name.

Expected Outcome:Return the correct result set.

Concept tags:

#INNER JOIN

Estimated: 3 minDifficulty: Beginner

Database Schema

Relationships

No relationships documented.

Tables

departments

iddepartment_name

employees

idnamedepartment_idsalary

Monaco SQL EditorBeginner3m

SCAN

FILTER

GROUP

SORT

RESULT

Pipeline elapsed: 0ms

Shortcuts: Ctrl/Cmd+Enter run, Ctrl/Cmd+/ comment, Ctrl/Cmd+Shift+F format

#INNER JOIN

Result Summary

Expected: 4

Actual: 0

Needs update

Smart Hint: You returned fewer rows. Check JOIN/WHERE.

Progressive Hints

Hint 1: Follow the pattern in the prompt.

Run a query to see results.

Tip: Explore table previews first to understand data relationships.