Identify Repeated High-Severity Accounts | Dataford Interview Questions

Write a SQL query to join incident, customer, and support tables to identify accounts with repeated high-severity incidents in the last 90 days at Cloud Security Services.

Return qualifying customer accounts with at least two high-severity incidents during the period. Include related support activity for those incidents.

Output

One row per qualifying account with account_id, customer_name, high_severity_incident_count, distinct_support_case_count, and latest_support_opened_at
Include accounts with no matching support cases, showing a count of zero and a NULL latest support timestamp
Sort by incident count descending, then account ID ascending

Your question is Identify Repeated High-Severity Accounts. Start with the requirements and the three tables 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

Write a SQL query to join incident, customer, and support tables to identify accounts with repeated high-severity incidents in the last 90 days at Cloud Security Services.

Return qualifying customer accounts with at least two high-severity incidents during the period. Include related support activity for those incidents.

Output

One row per qualifying account with account_id, customer_name, high_severity_incident_count, distinct_support_case_count, and latest_support_opened_at
Include accounts with no matching support cases, showing a count of zero and a NULL latest support timestamp
Sort by incident count descending, then account ID ascending

Your question is Identify Repeated High-Severity Accounts. Start with the requirements and the three tables 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.