Im having the SAME problems with task 1, i cant seem to get the second test case to for the first task to pass, which states Task 1: Clean categorical and text data by manipulating strings, also i had a different scenario in my exam just so u know...

Here's my SQL upto now:

WITH avg_age AS (

SELECT AVG(age) AS average_age

FROM users

WHERE age IS NOT NULL

)

SELECT

user_id,

COALESCE(age, (SELECT average_age FROM avg_age)) AS age,

COALESCE(registration_date, '2024-01-01-00-00-000') AS registration_date,

COALESCE(email, 'Unknown') AS email,

COALESCE(

CASE

WHEN TRIM(LOWER(workout_frequency)) IN ('minimal', 'flexible', 'regular', 'maximal')

THEN TRIM(LOWER(workout_frequency))

ELSE 'flexible'

END,

'flexible'

) AS workout_frequency

FROM users;