26 -
Voici un script SQL pour créer la table "Employe" et insérer un jeu de données :
CREATE TABLE Employe (
id INT PRIMARY KEY,
nom VARCHAR(50),
age INT,
service VARCHAR(50),
salaire DECIMAL(10, 2)
);
INSERT INTO Employe (id, nom, age, service, salaire)
VALUES
(1, 'John Doe', 28, 'Vente', 55000.00),
(2, 'Alice Smith', 32, 'Marketing', 60000.00),
(3, 'Bob Johnson', 27, 'Vente', 52000.00),
(4, 'Eva Brown', 31, 'Ressources humaines', 48000.00),
(5, 'Charlie White', 24, 'Informatique', 75000.00),
(6, 'David Lee', 35, 'Comptabilité', 62000.00),
(7, 'Grace Adams', 22, 'Marketing', 58000.00),
(8, 'Oliver Clark', 30, 'Vente', 51000.00),
(9, 'Sophia Davis', 29, 'Comptabilité', 67000.00),
(10, 'Liam Wilson', 26, 'Marketing', 63000.00);
00:00 Introduction
00:22 Enoncé de l'exercice
05:42 Création de la table & insertion des données
07:44 Question 1 (Requête 1)
12:38 Question 2 (Requête 2)
15:55 Question 3 (Requête 3)
18:39 Question 4 (Requête 4)
22:36 Récapitulatif
23:50 Conclusion
Watch video 26 - online without registration, duration hours minute second in high quality. This video was added by user Amine Abbaoui 24 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 377 once and liked it 12 people.