USE [LFLOWTESTDB]
GO

/****** Object:  Table [dbo].[ChartTestTable]    Script Date: 24/09/2021 14:41:59 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChartTestTable]') AND type in (N'U'))
DROP TABLE [dbo].[ChartTestTable]
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChartTestTable]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ChartTestTable](
	[country] [nvarchar](20) NULL,
	[year] [nvarchar](20) NULL,
	[unit] [nvarchar](20) NULL,
	[solar] [int] NULL,
	[hydro] [int] NULL,
	[wind] [int] NULL,
	[nuclear] [int] NULL
) ON [PRIMARY]
END
GO
INSERT INTO ChartTestTable VALUES ('Spain','2008','GWh',2578,26112,32203,58973)
INSERT INTO ChartTestTable VALUES ('Spain','2007','GWh',508,30522,27568,55103)
INSERT INTO ChartTestTable VALUES ('Spain','2006','GWh',119,29831,23297,60126)
INSERT INTO ChartTestTable VALUES ('Spain','2005','GWh',41,23025,21176,57539)
INSERT INTO ChartTestTable VALUES ('Spain','2004','GWh',56,34439,15700,63606)
INSERT INTO ChartTestTable VALUES ('Spain','2003','GWh',41,43897,12075,61875)
INSERT INTO ChartTestTable VALUES ('Spain','2002','GWh',30,26270,9342,63016)
INSERT INTO ChartTestTable VALUES ('Spain','2001','GWh',24,43864,6759,63708)
INSERT INTO ChartTestTable VALUES ('Spain','2000','GWh',18,31807,4727,62206)