SQLize | PHPize | SQLtest

-- Création d'une table Personnes : CREATE TABLE Personnes ( Id INT PRIMARY KEY, Nom VARCHAR(60) NOT NULL, Prenom VARCHAR(40) NOT NULL, DateNaissance DATE ); -- DESCRIBE Personnes; -- Description de la table -- Script d'insertion d'enregistrement d'acteurs de cinéma : INSERT INTO Personnes (Id, Nom, Prenom, DateNaissance) VALUES (1, 'De Niro', 'Robert', '1943-08-17'), (2, 'Pacino', 'Al', '1940-04-25'), (3, 'Streep', 'Meryl', '1949-06-22'), (4, 'Dench', 'Judi', '1934-12-09'), (5, 'Hopkins', 'Anthony', '1937-12-31'), (6, 'Mirren', 'Helen', '1945-07-26'), (7, 'Depp', 'Johnny', '1963-06-09'), (8, 'Lawrence', 'Jennifer', '1990-08-15'), (9, 'Hanks', 'Tom', '1956-07-09'), (10, 'Roberts', 'Julia', '1967-10-28'), (11, 'Winslet', 'Kate', '1975-10-05'), (12, 'Pitt', 'Brad', '1963-12-18'), (13, 'Clooney', 'George', '1961-05-06'), (14, 'Jolie', 'Angelina', '1975-06-04'), (15, 'Dujardin', 'Jean', '1972-06-19'), (16, 'Cotillard', 'Marion', '1975-09-30'), (17, 'Depardieu', 'Gérard', '1948-12-27'), (18, 'Binoche', 'Juliette', '1964-03-09'), (19, 'Firth', 'Colin', '1960-09-10'), (20, 'Thompson', 'Emma', '1959-04-15'), (21, 'McConaughey', 'Matthew', '1969-11-04'), (22, 'Bullock', 'Sandra', '1964-07-26'), (23, 'Statham', 'Jason', '1967-07-26'), (24, 'Knightley', 'Keira', '1985-03-26'), (25, 'Fiennes', 'Ralph', '1962-12-22'), (26, 'Hathaway', 'Anne', '1982-11-12'), (27, 'Redmayne', 'Eddie', '1982-01-06'), (28, 'Blanchett', 'Cate', '1969-05-14'), (29, 'Law', 'Jude', '1972-12-29'), (30, 'Damon', 'Matt', '1970-10-08'), (31, 'Waltz', 'Christoph', '1956-10-04'), (32, 'Portman', 'Natalie', NULL), (33, 'Hardy', 'Tom', '1977-09-15'), (34, 'Winslow', 'Kate', '1985-03-21'), (35, 'Hiddleston', 'Tom', '1981-02-09'), (36, 'Cumberbatch', 'Benedict', '1976-07-19'), (37, 'Theron', 'Charlize', '1975-08-07'), (38, 'Lawrence', 'Jude', '1972-12-29'), (39, 'Streisand', 'Barbra', '1942-04-24'), (40, 'DiCaprio', 'Leonardo', '1974-11-11'), (41, 'Dornan', 'Jamie', '1982-05-01'), (42, 'McAdams', 'Rachel', '1978-11-17'), (43, 'Smith', 'Will', '1968-09-25'), (44, 'Witherspoon', 'Reese', '1976-03-22'), (45, 'DeHaan', 'Dane', '1986-02-06'), (46, 'Chalamet', 'Timothee', '1995-12-27'), (47, 'Driver', 'Adam', '1983-11-19'), (48, 'Mikkelsen', 'Mads', '1965-11-22'), (49, 'Stone', 'Emma', '1988-11-06'), (50, 'Gadot', 'Gal', '1985-04-30'), (51, 'Lau', 'Tony', '1961-02-21'), (52, 'Lin', 'Chiling', '1974-11-29'), (53, 'Larson', 'Brie', '1989-10-01'), (54, 'Kaluuya', 'Daniel', '1989-05-08'), (55, 'Gyllenhaal', 'Jake', '1980-12-19'), (56, 'Smith', 'Maggie', '1972-12-28'), (57, 'Carrey', 'Jim', '1962-01-17'), (58, 'Song', 'Kang-ho', '1967-01-17'), (59, 'Yeoh', 'Michelle', '1962-08-06'), (60, 'Leung', 'Tony', '1962-06-27'), (61, 'Kunis', 'Mila', '1983-08-14'), (62, 'Spacey', 'Kevin', '1959-07-26'), (63, 'Mara', 'Rooney', '1985-04-17'), (64, 'Adams', 'Amy', '1974-08-20'), (65, 'Jeon', 'Do-yeon', '1973-02-11'), (66, 'Huppert', 'Isabelle', NULL), (67, 'Chan', 'Jackie', '1954-04-07'), (68, 'Bridges', 'Jeff', '1949-12-04'), (69, 'Chastain', 'Jessica', '1977-03-24'), (70, 'Gong', 'Li', '1965-12-31'), (71, 'Oldman', 'Gary', '1958-03-21'), (72, 'McAvoy', 'James', '1979-04-21'), (73, 'Blunt', 'Emily', '1983-02-23'), (74, 'Zhang', 'Ziyi', '1979-02-09'), (75, 'Chow', 'Stephen', '1962-06-22'), (76, 'Watson', 'Emma', '1990-04-15'), (77, 'Caine', 'Michael', '1933-03-14'), (78, 'Lee', 'Bruce', '1940-11-27'), (79, 'Gosling','Ryan', '1980-11-12'), (80, 'Bonham Carter', 'Helena', '1966-05-26'), (81, 'Boseman', 'Chadwick', '1976-11-29'), (82, 'Hart', 'Kevin', '1979-07-06'), (83, 'Hoult', 'Nicholas', '1989-12-07'), (84, 'Radcliffe', 'Daniel', '1989-07-23'), (85, 'Eisenberg', 'Jesse', '1983-10-05'), (86, 'Cheung', 'Leslie', '1956-09-12'), (87, 'Hoffman', 'Dustin', '1937-08-08'), (88, 'Norton', 'Edward', '1969-08-18'), (89, 'Robbie', 'Margot', '1990-07-02'), (90, 'Cavill', 'Henry', '1983-05-05'), (91, 'Cruz', 'Penélope', '1974-04-28'), (92, 'Reno', 'Jean', NULL), (93, 'Johansson', 'Scarlett', '1984-11-22'), (94, 'Fassbender', 'Michael', '1977-04-02'), (95, 'Affleck', 'Ben', '1972-08-15'), (96, 'Ruffalo', 'Mark', '1967-11-22'), (97, 'Park', 'Byung-hun', '1970-07-16'), (98, 'Washington', 'Denzel', '1954-12-28'), (99, 'Elba', 'Idris', '1972-09-06'), (100, 'Bening', 'Annette', '1958-05-29'); -- Requête d'extractions : SELECT ID, UPPER(Nom) AS NOM, Prenom AS Prénom, DATEDIFF(CURDATE(), DateNaissance) DIV 365 AS Age, DATE_FORMAT(DateNaissance, '%d/%m/%Y') AS Date_Naissance FROM Personnes WHERE YEAR(DateNaissance) BETWEEN 1976 AND 1995 ORDER BY Nom ASC, Prenom DESC;