logo

Oracle NextGen

score

SQL Challenge

Challenge #2 – Count Employees

EasyGo Back
Challenge Overview
Count the total number of employees in the company.

Requirements

  • •Return a single column named 'total_employees'.
  • •Use the COUNT function to count all rows.
Sample Dataset
Preview the schema and seeded rows you can query against.

employees

Contains employee information.

Columns
NameTypeNotes
employee_idINTPrimary key
employee_nameVARCHAREmployee name
departmentVARCHARDepartment name
salaryDECIMALAnnual salary
Sample Rows
employee_idemployee_namedepartmentsalary
1John DoeEngineering75000
2Jane SmithMarketing65000
3Bob JohnsonEngineering80000
4Alice BrownHR60000
5Charlie WilsonSales70000
SQL Playground
Loading editor…

Result Preview

Awaiting Run

Run your query to see the dataset preview.