[바짝스터디 1주차 과제] ARRAY, STRUCT, PIVOT, FUNNEL 연습문제

1. ARRAY, STRUCT 문제

1)

SELECT
  title,
  genre
FROM advanced.array_exercises
CROSS JOIN UNNEST(genres) AS genre;

2)

SELECT
  title
  , actor.actor
  , actor.character
FROM advanced.array_exercises
CROSS JOIN UNNEST(actors) AS actor;

3)

SELECT
  title
  , actor.actor
  , actor.character
  , genre
FROM advanced.array_exercises
CROSS JOIN UNNEST(actors) AS actor
CROSS JOIN UNNEST(genres) AS genre

4)

SELECT
  user_id
  , event_date
  , event_name
  , user_pseudo_id
  , event_param.key
  , event_param.value.string_value
  event_param.value.int_value
FROM advanced.app_logs
CROSS JOIN UNNEST(event_params) AS event_param
WHERE
  event_date = '2022-08-01'

2. PIVOT 연습문제

1)