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

Opdrachten

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;