JonesCharly

### Keybase proof

I hereby claim:

  * I am jonescharly on github.
  * I am charlyjones (https://keybase.io/charlyjones) on keybase.
  * I have a public key ASDNIPy9p_8-TqPQvDeNPnBWmESSaBGN4kk7SytgSakdIwo

To claim this, I am signing this object:

JonesCharly

select lastname, firstname, role, name
from wizard
inner join player inner join team
ORDER BY name, role, lastname, firstname;

select lastname, firstname, role
from wizard 
inner join player WHERE role ='seeker' 
ORDER BY lastname, firstname ;

JonesCharly

const express = require('express');
const connection = require('./conf');
const app = express();
const port = 3000;
const bodyParser = require('body-parser');
// Support JSON-encoded bodies
app.use(bodyParser.json());
// Support URL-encoded bodies
app.use(bodyParser.urlencoded({
  extended: true

JonesCharly

const express = require('express');
const connection = require('./conf');
const app = express();
const port = 3000;
const bodyParser = require('body-parser');
// Support JSON-encoded bodies
app.use(bodyParser.json());
// Support URL-encoded bodies
app.use(bodyParser.urlencoded({
  extended: true

JonesCharly

const express = require('express');
const connection = require('./conf');
const app = express();
const port = 3000;

app.get('/', (request, response) => {
  response.send('Bienvenue sur Express Project');
});

app.get('/api/employees', (req, res) => {

JonesCharly

const express = require('express');
const app = express();
const port = 3000;

app.get('/', (request, response) => {
  response.send('Bienvenue sur Express Project');
});

app.get('/api/movies', (request, response) => {
    response.send('Récupération de tous les films');

JonesCharly

const http = require("http")
const url = require("url")

const port = 3000

const server = http.createServer((req, res) => {
  const page = url.parse(req.url).pathname

  let name = page.slice(9)

JonesCharly

 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) ;
      
------

JonesCharly

SELECT * FROM  wizard WHERE birthday BETWEEN '1975-01-01' AND '1985-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 |
|  5 | ginny     | weasley  | 1981-08-11 |             | Sister of Ron and girlfriend of Harry |         0 |
|  6 | fred      | weasley  | 1978-04-01 |             |                                       |         0 |

JonesCharly

interface ADesPattes {
    pattes: number;
} 

interface AUneCouleur {
    color?: string; // "?" veut dire que c'est optionnel 
}

function Caresse(pattes: number){
    if (pattes === 4) {