Antwoorden

Oefening 2.1

select FirstName, LastName, Phone 
from Customer

Oefening 2.2

select DISTINCT Country 
from Customer;

Oefening 2.3

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

Oefening 2.4

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

Oefening 2.5

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

Oefening 2.6

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%';

Oefening 2.7

select CustomerId, Fax 
from Customer 
where fax is null;

Antwoord 2.1

select * 
from Customer
Where Country = 'Netherlands'

Antwoord 2.2

select Distinct Country
from Customer

Antwoord 2.3

select *
from Track 
where Milliseconds > 200000;

Antwoord 2.4

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

Antwoord 2.5

select Name
from Track 
order by Milliseconds desc
LIMIT 3;

2. Sorteer bovenstaande lijst van laag naar hoog.

3. Wat zijn track namen van de de 3 langste tracks