Counting Rows in a Table | Dataford Interview Questions

The Aristocrat QA team stores automated and manual test executions for the Oasis casino management system in a single table. Write a PostgreSQL query that returns the total number of test execution records.

Requirements

Count every row in oasis_test_runs, including rows where optional columns contain NULL.
Return one row with the result aliased as total_rows.

Schema

oasis_test_runs

Column	Type	Description
test_run_idPK	INTEGER	Unique test execution identifier
test_suite	VARCHAR(100)	Name of the QA test suite
environment	VARCHAR(30)	Environment where the test ran
execution_status	VARCHAR(20)	Test result status
executed_by	VARCHAR(100)	Person or automation process that executed the test

Your question is Counting Rows in a Table. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Requirements

Count every row in oasis_test_runs, including rows where optional columns contain NULL.
Return one row with the result aliased as total_rows.

Schema

oasis_test_runs

Column	Type	Description
test_run_idPK	INTEGER	Unique test execution identifier
test_suite	VARCHAR(100)	Name of the QA test suite
environment	VARCHAR(30)	Environment where the test ran
execution_status	VARCHAR(20)	Test result status
executed_by	VARCHAR(100)	Person or automation process that executed the test

Your question is Counting Rows in a Table. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.