select name, sum(amountinrub) as summa
from dbo.client as c
join dbo.clientorder as co
on c.id=co.clientid
where datetime>=(select dateadd(month, -1, max(datetime)) from clientorder) and name in (select name from client group by name having count(*)>1)
group by name
order by summa desc;