Populate sample data - Cats Gender, Weight and Date of Birth

20CatsSample.sql

CREATE TABLE [dbo].[CatDetails](
	[ID] [int] NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[Gender] [nvarchar](50) NOT NULL,
	[Weight] [decimal](3, 1) NULL,
	[DateOfBirth] [date] NULL
)
GO
INSERT [dbo].[CatDetails] ([ID], [Name], [Gender], [Weight], [DateOfBirth])
VALUES
(1, 'Leo', 'Male', 5.1, '2015-06-12'),
(2, 'Max', 'Male', 4.8, '2017-08-18'),
(3, 'Oliver', 'Male', 5.4, '2016-08-28'),
(4, 'Sooty', 'Male', 5.3, '2014-10-23'),
(5, 'George', 'Male', 5.2, '2014-05-16'),
(6, 'Felix', 'Male', 5.3, '2018-08-25'),
(7, 'Alfie', 'Male', 4.9, '2014-08-19'),
(8, 'Jasper', 'Male', 5.1, '2018-07-29'),
(9, 'Tigger', 'Male', 5.0, '2018-09-07'),
(10, 'Sam', 'Male', 5.1, '2016-07-16'),
(11, 'Fluffy', 'Female', 3.9, '2014-03-02'),
(12, 'Bella', 'Female', 4.6, '2015-06-19'),
(13, 'Callie', 'Female', 4.1, '2015-06-26'),
(14, 'Peanut', 'Female', 3.8, '2015-08-08'),
(15, 'Sophie', 'Female', 3.8, '2015-08-04'),
(16, 'Lucy', 'Female', 4.1, '2016-02-25'),
(17, 'Lily', 'Female', 4.3, '2019-06-01'),
(18, 'Mimi', 'Female', 4.6, '2015-08-28'),
(19, 'Snowball', 'Female', 4.6, '2014-04-30'),
(20, 'Patches', 'Female', 4.2, '2012-05-11')