Your question is Counting Rows in a Table. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
oasis_test_runs, including rows where optional columns contain NULL.total_rows.| 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 |