Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
statistics
drop table if exists my_table; create table my_table(id serial primary key, event_id integer, answers jsonb); insert into my_table (event_id, answers) values (10, '{"colores": ["Rojo", "Verde", "Azul"]}'::jsonb), (10, '{"colores": ["Amarillo", "Verde"]}'), (10, '{"colores": ["Azul"]}'), (10, '{"maderas": ["pino"]}'); SELECT jsonb_array_elements_text(answers->'colores') AS colores, count(id) FROM my_table WHERE event_id = 10 GROUP BY colores;
run
|
edit
|
history
|
help
0
revenue average per current month, last 3, 6 and 12 months
G.Giftcard Interview Analysis Conducted by Miranda Zhao
Ecommerce Website Analysis by SQL
1
Atividade 2
jsonb handle
FInale 38474297439
On conflict
Assignment 1(SET A)
Cilinica_X