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;