Loading...
Oefening 2.1
Oefening 2.2
Oefening 2.3
Oefening 2.4
Oefening 2.5
Oefening 2.6
Antwoord 2.1
Antwoord 2.2
Antwoord 2.3
Antwoord 2.4
Antwoord 2.5
Sorteer bovenstaande lijst van laag naar hoog.
Wat zijn track namen van de de 3 langste tracks
select FirstName, LastName, Phone from Customer
select DISTINCT Country from Customer;
select FirstName, LastName, Country from Customer Order By Country, LastName;
select firstname, lastname from Customer where firstname = 'Mark';
select * from customer where country = 'USA' and (city = 'New York' or city = 'Mountain View')
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%';
select CustomerId, Fax from Customer where fax is null;
select * from Customer Where Country = 'Netherlands'
select Distinct Country from Customer
select * from Track where Milliseconds > 200000;
select * from Track where Milliseconds > 200000 order by Milliseconds desc;
select Name from Track order by Milliseconds desc LIMIT 3;