### MySQL SQL tables, with their properties:
#
# Table fortune.global_fortune_500_2018_2022, columns = [rank, company_name, country, employees_num, previous_rank, revenues_million, revene_change_percentage, profit_million, profit_change_percentage, asset_million, year]
Q: Compare the amount of businesses between china and the US
Let's think step by step, With the following template:
{
step: revise the question if possible, mark the question as RQ
{}
step: refer to the best practise of SQL, generate the SQL to answer RQ
{}
}
- data in column country contains name, ISO country code, e.g, China may be in ("China", "CN", "CHN")
data in column country contains name, ISO country code, e.g, China may be "China", or "CN", or "CHN", should check all
