SQL - Sample Interview Question (Junior Level)

Considering the following table:
Customers - 
Columns: customer_id (number, primary key), name (varchar), country_code (varchar)

What SQL statement/s will NOT return customers who are situated in Germany or Austria (?DE? and ?AT? ? ISO codes for Germany and Austria respectively)?

  1. SELECT customer_id, name FROM customers WHERE country_code IN (?DE?, ?AT?)
  2. SELECT customer_id, name FROM customers WHERE country_code = ?DE? OR country_code = ?AT?
  3. SELECT customer_id, name FROM customers WHERE country_code = ?DE? AND country_code = ?AT?
  4. SELECT customer_id, name FROM customers WHERE country_code = ANY(?DE?, ?AT?)
Tests in SQL for Juniors

Test Name Difficulty Time (minutes) No. of Questions
SQL Online Test for Juniors SQL Junior 40 20

More Specific Tests in SQL for Juniors

Test Name Difficulty Time (Minutes) No. of Questions
SQL-Basics Online Test for Juniors SQL - Basics Junior 20 10
SQL-Logic Online Test for Juniors SQL - Logic Junior 20 10