Trigo vision interview question

previous experience followed by sql test. simple to med level, mainly group by, cte, window function..