Modules

Data Analyst

Data Engineer

Product Data Scientist

AI Engineer

Machine Learning Engineer

Prompt Engineer

Practicing Operators in WHERE conditions (Hard) | SQL Beginner | Dataford

Practicing Operators in WHERE conditions (Hard)

SQL+1Hard

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

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