Call center sample database for SQL Server
A ready-to-run SQL Server script with calls with queue, reason, wait and handle time, resolution and CSAT. Tested on SQL Server 2022 16.0.4325.4. Updated 19 November 2026.
Call center database for SQL Server
Each row is one inbound call in 2024: date and time, agent, queue, reason, seconds on hold, handle time, whether it was resolved and the 1-5 survey score (blank when the caller skipped the survey).
This page has it as a SQL Server script: one table and 1,000 rows, with column types chosen for SQL Server, primary keys. The script drops the table if it exists, creates it and inserts the rows in one transaction, so you can run it again to reset the data. It is the same fictional data, seed 42, as on the call center dataset page, where it is also available as CSV and Excel.
We loaded this exact file into SQL Server 2022 16.0.4325.4 and ran every question below on it; the answers shown are that output. The same questions, written for SQLite, PostgreSQL, MySQL, SQL Server and DuckDB, return the same results on all five.
Load it
sqlcmd
sqlcmd -S localhost -Q "CREATE DATABASE practice"
sqlcmd -S localhost -d practice -i call-center-sqlserver.sqlSSMS or Azure Data Studio
Create a database, open the .sql file in a new query window connected to it, and press Execute.
Tables and columns
call_center 1,000 rows
| Column | SQL Server type |
|---|---|
| call_id | NVARCHAR(20) |
| date | DATE |
| time | NVARCHAR(10) |
| agent | NVARCHAR(30) |
| queue | NVARCHAR(20) |
| reason | NVARCHAR(20) |
| wait_seconds | INT |
| handle_seconds | INT |
| resolved | BIT |
| satisfaction | INT |
Practice questions
answers from SQL Server 2022 16.0.4325.4
How many calls did each queue take, and what share was resolved?
SQL
SELECT queue, COUNT(*) AS calls,
ROUND(CAST(100 * SUM(CASE WHEN resolved = 1 THEN 1 ELSE 0 END) AS DECIMAL(18,6)) / NULLIF(COUNT(*), 0), 2) AS resolved_pct
FROM call_center
GROUP BY queue
ORDER BY calls DESC, queue;Yes/no columns are BIT: 1 is true and 0 is false.
Result
| queue | calls | resolved_pct |
|---|---|---|
| Technical | 358 | 67.88 |
| Billing | 319 | 86.21 |
| Returns | 169 | 87.57 |
| Sales | 154 | 85.71 |
What are the average wait and handle times by queue, in seconds?
SQL
SELECT queue, ROUND(AVG(CAST(wait_seconds AS DECIMAL(18,4))), 2) AS avg_wait, ROUND(AVG(CAST(handle_seconds AS DECIMAL(18,4))), 2) AS avg_handle
FROM call_center
GROUP BY queue
ORDER BY avg_wait DESC, queue;AVG of an INT column returns an INT in SQL Server, so the column is cast to DECIMAL first.
Result
| queue | avg_wait | avg_handle |
|---|---|---|
| Technical | 112.80 | 525.53 |
| Returns | 103.25 | 322.46 |
| Billing | 100.77 | 337.89 |
| Sales | 100.70 | 340.27 |
How many calls arrive in each hour of the day? (time is stored as HH:MM text)
SQL
SELECT SUBSTRING(time, 1, 2) AS hour, COUNT(*) AS calls
FROM call_center
GROUP BY SUBSTRING(time, 1, 2)
ORDER BY hour;SUBSTRING(text, start, length) cuts out part of a string.
Result
| hour | calls |
|---|---|
| 08 | 75 |
| 09 | 94 |
| 10 | 87 |
| 11 | 83 |
| 12 | 78 |
| 13 | 76 |
| 14 | 91 |
| 15 | 92 |
| 16 | 90 |
| 17 | 80 |
| 18 | 76 |
| 19 | 78 |
Which 5 agents have the highest average satisfaction (at least 20 calls)?
SQL
SELECT TOP 5 agent, COUNT(*) AS calls, ROUND(AVG(CAST(satisfaction AS DECIMAL(18,4))), 2) AS avg_sat
FROM call_center
GROUP BY agent
HAVING COUNT(*) >= 20
ORDER BY avg_sat DESC, agent;SELECT TOP n ... ORDER BY returns the first n rows; SQL Server has no LIMIT.
Result
| agent | calls | avg_sat |
|---|---|---|
| Linda Clark | 48 | 4.10 |
| Daniel Roberts | 56 | 4.06 |
| Charles Bell | 30 | 4.00 |
| Mary Baker | 42 | 4.00 |
| Aisha Miller | 47 | 3.94 |
What are the top 5 call reasons?
SQL
SELECT TOP 5 reason, COUNT(*) AS calls
FROM call_center
GROUP BY reason
ORDER BY calls DESC, reason;SELECT TOP n ... ORDER BY returns the first n rows; SQL Server has no LIMIT.
Result
| reason | calls |
|---|---|
| Login problem | 97 |
| Refund request | 96 |
| Invoice question | 94 |
| Setup help | 91 |
| Bug report | 89 |
How many calls were there per month?
SQL
SELECT CONVERT(char(7), date, 126) AS month, COUNT(*) AS calls
FROM call_center
GROUP BY CONVERT(char(7), date, 126)
ORDER BY month;CONVERT(char(7), date, 126) keeps the first 7 characters of the ISO date (yyyy-mm). It is faster than FORMAT() and short enough to sort a window frame on.
Result
| month | calls |
|---|---|
| 2024-01 | 73 |
| 2024-02 | 89 |
| 2024-03 | 68 |
| 2024-04 | 88 |
| 2024-05 | 81 |
| 2024-06 | 75 |
| 2024-07 | 88 |
| 2024-08 | 94 |
| 2024-09 | 85 |
| 2024-10 | 78 |
| 2024-11 | 86 |
| 2024-12 | 95 |
SQL Server differences used here
- AVG of an INT column returns an INT in SQL Server, so the column is cast to DECIMAL first.
- Yes/no columns are BIT: 1 is true and 0 is false.
- SUBSTRING(text, start, length) cuts out part of a string.
- SELECT TOP n ... ORDER BY returns the first n rows; SQL Server has no LIMIT.
- CONVERT(char(7), date, 126) keeps the first 7 characters of the ISO date (yyyy-mm). It is faster than FORMAT() and short enough to sort a window frame on.