> For the complete documentation index, see [llms.txt](https://metis-montessori-lyceum.gitbook.io/sql-0/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://metis-montessori-lyceum.gitbook.io/sql-0/2-selectie-voorwaarden-en-sorteren/antwoorden.md).

# Antwoorden

**Oefening 2.1**

```sql
select FirstName, LastName, Phone 
from Customer
```

**Oefening 2.2**

```sql
select DISTINCT Country 
from Customer;
```

**Oefening 2.3**

```sql
select FirstName, LastName, Country 
from Customer 
Order By Country, LastName;
```

**Oefening 2.4**

```sql
select firstname, lastname 
from Customer 
where firstname = 'Mark';
```

**Oefening 2.5**

```sql
select * 
from customer 
where country = 'USA' and (city = 'New York' or city = 'Mountain View');
```

**Oefening 2.6**

```sql
select firstname, lastname 
from Customer 
where firstname like 'A%' or
firstname like 'E%' or
firstname like 'O%' or
firstname like 'U%' or
firstname like 'I%';
```

## Opdrachten

```sql
select CustomerId, Fax 
from Customer 
where fax is null;
```

**Antwoord 2.1**

```sql
select * 
from Customer
Where Country = 'Netherlands'
```

**Antwoord 2.2**

```sql
select Distinct Country
from Customer
```

**Antwoord 2.3**

```sql
select *
from Track 
where Milliseconds > 200000;
```

**Antwoord 2.4**

```sql
select *
from Track 
where Milliseconds > 200000 
order by Milliseconds desc;
```

**Antwoord 2.5**

```sql
select Name
from Track 
order by Milliseconds desc
LIMIT 3;
```