> For the complete documentation index, see [llms.txt](https://chankyungpak.gitbook.io/ebis3003-2021/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://chankyungpak.gitbook.io/ebis3003-2021/sql/select-functions.md).

# Select / Functions

#### Task 1: **Count the number of projects where the project is completed.**

```
mysql> SELECT COUNT(*) FROM projects_kick WHERE completion = 1;
```

* Note the use of `*`.
* Note the use of a function.
* And the condition.

#### Task 2: **Count the number of projects that are created by creator 1 AND the requested budget is larger than 1,000.00.**

```
mysql> SELECT COUNT(*) FROM projects_kick 
        WHERE creator_id = 1 
        AND total_amount > 1000;
```

Note the use of multiple conditions.