SQL Statement 2

Question 1

Select all customers that starts with the letter “a”;

Answer 1

SELECT * FROM Customers WHERE CustomerName LIKE ‘a%’;

Question 2

Return all customers from a city that starts with ‘L’ followed by one wildcard character, then ‘nd’ and then two wildcard characters:

Answer 2

SELECT * FROM Customers WHERE city LIKE ‘L_nd__’;

Question 3

The % wildcard represents any number of characters, even zero
characters.
Return all customers that starts with ‘La’:

Answer 3

SELECT * FROM Customers WHERE CustomerName LIKE ‘La%’;

Question 4

Return all customers that starts with ‘a’ or starts with ‘b’:

Answer 4

SELECT * FROM Customers WHERE CustomerName LIKE ‘a%’ OR
CustomerName LIKE ‘b%’;

Question 5

Return all customers that ends with ‘a’:

Answer 5

SELECT * FROM Customers WHERE CustomerName LIKE ‘%a’;

Question 6

Return all customers from a city that contains the letter ‘L’:

Answer 6

SELECT * FROM Customers WHERE city LIKE ‘%L%’;

Question 7

SELECT in Return all customers from ‘Germany’, ‘France’, or ‘UK’

Answer 7

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

Question 8

Return all customers from ‘Germany’, ‘France’, or ‘UK’

Answer 8

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

Question 9

SELECT NOT Select only the customers that are NOT from Spain:
Syntax
SELECT column1, column2, …
FROM table_name
WHERE NOT condition;

Answer 9

SELECT * FROM Customers
WHERE NOT Country = ‘Spain’;

Question 10

Condition Not Like

Answer 10

SELECT NOT LIKE SELECT * FROM Customers
WHERE CustomerName NOT LIKE ‘A%’