COUNT for multiple conditions

I have a data table city like below:

SQL Query Sum Group by

I have a table similar to structure below

How to write a simple SQL query to get the maximum value in “only_full_group_by” mode?

this request is working fine.