# Where Clause

Show me all data from orders table excluding '웹개발 종합반'.
```
select * from orders
where course_title != "웹개발 종합반";
```



Show me all data from orders created on 13th July 2020 and 14th July 2020.
```
select * from orders
where created_at between '2020-07-13' and '2020-07-15'
```

Show me comment from those who are in week 1 or 3 only.
```
select * from checkins 
where week in (1, 3);
```
**Options in the parentheses can be more than 2. 

Show me users having daum email account.

```
select * from users 
where email like '%daum.net';
```
% means show me everything that ends with 'daum.net'


```
where email like 'a%t'
```
means anything that starts with a and ends with t.


Quiz1.
Data where a card is not used as a payment method.
```
select * from orders
where payment_method != 'CARD';
```

Quiz2.
Users who are having 20000-30000 points.
```
select * from point_users
where point between 20000 and 30000
```


Quiz3.
Users whose email starts with s and ends with com.
```
select * from users
where email like 's%com';
```


Quiz4.
Uses whose email starts with s and ends with com and the family name is '이'.
```
select * from users
where email like 's%com' and name = "이**";
```