Using SQL Server's Pivot Function to Get One-to-Many String Results as Columns in a Combined Query

Transforming a Categorical Column into the Level 0 of a Column Multi-Index Using Pandas

SQLite: Using Conditional Aggregation and Pivoting to Select Multiple Counts from a Single Column