MY SQL #Condition Manipulation de BDD

gistfile1.txt

#condition de sorciers nées entre 1975 et 1985
Select birthday FROM wizard
WHERE birthday BETWEEN '1975-01-01' AND '1985-01-01';

#condition prénom commencant par H
Select firstname FROM wizard
WHERE firstname LIKE "H%";

#condition  Nom de famille Potter par ordre alphabétique 
Select firstname, lastname FROM wizard
WHERE lastname="Potter"
ORDER BY firstname ASC;

#condition du plus vieux 
SELECT firstname, lastname , birthday
FROM wizard 
ORDER BY birthday ASC
LIMIT 1; # donne mois seulement la première sortie

#Toutes les conditions reunni en seul code
SELECT firstname, birthday, lastname FROM wizard
WHERE firstname LIKE "H%"
AND birthday between '1975-01-01' AND '1985-01-01'
ORDER BY lastname;