swann44

1- /[A]/g
2- /[0-9]{2}\/[0-9]{2}\/[0-9]{4}/g
3- /[0-9]\/[0-9]{2}/g
4- /[A-Za-z]{13}/g
5- /[a-z]{5}\:\/\/[a-z]{3}\.[a-z]{4}\.[a-z]{3}\/[a-z]{2}[0-9]{6}/g

swann44

GET https://http-practice.herokuapp.com/wilders


GET https://http-practice.herokuapp.com/wilders?page=2&language=PHP


POST https://http-practice.herokuapp.com/wilders
Content-Type: application/x-www-form-urlencoded

name=John%20Doe&language=C%23

swann44

https://google-gruyere.appspot.com/GRUYEREINSTANCEID/deletesnippet?index=0

swann44

1A
2A
3A
4B
5B
6C
7B
8A
9B

swann44

mysql> SELECT t.name, COUNT(*) AS nb_player 
    -> FROM player p
    -> JOIN team t ON t.id=p.team_id
    -> GROUP BY team_id ORDER BY nb_player DESC;
+------------+-----------+
| name       | nb_player |
+------------+-----------+
| Gryffindor |        36 |
| Slytherin  |        21 |
| Ravenclaw  |        15 |

swann44

mysql> SELECT wizard.firstname, wizard.lastname FROM player INNER JOIN wizard ON wizard.id=player.wizard_id WHERE player.role= 'seeker' ORDER BY wizard.lastname ASC, wizard.firstname ASC;
+-----------+------------+
| firstname | lastname   |
+-----------+------------+
| Cuthbert  | Binns      |
| Michael   | Corner     |
| Colin     | Creevey    |
| Gregory   | Goyle      |
| Godric    | Gryffindor |
| Helga     | Hufflepuff |

swann44

mysql> INSERT INTO school (name, country, capacity) VALUES ('Beauxbatons Academy of Magic', 'France', 550), ('Castelobruxo', 'Brazil', 380), ('Durmstrang Institute', 'Norway', 570), ('Hogwarts School of Witchcraft and Wizardry', 'United Kingdom', 450), ('Ilvermorny School of Witchcraft and Wizardry', 'USA', 300), ('Koldovstoretz', 'Russia', 125), ('Mahoutokoro School of Magic', 'Japan', 800), ('Uagadou School of Magic', 'Uganda', 350);
Query OK, 8 rows affected (0.00 sec)
Records: 8  Duplicates: 0  Warnings: 0

mysql> SELECT * FROM school;                                                                   +----+----------------------------------------------+----------+----------------+
| id | name                                         | capacity | country        |
+----+----------------------------------------------+----------+----------------+
|  1 | Beauxbatons Academy of Magic                 |      550 | France         |
|  2 | Castelobruxo                                 |      380 | Brazil         |
| 

swann44

class Decipherer {


	public static void main(String[] args) {

		String[] messages = { 
			"0@sn9sirppa@#?ia'jgtvryko1",
			"q8e?wsellecif@#?sel@#?setuotpazdsy0*b9+mw@x1vj",
			"aopi?sedohtém@#?sedhtmg+p9l!",
		};

swann44

class Movies {
	
	public static void main(String[] args) {
	
		String[] movies = {
			"Indiana Jones et le temple maudit",
			"Indiana Jones et la dernière croisade",
			"Indiana Jones et le royaume du crâne de cristal",
		};

swann44

class DerniereCroisade {
	

	public static void main(String[] args) {
		
		String MovieName = "Indiana Jones and the Last Crusade";
		System.out.println(MovieName);
		
		boolean vueFilm = false;
		System.out.println(vueFilm);