By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version |
|---|
| PostgreSQL 9.4.26 on x86_64-pc-linux-musl, compiled by gcc (Alpine 11.2.1_git20220219) 11.2.1 20220219, 64-bit |
SELECT 1
| id | name | ivalues | value | Case_Volume |
|---|---|---|---|---|
| 1 | Rene | monkey_bars | 5 | 1 |
| 1 | Rene | python | 5 | 1 |
| 2 | CJ | python | 25 | 1 |
| 2 | CJ | trading | 25 | 1 |
| 3 | Herlinda | fashion | 15 | 1 |
| 4 | DJ | consutling | 35 | 1 |
| 4 | DJ | sales | 35 | 1 |
| 5 | Martha | social_media | 45 | 1 |
| 5 | Martha | teaching | 45 | 1 |
| 6 | Doug | leadership | 55 | 1 |
| 6 | Doug | management | 55 | 1 |
| 7 | Mathew | emp_engagement | 65 | 1 |
| 7 | Mathew | finance | 65 | 1 |
| 8 | Mayers | coding | 75 | 1 |
| 8 | Mayers | crossfit | 75 | 1 |
| 8 | Mayers | sleeping | 75 | 1 |
| 9 | Mike | athletics | 85 | 1 |
| 9 | Mike | youtube | 85 | 1 |
| 10 | Peter | eat | 95 | 1 |
| 10 | Peter | python | 95 | 1 |
| 10 | Peter | sleep | 95 | 1 |
| 11 | Thomas | read | 105 | 1 |
| 11 | Thomas | sales | 105 | 1 |
| 11 | Thomas | trading | 105 | 1 |
SELECT 24
DO
| athletics | coding | consutling | crossfit | eat | emp_engagement | fashion | finance | leadership | management | monkey_bars | python | read | sales | sleep | sleeping | social_media | teaching | trading | youtube |
|---|
SELECT 0
| name | js_mivalues_arr | jprs |
|---|---|---|
| CJ | [{ "python" : 25, "trading" : 25 }] | (,,,,,,,,,,,25,,,,,,,25,) |
| DJ | [{ "consutling" : 35, "sales" : 35 }] | (,,35,,,,,,,,,,,35,,,,,,) |
| Doug | [{ "leadership" : 55, "management" : 55 }] | (,,,,,,,,55,55,,,,,,,,,,) |
| Herlinda | [{ "fashion" : 15 }] | (,,,,,,15,,,,,,,,,,,,,) |
| Martha | [{ "social_media" : 45, "teaching" : 45 }] | (,,,,,,,,,,,,,,,,45,45,,) |
| Mathew | [{ "emp_engagement" : 65, "finance" : 65 }] | (,,,,,65,,65,,,,,,,,,,,,) |
| Mayers | [{ "coding" : 75, "crossfit" : 75, "sleeping" : 75 }] | (,75,,75,,,,,,,,,,,,75,,,,) |
| Mike | [{ "athletics" : 85, "youtube" : 85 }] | (85,,,,,,,,,,,,,,,,,,,85) |
| Peter | [{ "eat" : 95, "python" : 95, "sleep" : 95 }] | (,,,,95,,,,,,,95,,,95,,,,,) |
| Rene | [{ "monkey_bars" : 5, "python" : 5 }] | (,,,,,,,,,,5,5,,,,,,,,) |
| Thomas | [{ "read" : 105, "sales" : 105, "trading" : 105 }] | (,,,,,,,,,,,,105,105,,,,,105,) |
SELECT 11
| name | athletics | coding | consutling | crossfit | eat | emp_engagement | fashion | finance | leadership | management | monkey_bars | python | read | sales | sleep | sleeping | social_media | teaching | trading | youtube |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CJ | null | null | null | null | null | null | null | null | null | null | null | 25 | null | null | null | null | null | null | 25 | null |
| DJ | null | null | 35 | null | null | null | null | null | null | null | null | null | null | 35 | null | null | null | null | null | null |
| Doug | null | null | null | null | null | null | null | null | 55 | 55 | null | null | null | null | null | null | null | null | null | null |
| Herlinda | null | null | null | null | null | null | 15 | null | null | null | null | null | null | null | null | null | null | null | null | null |
| Martha | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | 45 | 45 | null | null |
| Mathew | null | null | null | null | null | 65 | null | 65 | null | null | null | null | null | null | null | null | null | null | null | null |
| Mayers | null | 75 | null | 75 | null | null | null | null | null | null | null | null | null | null | null | 75 | null | null | null | null |
| Mike | 85 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | 85 |
| Peter | null | null | null | null | 95 | null | null | null | null | null | null | 95 | null | null | 95 | null | null | null | null | null |
| Rene | null | null | null | null | null | null | null | null | null | null | 5 | 5 | null | null | null | null | null | null | null | null |
| Thomas | null | null | null | null | null | null | null | null | null | null | null | null | 105 | 105 | null | null | null | null | 105 | null |
SELECT 11