SQL-Fundamentals-Portfolio-Project-Employee-Management-Database/01_Create_Database.sql at main · Kwuosa10/SQL-Fundamentals-Portfolio-Project-Employee-Management-Database · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
CREATE DATABASE SQLPractice;
GO

USE SQLPractice;
GO

CREATE TABLE Employees (
    EmployeeID INT PRIMARY KEY,
    FirstName VARCHAR(30),
    LastName VARCHAR(30),
    Department VARCHAR(30),
    JobTitle VARCHAR(50),
    City VARCHAR(30),
    Salary DECIMAL(10,2),
    Age INT,
    YearsAtCompany INT,
    PerformanceRating INT
);

INSERT INTO Employees VALUES
(1,'John','Smith','IT','Data Analyst','Lagos',3500,28,2,4),
(2,'Sarah','Johnson','HR','HR Manager','Abuja',5200,39,10,5),
(3,'Michael','Brown','Finance','Accountant','Lagos',4300,31,5,3),
(4,'Emily','Davis','IT','Data Scientist','Port Harcourt',6500,29,3,5),
(5,'David','Wilson','Sales','Sales Executive','Abuja',2800,26,2,2),
(6,'Jessica','Taylor','Marketing','Marketing Officer','Lagos',3700,30,4,4),
(7,'Daniel','Thomas','Finance','Financial Analyst','Kano',4700,35,7,5),
(8,'Sophia','Moore','IT','Database Administrator','Lagos',5600,38,8,4),
(9,'James','Martin','Sales','Sales Manager','Port Harcourt',6200,42,12,5),
(10,'Olivia','Jackson','HR','Recruiter','Kano',3300,27,2,3),
(11,'William','White','Marketing','Digital Marketer','Abuja',4100,33,6,4),
(12,'Emma','Harris','IT','Software Engineer','Lagos',5900,25,2,5),
(13,'Benjamin','Clark','Finance','Auditor','Port Harcourt',4500,36,9,4),
(14,'Charlotte','Lewis','Sales','Sales Executive','Lagos',3000,24,1,3),
(15,'Lucas','Walker','IT','Business Analyst','Abuja',4800,34,7,4),
(16,'Amelia','Hall','Marketing','Brand Manager','Lagos',5300,37,11,5),
(17,'Henry','Allen','HR','HR Assistant','Port Harcourt',2900,23,1,2),
(18,'Mia','Young','Finance','Accountant','Kano',4000,29,4,3),
(19,'Alexander','King','IT','Network Engineer','Abuja',5100,32,6,4),
(20,'Harper','Scott','Sales','Sales Executive','Lagos',3100,28,3,3),
(21,'Ethan','Green','Marketing','SEO Specialist','Kano',3600,27,2,4),
(22,'Abigail','Baker','Finance','Financial Analyst','Lagos',4900,34,8,5),
(23,'Samuel','Adams','IT','Software Engineer','Abuja',6000,31,5,5),
(24,'Ella','Nelson','HR','HR Manager','Lagos',5500,41,13,5),
(25,'Joseph','Carter','Sales','Regional Manager','Kano',6700,45,15,5);