-- Exercice 1

INSERT INTO pokemon VALUES (19, 'Rattata', 'Souris', 20, 'Admin'),
	(39, 'Rondoudou', 'Bouboule', 4145, 'Moustache');

INSERT INTO Defense VALUES (3, 2, '10-10-2016');
INSERT INTO Defense VALUES (3, 2, SYSDATE);

INSERT INTO Joueur VALUES ('Flavius', 'Ruth', 'M', 20, 2),
	('Asterix', 'Ruth', 'M', 5, 1);

UPDATE Joueur SET niveau = 15 WHERE sexe='F';

DELETE FROM Pokemon WHERE espece LIKE '%fruit%';

DELETE FROM Joueur WHERE nom='Admin';

-- Exercice 2

SELECT *
FROM Arene
WHERE nom LIKE '%eisti%';

SELECT *
FROM Pokemon
WHERE LOWER(nom) LIKE 'p%';

SELECT *
FROM pokemon
WHERE nom NOT LIKE '%a%';

SELECT *
FROM Pokemon
ORDER BY pointCombat DESC;

SELECT AVG(duree)
FROM Apparition;

SELECT COUNT(*)
FROM Apparition
WHERE horaire betwwen '1-10-2016' AND '30-10-2016';
WHERE MONTH(horaire)=10 AND YEAR(horaire)=2016;
SELECT nom
FROM Pokemon
WHERE espece = (SELECT espece FROM Pokemon WHERE nom='Pikachu');