nordic_comet_7043

Given scores (a dictionary of name:score pairs), use a for loop with .items() to print only the name

Given letters, build a dictionary called freq that maps each character to how many times it appears

Given keys and values, use dict() and zip() to create a dictionary called info

Given names and scores, use zip() to pair them and print each pair in the format 'name: score', one

Given words, use enumerate() to find the indices of all words that have more than 4 characters

Given tasks, use enumerate() with start=1 to print a numbered task list

Given fruits, use enumerate() to print each fruit with its index in the format 'index: fruit'

Group events by the 'source' field extracted from payload using JSON_EXTRACT_SCALAR

Find button click events and extract the button_id from the payload JSON column.

Use a CTE to extract the first and second tags from the tags array