select * from wizard where birthday between '1975-01-01' and '1985-12-31' and is_muggle='0';

select * from wizard where firstname like 'H%';

select firstname, lastname from wizard where lastname='Potter' order by firstname;

select firstname, lastname, birthday from wizard order by birthday asc limit 0,1;