Skip to content

Learn Functions Examples Practice Interview Cheatsheet Playground

easy problems

List Active Customers Actors Born After 1985 Authors From the USA Average Product Price Book Title Search Books Published After 2015 Fiction Books Cheapest Product Completed Orders Only Count All Movies Count Customers Count Employees Per Department Count Pending Orders Distinct Customer Cities Customers in Seattle Customers by Signup Date List Departments Distinct Book Genres Employee Full Names Employees by Hire Date Employees in Engineering Lowest Paid Employee Highest Salary Drama Movies Movies With 'The'Movies After 2018 Movies Released Since 2020 Newest Movie Products Above $50 Electronics Products Product Count by Category Select Active Customers Student Names Starting A Students by Grade Level Students Enrolled in 2021 Students in Grades 10 and 11 Total Product Stock Top Paid Employees Total Store Revenue

Home

List Departments

easyemployeesselect

List Departments

Problem

Return the name and location of all departments, ordered by name.

Try It

Employees & Departments

Loading database engine...

Hint

Solution

On this page

Problem
Try It
Hint
Solution

The definitive resource for learning SQL — from your first SELECT to advanced window functions — with a real database running in your browser.

Learn Functions Examples Practice Interview Cheatsheet Playground About Contact

© 2026 SQLSimplified. Learn SQL by doing.

Search

Search lessons, functions, examples, and practice problems