#10355
Identify the number of employees within each department that share the same birth month. Your output should list the department, birth month, and the number of employees from that department who were born in that month. If a month has no employees born in it within a specific department, report this month as having 0 employees.
table name: employee_list
Solution:
with cte as(
select profession,birth_month,employee_id
from employee_list
)
select * from cte
pivot
(count(employee_id) for birth_month in ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) as myPvt
order by profession
Output:
SQL Script:
USE [StrataScratch]
GO
/****** Object: Table [dbo].[employee_list] Script Date: 12-01-2024 15:14:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[employee_list](
[first_name] [varchar](50) NULL,
[last_name] [varchar](50) NULL,
[profession] [varchar](50) NULL,
[employee_id] [int] NULL,
[birthday] [datetime] NULL,
[birth_month] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'John', N'Smith', N'Engineer', 1, CAST(N'1985-02-15T00:00:00.000' AS DateTime), 2)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Sarah', N'Johnson', N'Doctor', 2, CAST(N'1970-11-13T00:00:00.000' AS DateTime), 11)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Miller', N'Teacher', 3, CAST(N'1988-07-08T00:00:00.000' AS DateTime), 7)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Emma', N'Johnson', N'Doctor', 4, CAST(N'1968-08-04T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Paul', N'Johnson', N'Manager', 5, CAST(N'1986-01-14T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Kent', N'Doctor', 6, CAST(N'1969-01-24T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'David', N'Baker', N'Software Dev.', 7, CAST(N'1968-02-24T00:00:00.000' AS DateTime), 2)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Mary', N'White', N'Nurse', 8, CAST(N'1977-06-23T00:00:00.000' AS DateTime), 6)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Grey', N'Lawyer', 9, CAST(N'1989-01-02T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Susan', N'Johnson', N'Engineer', 10, CAST(N'1990-04-06T00:00:00.000' AS DateTime), 4)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Ethan', N'Davis', N'Doctor', 11, CAST(N'1990-08-30T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Emily', N'Clark', N'Teacher', 12, CAST(N'1960-12-26T00:00:00.000' AS DateTime), 12)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Moore', N'Accountant', 13, CAST(N'2000-07-31T00:00:00.000' AS DateTime), 7)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Michael', N'Johnson', N'Manager', 14, CAST(N'1964-08-10T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Taylor', N'Engineer', 15, CAST(N'2001-06-04T00:00:00.000' AS DateTime), 6)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Nancy', N'Johnson', N'Doctor', 16, CAST(N'1964-01-31T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Daniel', N'Thompson', N'Software Dev.', 17, CAST(N'1982-09-21T00:00:00.000' AS DateTime), 9)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Betty', N'Wilson', N'Nurse', 18, CAST(N'1970-10-14T00:00:00.000' AS DateTime), 10)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Jackson', N'Lawyer', 19, CAST(N'1998-12-31T00:00:00.000' AS DateTime), 12)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Martin', N'Engineer', 20, CAST(N'1959-06-01T00:00:00.000' AS DateTime), 6)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Jack', N'Johnson', N'Doctor', 21, CAST(N'1990-11-24T00:00:00.000' AS DateTime), 11)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Helen', N'Walker', N'Teacher', 22, CAST(N'1993-03-15T00:00:00.000' AS DateTime), 3)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Allen', N'Accountant', 23, CAST(N'1977-03-01T00:00:00.000' AS DateTime), 3)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Robert', N'Johnson', N'Manager', 24, CAST(N'1970-09-04T00:00:00.000' AS DateTime), 9)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Hannah', N'Johnson', N'Doctor', 26, CAST(N'1985-07-07T00:00:00.000' AS DateTime), 7)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Hernandez', N'Teacher', 27, CAST(N'1986-10-21T00:00:00.000' AS DateTime), 10)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Joshua', N'King', N'Software Dev.', 28, CAST(N'1998-05-25T00:00:00.000' AS DateTime), 5)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Megan', N'Johnson', N'Manager', 29, CAST(N'1976-03-29T00:00:00.000' AS DateTime), 3)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Wright', N'Engineer', 30, CAST(N'1991-12-09T00:00:00.000' AS DateTime), 12)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Andrew', N'Lopez', N'Doctor', 31, CAST(N'1982-03-13T00:00:00.000' AS DateTime), 3)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Grace', N'Johnson', N'Teacher', 32, CAST(N'1964-09-19T00:00:00.000' AS DateTime), 9)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Hill', N'Accountant', 33, CAST(N'1991-09-30T00:00:00.000' AS DateTime), 9)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Charles', N'Johnson', N'Manager', 34, CAST(N'2000-10-20T00:00:00.000' AS DateTime), 10)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Scott', N'Engineer', 35, CAST(N'1961-06-22T00:00:00.000' AS DateTime), 6)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Elizabeth', N'Johnson', N'Doctor', 36, CAST(N'1982-04-11T00:00:00.000' AS DateTime), 4)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Noah', N'Adams', N'Software Dev.', 37, CAST(N'1980-08-21T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Samantha', N'Johnson', N'Nurse', 38, CAST(N'1968-08-26T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Baker', N'Lawyer', 39, CAST(N'1976-01-11T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'James', N'Johnson', N'Engineer', 40, CAST(N'1966-08-12T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Chloe', N'Rivera', N'Doctor', 41, CAST(N'1979-01-05T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Cooper', N'Teacher', 42, CAST(N'1987-09-19T00:00:00.000' AS DateTime), 9)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Justin', N'Johnson', N'Software Dev.', 43, CAST(N'1989-12-23T00:00:00.000' AS DateTime), 12)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Cox', N'Manager', 44, CAST(N'1981-08-13T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Ava', N'Johnson', N'Engineer', 45, CAST(N'2001-02-24T00:00:00.000' AS DateTime), 2)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Liam', N'Richardson', N'Doctor', 46, CAST(N'1998-05-27T00:00:00.000' AS DateTime), 5)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Howard', N'Teacher', 47, CAST(N'1985-11-08T00:00:00.000' AS DateTime), 11)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Sophia', N'Johnson', N'Software Dev.', 48, CAST(N'1997-06-19T00:00:00.000' AS DateTime), 6)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Torres', N'Manager', 49, CAST(N'1976-09-10T00:00:00.000' AS DateTime), 9)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Ethan', N'Johnson', N'Engineer', 50, CAST(N'1968-05-17T00:00:00.000' AS DateTime), 5)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Emma', N'Johnson', N'Doctor', 51, CAST(N'1988-11-02T00:00:00.000' AS DateTime), 11)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Peterson', N'Teacher', 52, CAST(N'1990-02-26T00:00:00.000' AS DateTime), 2)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Oliver', N'King', N'Software Dev.', 53, CAST(N'1973-05-26T00:00:00.000' AS DateTime), 5)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Ava', N'Johnson', N'Manager', 54, CAST(N'1983-09-04T00:00:00.000' AS DateTime), 9)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Diaz', N'Engineer', 55, CAST(N'2000-05-06T00:00:00.000' AS DateTime), 5)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Noah', N'Lopez', N'Doctor', 56, CAST(N'1961-03-22T00:00:00.000' AS DateTime), 3)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Mia', N'Johnson', N'Teacher', 57, CAST(N'1999-12-10T00:00:00.000' AS DateTime), 12)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Hill', N'Accountant', 58, CAST(N'1996-08-02T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'William', N'Johnson', N'Manager', 59, CAST(N'1986-11-25T00:00:00.000' AS DateTime), 11)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Scott', N'Engineer', 60, CAST(N'1961-09-30T00:00:00.000' AS DateTime), 9)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Emily', N'Johnson', N'Doctor', 61, CAST(N'1987-03-26T00:00:00.000' AS DateTime), 3)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Benjamin', N'Adams', N'Software Dev.', 62, CAST(N'1965-11-23T00:00:00.000' AS DateTime), 11)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Harper', N'Johnson', N'Nurse', 63, CAST(N'1989-03-28T00:00:00.000' AS DateTime), 3)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Perry', N'Lawyer', 64, CAST(N'1980-04-28T00:00:00.000' AS DateTime), 4)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'James', N'Johnson', N'Engineer', 65, CAST(N'1985-08-19T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Evelyn', N'Rivera', N'Doctor', 66, CAST(N'1969-10-29T00:00:00.000' AS DateTime), 10)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Cooper', N'Teacher', 67, CAST(N'1999-02-27T00:00:00.000' AS DateTime), 2)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Lucas', N'Johnson', N'Software Dev.', 68, CAST(N'2000-07-09T00:00:00.000' AS DateTime), 7)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Bryant', N'Manager', 69, CAST(N'1993-03-16T00:00:00.000' AS DateTime), 3)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Charlotte', N'Johnson', N'Engineer', 70, CAST(N'1975-08-26T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Matthew', N'Richardson', N'Doctor', 71, CAST(N'1964-07-03T00:00:00.000' AS DateTime), 7)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Howard', N'Teacher', 72, CAST(N'1988-12-04T00:00:00.000' AS DateTime), 12)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Amelia', N'Johnson', N'Software Dev.', 73, CAST(N'1982-07-05T00:00:00.000' AS DateTime), 7)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Foster', N'Manager', 74, CAST(N'1987-03-20T00:00:00.000' AS DateTime), 3)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Ethan', N'Johnson', N'Engineer', 75, CAST(N'1978-10-20T00:00:00.000' AS DateTime), 10)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Isabella', N'Johnson', N'Doctor', 76, CAST(N'1990-09-12T00:00:00.000' AS DateTime), 9)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Bailey', N'Teacher', 77, CAST(N'1985-10-12T00:00:00.000' AS DateTime), 10)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Jackson', N'Simmons', N'Software Dev.', 78, CAST(N'1986-09-24T00:00:00.000' AS DateTime), 9)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Sofia', N'Johnson', N'Manager', 79, CAST(N'1958-01-09T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Perry', N'Engineer', 80, CAST(N'1970-10-28T00:00:00.000' AS DateTime), 10)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Aiden', N'Reynolds', N'Doctor', 81, CAST(N'1984-08-08T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Abigail', N'Johnson', N'Teacher', 82, CAST(N'1999-12-28T00:00:00.000' AS DateTime), 12)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Mendoza', N'Accountant', 83, CAST(N'2001-06-24T00:00:00.000' AS DateTime), 6)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Lucas', N'Johnson', N'Manager', 84, CAST(N'1970-05-12T00:00:00.000' AS DateTime), 5)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Ruiz', N'Engineer', 85, CAST(N'1980-05-30T00:00:00.000' AS DateTime), 5)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Madison', N'Johnson', N'Doctor', 86, CAST(N'1996-08-15T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Elijah', N'Carter', N'Software Dev.', 87, CAST(N'1972-08-09T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Elizabeth', N'Johnson', N'Nurse', 88, CAST(N'1972-06-25T00:00:00.000' AS DateTime), 6)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Brooks', N'Lawyer', 89, CAST(N'1966-09-28T00:00:00.000' AS DateTime), 9)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Benjamin', N'Johnson', N'Engineer', 90, CAST(N'1992-05-09T00:00:00.000' AS DateTime), 5)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Mia', N'Gibson', N'Doctor', 91, CAST(N'1998-07-20T00:00:00.000' AS DateTime), 7)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Boyd', N'Teacher', 92, CAST(N'1987-05-09T00:00:00.000' AS DateTime), 5)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Noah', N'Johnson', N'Software Dev.', 93, CAST(N'1962-01-24T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Vasquez', N'Manager', 94, CAST(N'2001-05-30T00:00:00.000' AS DateTime), 5)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Harper', N'Johnson', N'Engineer', 95, CAST(N'1992-04-01T00:00:00.000' AS DateTime), 4)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Oliver', N'Freeman', N'Doctor', 96, CAST(N'1965-05-22T00:00:00.000' AS DateTime), 5)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Mullen', N'Teacher', 97, CAST(N'2000-08-28T00:00:00.000' AS DateTime), 8)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Evelyn', N'Johnson', N'Software Dev.', 98, CAST(N'1978-12-31T00:00:00.000' AS DateTime), 12)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Johnson', N'Rodgers', N'Manager', 99, CAST(N'1969-11-25T00:00:00.000' AS DateTime), 11)
GO
INSERT [dbo].[employee_list] ([first_name], [last_name], [profession], [employee_id], [birthday], [birth_month]) VALUES (N'Lucas', N'Johnson', N'Engineer', 100, CAST(N'1961-03-16T00:00:00.000' AS DateTime), 3)
GO