⌁ Databases · Challenge 01

Query the table.
Join the data.

A company database holds employees and departments. Explore the schema, write SELECT queries to retrieve records, filter and sort with WHERE and ORDER BY, then aggregate and join tables to answer real business questions.

SQL-1301 · db-node-01 · query fundamentals

4objectives

10minute target

100points

SQL session

Challenge Lab · SQL Fundamentals

Enter your name exactly as it should appear on your certificate.

Your lab runs entirely in this browser. No account is required.

Database assessment

SQL Fundamentals Challenge

TIME00:00

SCORE0/100

Mission brief

Query the company database

BEGINNER

The database company has two tables: employees (id, name, dept_id, salary) and departments (id, name, location). Explore and query them.

1
Explore the schema
List the tables and their structure.
20 pts
2
Basic SELECT
Retrieve columns from the employees table.
25 pts
3
Filter & sort
Use WHERE and ORDER BY.
25 pts
4
Aggregate & join
Use COUNT/GROUP BY and JOIN.
30 pts

Progress0 of 4 complete

Need a hint?Open SQL guide

Schema: SHOW TABLES, DESCRIBE employees.

Select: SELECT name, salary FROM employees;

Filter: SELECT * FROM employees WHERE salary > 50000 ORDER BY salary DESC;

Aggregate: SELECT dept_id, COUNT(*) FROM employees GROUP BY dept_id;

Join: SELECT e.name, d.name FROM employees e JOIN departments d ON e.dept_id = d.id;

Type help to see all supported commands.

db-node-01 — SQL shell

ISOLATED · SIMULATED

  ____   _______        __
 |  _ \ / ___\\ \      / /
 | |_) | |    \ \ /\ / /
 |  _ <| |___  \ V  V /
 |_| \_\\____|  \_/\_/

RCW SQL Practice Environment

Query the company database. Enter help for available commands. End queries with ;

Queries complete

Excellent work, Learner!

You explored the schema, wrote SELECT queries, filtered and sorted with WHERE and ORDER BY, then aggregated and joined the employee and department tables.

Final score

100/ 100

PERFECT SCORE

SQL fundamentals complete

Objectives: 4 / 4
Completion time: 00:00
Statements entered: 4

Your achievement

Certificate ready

PDF

Issued by RCW IT Training and signed by Pradeep Raju.

🎖️ View your Skill Passport

Query the table.Join the data.

Challenge Lab · SQL Fundamentals

SQL Fundamentals Challenge

Excellent work, Learner!

Certificate ready

Query the table.
Join the data.