View gist:fdb1ff6f4c35a6795ee7704b17fc1d2e
CREATE TABLE clients (
id INT primary key,
nom VARCHAR(255),
prenom VARCHAR(255),
ZIP INT
);
INSERT INTO clients (id, nom, prenom, ZIP) VALUES (1,"TOTO", "André", 63000);
INSERT INTO clients (id, nom, prenom, ZIP) VALUES (2,"TATA", "André", 99000);
INSERT INTO clients (id, nom, prenom, ZIP) VALUES (3,"fgdfgdf", "Henri", 98000);
INSERT INTO clients (id, nom, prenom, ZIP) VALUES (4,"fgdfgdf", "Henri", 75000);