Skip to content

Instantly share code, notes, and snippets.

View clrko's full-sized avatar
🤓

Claire Lenfant-Kodia clrko

🤓
View GitHub Profile
@clrko
clrko / txt
Created May 26, 2020 11:08
SQL_quest3
mysql> SELECT * FROM school;
Empty set (0.01 sec)
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.02 sec)
Records: 8 Duplicates: 0 Warnings: 0
mysql> SELECT * FROM school; +----+----------------------------------------------+----------+----------------+
| id | name | capacity | country |
+----+----------------------------------------------+----------+----------------+
@clrko
clrko / txt
Created May 26, 2020 10:44
SQL_ quest2
mysql> SELECT * FROM wizard WHERE birthday BETWEEN '1975-01-01' AND '1980-12-31';
+----+-----------+----------+------------+-------------+------------------------+-----------+
| id | firstname | lastname | birthday | birth_place | biography | is_muggle |
+----+-----------+----------+------------+-------------+------------------------+-----------+
| 1 | harry | potter | 1980-07-31 | london | | 0 |
| 2 | hermione | granger | 1979-09-19 | | Friend of Harry Potter | 0 |
| 4 | ron | weasley | 1980-03-01 | | Best friend of Harry | 0 |
| 6 | fred | weasley | 1978-04-01 | | | 0 |
+----+-----------+----------+------------+-------------+------------------------+-----------+
4 rows in set (0.01 sec)
@clrko
clrko / desktop_resolution.css
Created March 8, 2020 18:02
QuestX1-CssGrid
.grid {
display: grid;
grid-template-rows: repeat(5, minmax(10px auto));
grid-template-columns: repeat(3, 1fr);
grid-template-areas:
"header header header"
"carousel carousel join"
"carousel carousel form"
"fellows fellows form"
"fellows fellows footer";
@clrko
clrko / index.html
Last active February 28, 2020 11:23
Le Grand Oeil - 09 - Bootstrap : le système de grilles
<!DOCTYPE html>
<html lang="fr">
<head>
<meta charset="utf-8"/>
<meta name="author" content="Claire Kodia">
<meta name="description" content="Le Grand Œil sur sa tour de Barad-Dûr">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
<link rel="stylesheet" href="./style.css">