Counting Occurrences in SQL | Dataford Interview Questions

Write a query to count specific occurrences in a dataset.

Count all rows where occurrence_type is exactly ERROR.

Output

occurrences

Column	Type	Description
occurrence_idPK	INT	Unique identifier for an occurrence record
occurrence_type	VARCHAR(30)	Categorical type assigned to the occurrence
source_system	VARCHAR(40)	System that recorded the occurrence

Your question is Counting Occurrences in SQL. 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.

Write a query to count specific occurrences in a dataset.

Count all rows where occurrence_type is exactly ERROR.

occurrences

Column	Type	Description
occurrence_idPK	INT	Unique identifier for an occurrence record
occurrence_type	VARCHAR(30)	Categorical type assigned to the occurrence
source_system	VARCHAR(40)	System that recorded the occurrence

Your question is Counting Occurrences in SQL. 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.