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 ascendingstatus equals succeeded.tool_name equals BigQuery.success_rate as the successful-run percentage, rounded to 2 decimal places.avg_duration_seconds to 2 decimal places.| 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 |