Practicing Operators in WHERE conditions (Hard)

Hard

Using the companies table, retrieve all companies that either:

Are based in the US with a revenue greater than $70,000, or
Are based in Canada and have a revenue less than $50,000, or
Are not from the US or Canada but have a revenue between $40,000 and$ 60,000.

Example Output:

company_name	country	revenue
Northern Innovations	Canada	45,000
Maple Tech Solutions

Using the companies table, retrieve all companies that either:

Are based in the US with a revenue greater than $70,000, or
Are based in Canada and have a revenue less than $50,000, or
Are not from the US or Canada but have a revenue between $40,000 and$ 60,000.

Example Output:

company_name	country	revenue
Northern Innovations	Canada	45,000
Maple Tech Solutions	Canada	30,000
Polar Energy	Canada	40,000