Tell me about your expertise in Python and how you use SQL in your business analysis work.
For a hands-on demonstration, use analysis_projects and analysis_activities to summarize each analyst project by recorded Python and SQL activity. Include projects without recorded activities and exclude activities that do not belong to a listed project.
project_id, project_name, analyst_name, python_activity_count, sql_activity_count, total_hours, and primary_toolstotal_hours descending, then project_id ascending| Column | Type | Description |
|---|---|---|
| project_idPK | INT | Unique project identifier |
| project_name | VARCHAR(100) | Name of the analysis project |
| analyst_name | VARCHAR(100) | Analyst assigned to the project |
| Column | Type | Description |
|---|---|---|
| activity_idPK | INT | Unique activity identifier |
| project_id | INT | Project associated with the activity |
| tool | VARCHAR(50) | Tool used for the activity |
| activity_type | VARCHAR(80) | Type of analytical activity |
| hours | DECIMAL(6,2) | Hours recorded for the activity |