WITH grouped_user_ids AS (
ClientID
, COUNT(*) AS orders_count
FROM Orders
WHERE DATE_TRUNC('year', OrderDate) = 2015
GROUP BY ClientID
)
SELECT
c.LastNAme
, c.FirstName
, g.orders_count
FROM grouped_user_ids AS g
JOIN Client AS c
ON g.ClientID = c.ClientID
WHERE g.orders_count > 25
ORDER 3 DESC;