Tell me about your SQL skills and how you use tools like BigQuery in past projects or internships.
Demonstrate your answer by summarizing project query activity from the provided tables. Include only projects with at least one BigQuery run and at least two successful runs.
project_name, total_runs, successful_runs, success_rate, and avg_duration_secondssuccess_rate descending, average duration ascending, then project_name ascending| Column | Type | Description |
|---|---|---|
| project_idPK | INT | Unique project identifier |
| project_name | VARCHAR(100) | Project name |
| Column | Type | Description |
|---|---|---|
| run_idPK | INT | Unique query run identifier |
| project_id | INT | Project associated with the run |
| tool_name | VARCHAR(50) | SQL or analytics tool used for the run |
| run_date | DATE | Date when the query ran |
| status | VARCHAR(20) | Run outcome |
| duration_seconds | DECIMAL(10,2) | Query duration in seconds |