Ten tasks that mix everything from the beginner units, in no particular order. None of them says which function to use: read the task, look at the tables in the explorer, and decide.
If you get stuck, the hints go from a nudge to nearly the answer. Every result is also checked against a second copy of the data with different values, so a query that lists the right IDs by hand won't pass. Write the rule the task describes instead.
Watch for the Snowflake details from the last lessons: names come back in capitals, lowercase names need double quotes, text values are case-sensitive, and timestamps need half-open ranges.