select c.country, c.city, count(o.Order_ID) as c, sum (count(o.Order_ID))
over(partition by c.country)  as s, max(count(o.order_ID))
over(partition by c.country)  as m
from Customers c, Orders o
where c.Customer_ID = o.Customer_ID
group by c.city, c.country;