SQL. Statistic by products. Before formating

WITH Orders as ( SELECT [UserId],name as [Product],[date] FROM [dbo].[Order] o join [dbo].OrderDetails od on o.id = od.orderId join [dbo].Product p join od.productId = p.id
where o.id in (SELECT max(o.id) FROM [dbo].[Order] o join [dbo].OrderDetails od on o.id = od.orderId join [dbo].Product p join od.productId = p.id group by userId, [Product])
)
select UsersView.Id, MAX(CASE WHEN Orders.[Product] = 'Смузи' THEN Orders.[date] ELSE NULL END) AS smuzi, MAX(CASE WHEN Orders.[Product] = 'Стейк' THEN Orders.[date] ELSE NULL END) AS steak
FROM UsersView LEFT OUTER JOIN Orders on UsersView.Id = Orders.UserId
GROUP BY UserView.Id