What libraries do you reach for when you need to visualize data quickly?
For this SQL exercise, write a query that summarizes the libraries selected for quick visualization from the provided usage records. Return every library, including libraries with no qualifying usage.
library_name, quick_use_count, and avg_setup_minutesquick_use_count descending, average setup time ascending with nulls last, then library_name ascending| Column | Type | Description |
|---|---|---|
| library_idPK | INT | Unique identifier for a visualization library |
| library_name | VARCHAR(100) | Display name of the visualization library |
| language | VARCHAR(30) | Primary programming language associated with the library |
| Column | Type | Description |
|---|---|---|
| usage_idPK | INT | Unique usage record identifier |
| library_id | INT | Referenced visualization library |
| analyst_name | VARCHAR(100) | Analyst who selected the library |
| used_for_quick_viz | BOOLEAN | Whether the library was selected for quick visualization |
| setup_minutes | NUMERIC(6,2) | Minutes needed to prepare the visualization |