Top Security Log Customers | Dataford Interview Questions

Write a SQL query to find the top five customers with the highest volume of security logs over the last thirty days.

Use the customers and security_logs tables. Count only logs associated with a known customer and logged within the last thirty days.

Output

One row per customer, with customer_id, customer_name, and log_volume.
Return at most five customers, ordered by log_volume descending, with customer_id ascending as the tie-breaker.

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(150)	Customer display name

security_logs

Column	Type	Description
log_idPK	INT	Unique security log identifier
customer_id	INT	Customer associated with the log
logged_at	DATE	Date the security log was recorded
log_source	VARCHAR(80)	Originating security monitoring source

Your question is Top Security Log Customers. Start with the requirements and the two 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.