Example queries against this table

1. Select customers from India or USA

   SQLCopy

   SELECT name, city, country
   FROM customers
   WHERE country IN ('India', 'USA', 'United States')
   ORDER BY country, city;

2. List all unique countries from customers

   SQLCopy

   SELECT DISTINCT country
   FROM customers
   WHERE country IS NOT NULL
   ORDER BY country;

3. Find customers whose email contains "gmail"

   SQLCopy

   SELECT name, email, city
   FROM customers
   WHERE email ILIKE '%gmail%';

4. Find customers NOT from India

   SQLCopy

   SELECT name, country, city
   FROM customers
   WHERE country != 'India' -- or: WHERE country <> 'India'
   ORDER BY country;