5. Filtering Data

Question 1

Retrieve all customers who are not from Germany.

Answer 1

select * from customers
where country <> 'Germany';

Question 2

Retrieve all customers with a score not less than 500.

using NOT operator

Answer 2

select * from customers
where NOT score < 500;

Question 3

Retrieve all customers whose score falls in the range between 100 and 500

(inclusive of boundary values)

Answer 3

select * from customers where
score between 100 and 500;

Question 4

Retrieve all customers living in either US, India or England

Answer 4

select * from customers
where country IN ('US', 'India', 'England');

Question 5

Retrieve names of customers starting with ‘M’

Answer 5

select * from customers
where name like 'M℅'

Question 6

Retrieve names of customers whose names end with ‘in’.

Answer 6

select * from customers where
name like '℅in'

Question 7

Find all customers whose name contains ‘r’

Answer 7

select * from customers where
name like '℅r℅'

Question 8

Find all customers whose name has ‘r’ in the 3rd position.

Answer 8

select * from customers where
name like ‘__r%’