-------------------------------------------------------------------------
'salle'

INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE )
VALUES(1,'Bikini','Toulouse');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE )
VALUES(2,'Le Pari','Tarbes');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE )
VALUES(3,'La Gespe','Tarbes');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE )
VALUES(4,'Freddie','Paris');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE )
VALUES(5,'DeGaulle','Brest');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE )
VALUES(6,'Debian','Caen');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE)
VALUES(7,'Wankil','Amiens');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE)
VALUES(8,'Rubis','Dijon');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE)
VALUES(9,'Saphire','Nante');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE)
VALUES(10,'Emeraude','Grenoble');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE)
VALUES(11,'Zénith','Toulouse');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE)
VALUES(12,'Sarda','Bordeaux');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE)
VALUES(13,'La Soucoupe','Saint-Benoît');
INSERT INTO SALLES (NOSALLE,NOM_SALLE,VILLE)
VALUES(14,'Didier','Lille');
COMMIT;
-------------------------------------------------------------------------
'billet'
INSERT INTO BILLETS (NOBILLET,PRIX,COMPLET,ID_CONCERT )
VALUES(1,15,'O');
INSERT INTO BILLETS (NOBILLET,PRIX,COMPLET,ID_CONCERT  )
VALUES(2,100,'O',1);
INSERT INTO BILLETS (NOBILLET,PRIX,COMPLET,ID_CONCERT  )
VALUES(3,150,'N',2);
INSERT INTO BILLETS (NOBILLET,PRIX,COMPLET,ID_CONCERT  )
VALUES(4,22,'O',3);
INSERT INTO BILLETS (NOBILLET,PRIX,COMPLET,ID_CONCERT  )
VALUES(5,300,'O',4);
INSERT INTO BILLETS (NOBILLET,PRIX,COMPLET,ID_CONCERT  )
VALUES(6,100,'N',5);
INSERT INTO BILLETS (NOBILLET,PRIX,COMPLET,ID_CONCERT  )
VALUES(7,26,'O',6);
INSERT INTO BILLETS (NOBILLET,PRIX,COMPLET,ID_CONCERT  )
VALUES(8,50,'O',7);
INSERT INTO BILLETS (NOBILLET,PRIX,COMPLET,ID_CONCERT  )
VALUES(9,60,'O',8);
INSERT INTO BILLETS (NOBILLET,PRIX,COMPLET,ID_CONCERT  )
VALUES(10,70,'O',9);


-----------------------------------------------------
'SQL'
SELECT NOM_SALLE AS SALLE ,VILLE
FROM SALLES
WHERE VILLE LIKE 'T%'
ORDER BY SALLE;
-----------------------------------------------------
'SQL'