Your question is SQL and Tableau Usage. Start with the requirements and the three tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
How have you used SQL and Tableau in your work thus far?
Use the supplied records to demonstrate that experience with a concise usage summary. Include analysts with no recorded activity and classify each analyst according to whether they used SQL, Tableau, both, or neither.
analyst_name, sql_query_count, successful_sql_query_count, average_runtime_ms, tableau_asset_count, published_tableau_asset_count, and tool_usage_category.analyst_id ascending. Classify usage as Both, SQL only, Tableau only, or Neither.| Column | Type | Description |
|---|---|---|
| analyst_idPK | INT | Unique analyst identifier |
| analyst_name | VARCHAR(100) | Analyst display name |
| Column | Type | Description |
|---|---|---|
| run_idPK | INT | Unique SQL run identifier |
| analyst_id | INT | Analyst associated with the SQL run |
| status | VARCHAR(20) | SQL run status |
| runtime_ms | INT | SQL runtime in milliseconds |
| Column | Type | Description |
|---|---|---|
| asset_idPK | INT | Unique Tableau asset identifier |
| owner_analyst_id | INT | Analyst who owns the Tableau asset |
| asset_name | VARCHAR(150) | Tableau asset name |
| is_published | BOOLEAN | Whether the asset is published |