CREATE TABLE T_COMPOSITEURS_CMP
(
	CMP_ID     INT GENERATED ALWAYS AS IDENTITY,
	CMP_NOM    VARCHAR( 40 ),
	CMP_PRENOM VARCHAR( 40 ),
	CMP_NEE    SMALLINT,
	CMP_DECEDE SMALLINT
);

INSERT INTO T_COMPOSITEURS_CMP 
	( CMP_NOM, CMP_PRENOM, CMP_NEE, CMP_DECEDE )
VALUES
	( 'Fauré', 'Gabriel', 1875, 1937 );

INSERT INTO T_COMPOSITEURS_CMP
	( CMP_NOM, CMP_PRENOM, CMP_NEE, CMP_DECEDE )
VALUES
	( 'Monteverdi', 'Claudio', 1567, 1643 );

INSERT INTO T_COMPOSITEURS_CMP
	( CMP_NOM, CMP_PRENOM, CMP_NEE, CMP_DECEDE )
VALUES
	( 'Bernstein', 'Leonard', 1918, 1990 );

INSERT INTO T_COMPOSITEURS_CMP
	( CMP_NOM, CMP_PRENOM, CMP_NEE, CMP_DECEDE )
VALUES
	( 'Ravel', 'Maurice', 1875, 1937 );

INSERT INTO T_COMPOSITEURS_CMP
	( CMP_NOM, CMP_PRENOM, CMP_NEE, CMP_DECEDE )
VALUES
	( 'Mahler', 'Gustav', 1860, 1911 );

INSERT INTO T_COMPOSITEURS_CMP
	( CMP_NOM, CMP_PRENOM, CMP_NEE, CMP_DECEDE )
VALUES
	( 'Mozart', 'Wolfgang Amadeus', 1756, 1791 );
		
INSERT INTO T_COMPOSITEURS_CMP
	( CMP_NOM, CMP_PRENOM, CMP_NEE, CMP_DECEDE )
VALUES
	( 'Bach', 'Johann Sebastian', 1685, 1750 );