# Count Clause

The COUNT() function returns the number of rows that matches a specified criterion.
```
select count(*) from orders
```

![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1659335424278/pI7vwPZts.png align="left")


From orders table, how many orders are paid with Kakaopay?
```
select count(*) from orders
where payment_method = 'kakaopay'
```

![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1659335483675/UBFniNZYs.png align="left")