Collection runner results in Postman - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

What is the total number of requests run in this collection?

Given a collection runner result summary, determine the total number of requests executed.

Postman

SELECT COUNT(*) AS total_requests FROM collection_runner_results;

A 20

B 10

C 15

D 25

💡 Hint

Look for the total count of requests executed in the results table.

The collection runner summary shows 15 requests were executed in total.

📝 Syntax

intermediate

Identify the syntax error in this query to fetch failed requests

Find the syntax error in the following SQL query that tries to select all failed requests from collection runner results.

Postman

SELECT * FROM collection_runner_results WHERE status = 'failed';

A No syntax error

B Incorrect table name

C Missing quotes around 'failed'

D Missing semicolon at the end

💡 Hint

Check if the query follows standard SQL syntax.

The query is syntactically correct and will run without errors.

❓ optimization

advanced

Optimize this query to get average response time per request name

Given this query, choose the optimized version that efficiently calculates average response time grouped by request name.

Postman

SELECT request_name, AVG(response_time) FROM collection_runner_results GROUP BY request_name;

A SELECT request_name, AVG(response_time) FROM collection_runner_results GROUP BY request_name;

B SELECT request_name, SUM(response_time)/COUNT(*) FROM collection_runner_results GROUP BY request_name;

C SELECT request_name, MAX(response_time) FROM collection_runner_results GROUP BY request_name;

D SELECT request_name, AVG(response_time) FROM collection_runner_results;

💡 Hint

Use built-in aggregate functions with proper grouping.

Option A uses AVG with GROUP BY correctly and is the most efficient and clear.

🧠 Conceptual

advanced

What does the 'iterations' field represent in collection runner results?

In the context of Postman collection runner results, what does the 'iterations' field represent?

A Number of environments used

B Number of requests in the collection

C Number of failed requests

D Number of times the entire collection was run

💡 Hint

Think about how many times the whole set of requests is executed.

Iterations count how many times the entire collection was executed during the run.

🔧 Debug

expert

Why does this query return zero rows when filtering by status 'passed'?

Given the query: SELECT * FROM collection_runner_results WHERE status = 'passed'; but it returns zero rows, what is the most likely cause?

Postman

SELECT * FROM collection_runner_results WHERE status = 'passed';

A The table is empty

B The status values are stored in uppercase like 'PASSED'

C The column name is misspelled

D The query syntax is invalid

💡 Hint

Check the exact stored values and case sensitivity.

If status values are uppercase, filtering by lowercase 'passed' returns no rows.