Meta Data Scientist interview questions

Went through the entire process last year. Hardest I've ever prepped for an interview. Got rejected and did not get a reason. Got another email from recruiter for a call a month ago and scheduled it. Got stood up and ghosted.

SQL Query on Window Functions and Filtering, You have a table called UserActions with columns UserID, ActionDate, ActionType, and Duration (in seconds). Write a query to find the average duration of each action type (e.g., login, purchase) for each user over the past 6 months. Then, filter out any users whose average action duration for "login" actions is less than 30 seconds. Include the UserID, ActionType, and AverageDuration in your results.