I enjoyed this one. The select query was more interesting than creating the view - it was cool to see how different people used different ways to get the result on that (CTE, subqueries, other methods).

Details say to have results "grouped by each department and then each day." but the expected data has it grouped by day and then by department.

Phrasing for the challenge was confusing. In order to gain the requirements, I had to look at the unit tests. It would be better to phrase the challenge as "Return a list of two columns with the department ID and department name for all departments with at least one sale over $98. You must use the IN operator. You may not use JOIN."

You souldn't have a join at all. There's no reason to join tables that you're not pulling data from.

CAST(123.454 AS FLOAT)