SQL Server Query by two parameter

SQL Server Query by two parameter

I have a table let's say dbo.Orders I have a query :
SELECT Orders, COUNT(*) FROM dbo.Orders
GROUP BY Orders
The result is
Order1 7
Order2 4
Order3 6
Order4 5
Etc
And a have a column with each Order number - OrderCounter What I want to
get is this :
SELECT * COUNT(*) FROM dbo.Orders
WHERE Orders IN (Order1,Order2,Order3…. )
AND to select each Order row by some value from OrderCounter – max, max-1,
max-2 etc correlated with respective order
Order1 MAX(Order1)
Order2 MAX(Order2)
Order3 MAX(Order3)
Order4 Max(Order4)
Etc