DataBrighten

    Call center sample database for PostgreSQL

    1,000rows · 1 table · 6 questions with answers

    A ready-to-run PostgreSQL script with calls with queue, reason, wait and handle time, resolution and CSAT. Tested on PostgreSQL 15.18. Updated 19 November 2026.

    textnumberdateyes/no

    Call center database for PostgreSQL

    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 PostgreSQL script: one table and 1,000 rows, with column types chosen for PostgreSQL, 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 PostgreSQL 15.18 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

    psql

    createdb practice
    psql -d practice -f call-center-postgresql.sql

    pgAdmin or DBeaver

    Create a database, open the Query Tool, open the .sql file and run it.

    Tables and columns

    call_center 1,000 rows

    ColumnPostgreSQL type
    call_idVARCHAR(20)
    dateDATE
    timeVARCHAR(10)
    agentVARCHAR(30)
    queueVARCHAR(20)
    reasonVARCHAR(20)
    wait_secondsINTEGER
    handle_secondsINTEGER
    resolvedBOOLEAN
    satisfactionINTEGER

    Practice questions

    answers from PostgreSQL 15.18

    How many calls did each queue take, and what share was resolved?

    SQL

    SELECT queue, COUNT(*) AS calls,
           ROUND(1.0 * 100 * SUM(CASE WHEN resolved THEN 1 ELSE 0 END) / NULLIF(COUNT(*), 0), 2) AS resolved_pct
    FROM call_center
    GROUP BY queue
    ORDER BY calls DESC, queue;

    Yes/no columns are real BOOLEAN values, so they can be used directly in WHERE and CASE.

    Result

    queuecallsresolved_pct
    Technical35867.88
    Billing31986.21
    Returns16987.57
    Sales15485.71
    What are the average wait and handle times by queue, in seconds?

    SQL

    SELECT queue, ROUND(AVG(wait_seconds), 2) AS avg_wait, ROUND(AVG(handle_seconds), 2) AS avg_handle
    FROM call_center
    GROUP BY queue
    ORDER BY avg_wait DESC, queue;

    AVG of an integer column returns a numeric, so no cast is needed.

    Result

    queueavg_waitavg_handle
    Technical112.80525.53
    Returns103.25322.46
    Billing100.77337.89
    Sales100.70340.27
    How many calls arrive in each hour of the day? (time is stored as HH:MM text)

    SQL

    SELECT substr(time, 1, 2) AS hour, COUNT(*) AS calls
    FROM call_center
    GROUP BY substr(time, 1, 2)
    ORDER BY hour;

    substr(text, start, length) cuts out part of a string.

    Result

    hourcalls
    0875
    0994
    1087
    1183
    1278
    1376
    1491
    1592
    1690
    1780
    1876
    1978
    Which 5 agents have the highest average satisfaction (at least 20 calls)?

    SQL

    SELECT agent, COUNT(*) AS calls, ROUND(AVG(satisfaction), 2) AS avg_sat
    FROM call_center
    GROUP BY agent
    HAVING COUNT(*) >= 20
    ORDER BY avg_sat DESC, agent
    LIMIT 5;

    LIMIT n at the end returns the first n rows.

    Result

    agentcallsavg_sat
    Linda Clark484.10
    Daniel Roberts564.06
    Charles Bell304.00
    Mary Baker424.00
    Aisha Miller473.94
    What are the top 5 call reasons?

    SQL

    SELECT reason, COUNT(*) AS calls
    FROM call_center
    GROUP BY reason
    ORDER BY calls DESC, reason
    LIMIT 5;

    LIMIT n at the end returns the first n rows.

    Result

    reasoncalls
    Login problem97
    Refund request96
    Invoice question94
    Setup help91
    Bug report89
    How many calls were there per month?

    SQL

    SELECT to_char(date, 'YYYY-MM') AS month, COUNT(*) AS calls
    FROM call_center
    GROUP BY to_char(date, 'YYYY-MM')
    ORDER BY month;

    to_char(date, 'YYYY-MM') formats a date as year-month text.

    Result

    monthcalls
    2024-0173
    2024-0289
    2024-0368
    2024-0488
    2024-0581
    2024-0675
    2024-0788
    2024-0894
    2024-0985
    2024-1078
    2024-1186
    2024-1295

    PostgreSQL differences used here

    • AVG of an integer column returns a numeric, so no cast is needed.
    • Yes/no columns are real BOOLEAN values, so they can be used directly in WHERE and CASE.
    • substr(text, start, length) cuts out part of a string.
    • LIMIT n at the end returns the first n rows.
    • to_char(date, 'YYYY-MM') formats a date as year-month text.