Executable File Query Analyzer: SQL Queries on File Metadata with Aggregations

Round 1 - SQL Problem You have a table file_executions that logs every time a binary is run on a system: Q1: Find the top 5 most frequently executed files in the last 30 days. Q2: For each user, find the file they ran most often, and how many times. Q3: Find files that were run by more than 10 distinct users but had a non-zero exit code (failure) on more than 50% of executions. Q4: Compute the 7-day rolling average execution duration per file. Follow-ups Q2 requires per-user ranking — write it w…