W3. SQL Not

Question 1

Q: What does the SQL NOT operator do?

Answer 1

A: It returns the opposite or negative result of a specified condition.

Question 2

Q: Write a query to select all customers that are NOT from Spain.

Answer 2

SELECT * FROM Customers 
WHERE NOT Country = 'Spain';

Question 3

Q: What is the general syntax for using the NOT operator?

Answer 3

SELECT column1, column2, …
FROM table_name
WHERE NOT condition;

Question 4

Q: How would you write a query to select customers whose names do not start with “A”?

Answer 4

SELECT * FROM Customers 
WHERE CustomerName NOT LIKE 'A%';

Question 5

Q: Write a query to select customers with CustomerID not between 10 and 60.

Answer 5

SELECT * FROM Customers 
WHERE CustomerID NOT BETWEEN 10 AND 60;

Question 6

Q: How do you use NOT with the IN operator to exclude certain values?

Answer 6

A: Use NOT IN, e.g., WHERE City NOT IN (‘Paris’, ‘London’);

Question 7

Q: Write a query to select customers who are not from Paris or London.

Answer 7

SELECT * FROM Customers 
WHERE City NOT IN ('Paris', 'London');

Question 8

Q: How do you select customers with a CustomerID not greater than 50?

Answer 8

SELECT * FROM Customers 
WHERE NOT CustomerID > 50;

Question 9

Q: Is there an alternative syntax for “not greater than”?

Answer 9

A: Yes, !> can be used as a “not greater than” operator.

Question 10

Q: How do you select customers with a CustomerID not less than 50?

Answer 10

SELECT * FROM Customers 
WHERE NOT CustomerID < 50;

Question 11

Q: Is there an alternative syntax for “not less than”?

Answer 11

A: Yes, !< can be used as a “not less than” operator.