W3. SQL In

Question 1

Q: What does the SQL IN operator do?

Answer 1

A: It allows you to specify multiple values in a WHERE clause, acting as a shorthand for multiple OR conditions.

Question 2

Q: Write a query to select all customers from ‘Germany’, ‘France’, or ‘UK’.

Answer 2

SELECT * FROM Customers
WHERE Country IN (‘Germany’, ‘France’, ‘UK’);

Question 3

Q: What is the syntax for using the IN operator in SQL?

Answer 3

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, …);

Question 4

Q: How do you exclude multiple values using IN?

Answer 4

A: Use NOT IN before the list of values, e.g., WHERE Country NOT IN (‘Germany’, ‘France’, ‘UK’).

Question 5

Q: Write a query to select all customers who are NOT from ‘Germany’, ‘France’, or ‘UK’.

Answer 5

SELECT * FROM Customers
WHERE Country NOT IN (‘Germany’, ‘France’, ‘UK’);

Question 6

Q: Can IN be used with a subquery?

Answer 6

A: Yes, IN can be used to match records in the main query with those in the result of a subquery.

Question 7

Q: Write a query to select all customers who have an order in the “Orders” table.

Answer 7

SELECT * FROM Customers
WHERE CustomerID IN (SELECT CustomerID FROM Orders);

Question 8

Q: What does NOT IN do when used with a subquery?

Answer 8

A: It selects records from the main query that do not match any in the subquery result.

Question 9

Q: Write a query to return all customers who have NOT placed any orders.

Answer 9

SELECT * FROM Customers
WHERE CustomerID NOT IN (SELECT CustomerID FROM Orders);