Curious..about data

Script for creating test data for odds ratio

Make sure you have a working version of SQL Server 2016.

USE [master]
GO

/****** Object: Database [WorldHealth] ******/
CREATE DATABASE [WorldHealth]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N’WorldHealth’, FILENAME = N’D:\Microsoft SQL Server\DATA\WorldHealth.mdf’ , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N’WorldHealth_log’, FILENAME = N’D:\Microsoft SQL Server\\WorldHealth_log.ldf’ , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO

CREATE TABLE [dbo].[smokers](
[Smokingstatus] [char](1) NULL,
[AgeRange] [varchar](50) NULL,
[HealthyorSick] [char](1) NULL,
[Numberofpeople] [int] NULL
) ON [PRIMARY]

GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’0′, N’ 1′, N’1′, 20132)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’0′, N’ 2′, N’1′, 21671)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’0′, N’ 3′, N’1′, 19790)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’0′, N’ 4′, N’1′, 16499)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’1′, N’ 1′, N’1′, 39990)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’1′, N’ 2′, N’1′, 32894)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’1′, N’ 3′, N’1′, 20739)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’1′, N’ 4′, N’1′, 11197)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’0′, N’ 1′, N’0′, 204)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’0′, N’ 2′, N’0′, 394)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’0′, N’ 3′, N’0′, 488)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’0′, N’ 4′, N’0′, 766)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’1′, N’ 1′, N’0′, 647)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’1′, N’ 2′, N’1′, 857)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’1′, N’ 3′, N’1′, 855)
GO
INSERT [dbo].[smokers] ([Smokingstatus], [AgeRange], [HealthyorSick], [Numberofpeople]) VALUES (N’1′, N’ 4′, N’0′, 643)
GO

TSQL Tuesday #081 – Sharpening something

SqlTuesday

This TSQL tuesday is hosted by my good friend Jason Brimhall – Jason has put forth a creative challenge – plan to do something, carry out that plan, and then write about the experience. He gave a two week period between planning and implementation. I must confess that i cheated a bit here, because what am writing about is not really a two week thing – but it is an opportunity for me to write on something I recently planned and carried out.
I have about a decade and a half of operational DBA experience as of this year. I was beginning to tire of the relentless repetitive nature of the work, and longed to do something different. I was reading a lot on BI/Analytics – although I have little background in BI – I was fascinated by what was currently possible with many tools available to analyze data and come up with interesting findings. I love painting dashboards, and I have a background in statistics as well. Talking to a few people in the community – it seemed to make sense to find my way into BI/Analytics. But here was was the catch. What was the industry to go into? Analytics is very industry specific – knowledge of data and its nuances being as important as knowledge of technical tools one dabbles with. Some thought and deliberation seemed to point to healthcare analytics as a good choice. So, I had a plan. To find a job that introduces me to the wide world of BI/healthcare analytics, and learn it as much as I can on my own.
After a 3 month search that involved many uncertainities and turning down many lucrative operational dba offers – I found a job where they actually needed a BI DBA – they were willing to let me learn BI if I brought my DBA skills to the table. They were also going into Tableau and analytics. And what is more, they do healthcare.
I took the job and then started working on upping my skills in the said area. I’ve joined a course in healthcare analytics. I use pluralsight to learn SQL Server BI, and udemy for R programming. I also blog once a week on something i learned with R on healthcare data. My blogging interest and following has picked up considerably.
That is in short, my mid life career transition – a rather big subject for a TSQL tuesday, but one that most people run into. I wish you best of luck – with patience and perseverance to find what you truly love to do. Thanks Jason, for the opportunity.

Descriptive Statistics with SQL and R – II

In the previous post I looked into some very basic and common measures of descriptive statistics – mean, median and mode, and how to derive these using T-SQL, R as well as a combo of the two in SQL Server 2016. These measures also called measures of ‘Central Tendency‘. In this post am going to describe some measures called ‘Measures of Dispersion‘. Dispersion refers to how much the said value differs from the average and how many such values are distributed around the average.

Below are 4 very common measures of dispersion –

Range
Inter-Quartile Range
Variance
Standard Deviation

The first and most common measure of dispersion is called ‘Range‘. The range is just the difference between the maximum and minimum values in the dataset. It tells you how much gap there is between the two and therefore how wide the dataset is in terms of its values. It is however, quite misleading when you have outliers in the data. If you have one value that is very large or very small that can skew the Range and does not really mean you have values spanning the minimum to the maximum.

To lower this kind of an issue with outliers – a second variation of the range called Inter-Quartile Range, or IQR is used. The IQR is calculated by dividing the dataset into 4 equal parts after sorting the said value in ascending order. For the first and third part, the maximum values are taken and then subtracted from each other. The IQR ensures that you are looking at top and near-bottom ranges and therefore the value it gives is probably spanning the range.

A more accurate calculation of dispersion is called Variance. Variance is the average of the difference between each value and the mean, divided by the number of values. When your dataset is comprised of an entire population the number of values are the total number of values, but when it is comprised of a sample, the number of values are deducted by 1 to ensure a statistical adjustment. The larger the variance, the more widespread the values are.

The last measure of dispersion am going to look into in this post is Standard Deviation.The Standard Deviation is the square root of the variance. The smaller the standard deviation, the lesser is the dispersion around the mean. The larger, the greater.

The higher the values of variance and standard deviation – the more skewed your data is and the less likely it is to lend itself to any real statistical analysis or even forecasting or predictive reporting.

I used the same data set that I did in the earlier post to run queries for this. Details on that can be found here.

Using T-SQL:

Below are my T-SQL queries to derive range, inter quartile range, variance and standard deviation. I was surprised to find that T-SQL actually has a built in function for variance, which makes it very easy. Was not sure why this particular function would exist when the vast majority of other statistical functions don’t, but makes sense to use it since it does 🙂

–Calculate range of the dataset
SELECT MAX(AGE) – MIN(AGE) as Range FROM [dbo].[WHO_LifeExpectancy]

–Calculate Interquartile range of the dataset
SELECT MAX(QUARTILEMAX) – MIN(QUARTILEMAX) AS INTERQUARTILERANGE
FROM
(SELECT QUARTILE, MAX(AGE) AS QUARTILEMAX FROM (SELECT NTILE(4) OVER ( ORDER BY Age ) AS Quartile ,
Age FROM [dbo].[WHO_LifeExpectancy]) A
GROUP BY QUARTILE HAVING QUARTILE = 1 OR QUARTILE = 3) A

–Calculate variance of the datasest
SELECT VAR(Age) AS VARIANCE FROM [dbo].[WHO_LifeExpectancy]

–Calculate standard deviation of the dataset
SELECT SQRT(VAR(Age)) AS STDDEV FROM [dbo].[WHO_LifeExpectancy]

Results are as below:

descstats2

Using R:

The R script to do the exact same thing is as below. None of these calculations require anything more than calling a packaged function in R, which is why it is usually the preferred way to do it.

#load necessary libraries and connect to the database
install.packages(“RODBC”)
library(RODBC)

cn <- odbcDriverConnect(connection=”Driver={SQL Server Native Client 11.0};server=MALATH-PC\\SQL01;database=WorldHealth;Uid=sa;Pwd=<password>”)
data <- sqlQuery(cn, ‘select age from [dbo].[WHO_LifeExpectancy] where age is not null’)

#Get range
agerange <- max(data)-min(data)
agerange

#Get Interquartile Range
interquartileagerange <- IQR(unlist(data))
interquartileagerange

#Get Variance
variance <- var(data)
variance

#Get Standard Deviation
stddev <- sd(unlist(data))
stddev

The results you get, almost exact matches to what T-SQL gave us:

descstats2-R

3. Using R function calls with T-SQL

Now the last part , where we call the R script via T-SQL. We have to make small changes to the script – the ‘cat’ function to concatenate results, /n to introduce a carriage return for readability and removing the ‘unlist’ that native R needs because of how R structures data it reads directly from SQL . But for this the math is exactly the same.

— calculate simple dispersion measures
EXEC sp_execute_external_script
@language = N’R’
,@script = N’ range <-max(InputDataSet$LifeExpectancies)-min(InputDataSet$LifeExpectancies)
cat(“Range”, range,”\n”);
InterquartileRange <-IQR(InputDataSet$LifeExpectancies)
cat(“InterQuartileRange”, InterquartileRange,”\n”);
variance <-var(InputDataSet$LifeExpectancies)
cat(“Variance”, variance,”\n”);
stdeviation <-sd(InputDataSet$LifeExpectancies)
cat(“StdDeviation”, stdeviation,”\n”);’
,@input_data_1 = N’SELECT LifeExpectancies = Age FROM [WorldHealth].[dbo].[WHO_LifeExpectancy];’
;

And the results, exactly the same as the two above:

descstats2-sqlandr

It has been fun so far doing this in 3 different ways and getting the same results. But as we go into more advanced statistics it will not be that simple. It will, however, definitely help us understand how far we can push statistical math with T-SQL, how easy and simple it is with R, and what can/cannot be done in the first version of calling R from within T-SQL. I can’t wait to play with it further and blog as I go along.

Thank you for reading.

Script to create demo database and load data for statistics and R

Make sure you have a working install of SQL Server 2016. The size of the database is only 8 MB.

USE [master]
GO

/****** Object: Database [WorldHealth] Script Date: 7/15/2016 4:44:58 PM ******/
CREATE DATABASE [WorldHealth]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N’WorldHealth’, FILENAME = N’D:\DATA\WorldHealth.mdf’ , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N’WorldHealth_log’, FILENAME = N’D:\Log\WorldHealth_log.ldf’ , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO

ALTER DATABASE [WorldHealth] SET COMPATIBILITY_LEVEL = 130
GO

USE [WorldHealth]
GO
/****** Object: Table [dbo].[WHO_LifeExpectancy] Script Date: 7/15/2016 4:41:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WHO_LifeExpectancy](
[Country] [varchar](50) NULL,
[Year] [varchar](50) NULL,
[Gender] [varchar](50) NULL,
[Age] [numeric](18, 2) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Afghanistan’, N’2000′, N’Male’, CAST(45.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Albania’, N’2000′, N’Male’, CAST(61.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Algeria’, N’2000′, N’Male’, CAST(61.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Angola’, N’2000′, N’Male’, CAST(38.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Antigua and Barbuda’, N’2000′, N’Male’, CAST(63.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Argentina’, N’2000′, N’Male’, CAST(62.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Armenia’, N’2000′, N’Male’, CAST(61.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Australia’, N’2000′, N’Male’, CAST(67.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Austria’, N’2000′, N’Male’, CAST(66.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Azerbaijan’, N’2000′, N’Male’, CAST(57.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bahamas’, N’2000′, N’Male’, CAST(61.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bahrain’, N’2000′, N’Male’, CAST(64.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bangladesh’, N’2000′, N’Male’, CAST(56.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Barbados’, N’2000′, N’Male’, CAST(63.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belarus’, N’2000′, N’Male’, CAST(57.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belgium’, N’2000′, N’Male’, CAST(65.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belize’, N’2000′, N’Male’, CAST(58.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Benin’, N’2000′, N’Male’, CAST(47.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bhutan’, N’2000′, N’Male’, CAST(53.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bolivia (Plurinational State of)’, N’2000′, N’Male’, CAST(54.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bosnia and Herzegovina’, N’2000′, N’Male’, CAST(62.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Botswana’, N’2000′, N’Male’, CAST(42.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Brazil’, N’2000′, N’Male’, CAST(59.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Brunei Darussalam’, N’2000′, N’Male’, CAST(66.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bulgaria’, N’2000′, N’Male’, CAST(60.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Burkina Faso’, N’2000′, N’Male’, CAST(42.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Burundi’, N’2000′, N’Male’, CAST(41.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cote d”Ivoire’, N’2000′, N’Male’, CAST(41.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cabo Verde’, N’2000′, N’Male’, CAST(60.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cambodia’, N’2000′, N’Male’, CAST(42.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cameroon’, N’2000′, N’Male’, CAST(43.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Canada’, N’2000′, N’Male’, CAST(68.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Central African Republic’, N’2000′, N’Male’, CAST(39.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Chad’, N’2000′, N’Male’, CAST(39.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Chile’, N’2000′, N’Male’, CAST(65.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’China’, N’2000′, N’Male’, CAST(63.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Colombia’, N’2000′, N’Male’, CAST(59.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Comoros’, N’2000′, N’Male’, CAST(50.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Congo’, N’2000′, N’Male’, CAST(45.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Costa Rica’, N’2000′, N’Male’, CAST(66.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Croatia’, N’2000′, N’Male’, CAST(63.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cuba’, N’2000′, N’Male’, CAST(66.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cyprus’, N’2000′, N’Male’, CAST(67.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Czech Republic’, N’2000′, N’Male’, CAST(63.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Democratic People”s Republic of Korea’, N’2000′, N’Male’, CAST(55.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Democratic Republic of the Congo’, N’2000′, N’Male’, CAST(42.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Denmark’, N’2000′, N’Male’, CAST(66.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Djibouti’, N’2000′, N’Male’, CAST(49.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Dominican Republic’, N’2000′, N’Male’, CAST(61.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ecuador’, N’2000′, N’Male’, CAST(61.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Egypt’, N’2000′, N’Male’, CAST(58.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’El Salvador’, N’2000′, N’Male’, CAST(54.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Equatorial Guinea’, N’2000′, N’Male’, CAST(45.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Eritrea’, N’2000′, N’Male’, CAST(34.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Estonia’, N’2000′, N’Male’, CAST(59.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ethiopia’, N’2000′, N’Male’, CAST(42.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Fiji’, N’2000′, N’Male’, CAST(59.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Finland’, N’2000′, N’Male’, CAST(65.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’France’, N’2000′, N’Male’, CAST(67.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Gabon’, N’2000′, N’Male’, CAST(51.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Gambia’, N’2000′, N’Male’, CAST(48.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Georgia’, N’2000′, N’Male’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Germany’, N’2000′, N’Male’, CAST(66.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ghana’, N’2000′, N’Male’, CAST(49.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Greece’, N’2000′, N’Male’, CAST(67.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Grenada’, N’2000′, N’Male’, CAST(60.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guatemala’, N’2000′, N’Male’, CAST(53.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guinea’, N’2000′, N’Male’, CAST(45.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guinea-Bissau’, N’2000′, N’Male’, CAST(44.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guyana’, N’2000′, N’Male’, CAST(55.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Haiti’, N’2000′, N’Male’, CAST(49.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Honduras’, N’2000′, N’Male’, CAST(60.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Hungary’, N’2000′, N’Male’, CAST(60.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iceland’, N’2000′, N’Male’, CAST(69.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’India’, N’2000′, N’Male’, CAST(53.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Indonesia’, N’2000′, N’Male’, CAST(58.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iran (Islamic Republic of)’, N’2000′, N’Male’, CAST(61.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iraq’, N’2000′, N’Male’, CAST(59.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ireland’, N’2000′, N’Male’, CAST(65.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Israel’, N’2000′, N’Male’, CAST(68.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Italy’, N’2000′, N’Male’, CAST(68.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Jamaica’, N’2000′, N’Male’, CAST(62.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Japan’, N’2000′, N’Male’, CAST(70.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Jordan’, N’2000′, N’Male’, CAST(62.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kazakhstan’, N’2000′, N’Male’, CAST(53.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kenya’, N’2000′, N’Male’, CAST(44.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kiribati’, N’2000′, N’Male’, CAST(54.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kuwait’, N’2000′, N’Male’, CAST(63.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kyrgyzstan’, N’2000′, N’Male’, CAST(56.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lao People”s Democratic Republic’, N’2000′, N’Male’, CAST(49.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Latvia’, N’2000′, N’Male’, CAST(58.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lebanon’, N’2000′, N’Male’, CAST(59.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lesotho’, N’2000′, N’Male’, CAST(42.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Liberia’, N’2000′, N’Male’, CAST(43.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Libya’, N’2000′, N’Male’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lithuania’, N’2000′, N’Male’, CAST(59.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Luxembourg’, N’2000′, N’Male’, CAST(66.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Madagascar’, N’2000′, N’Male’, CAST(49.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malawi’, N’2000′, N’Male’, CAST(36.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malaysia’, N’2000′, N’Male’, CAST(62.50 AS Numeric(18, 2)))
GO
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Maldives’, N’2000′, N’Male’, CAST(61.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mali’, N’2000′, N’Male’, CAST(43.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malta’, N’2000′, N’Male’, CAST(67.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mauritania’, N’2000′, N’Male’, CAST(51.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mauritius’, N’2000′, N’Male’, CAST(61.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mexico’, N’2000′, N’Male’, CAST(64.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Micronesia (Federated States of)’, N’2000′, N’Male’, CAST(59.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mongolia’, N’2000′, N’Male’, CAST(54.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Montenegro’, N’2000′, N’Male’, CAST(62.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Morocco’, N’2000′, N’Male’, CAST(59.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mozambique’, N’2000′, N’Male’, CAST(41.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Myanmar’, N’2000′, N’Male’, CAST(53.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Namibia’, N’2000′, N’Male’, CAST(49.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nepal’, N’2000′, N’Male’, CAST(54.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Netherlands’, N’2000′, N’Male’, CAST(67.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’New Zealand’, N’2000′, N’Male’, CAST(67.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nicaragua’, N’2000′, N’Male’, CAST(48.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Niger’, N’2000′, N’Male’, CAST(43.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nigeria’, N’2000′, N’Male’, CAST(40.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Norway’, N’2000′, N’Male’, CAST(67.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Oman’, N’2000′, N’Male’, CAST(62.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Pakistan’, N’2000′, N’Male’, CAST(54.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Panama’, N’2000′, N’Male’, CAST(64.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Papua New Guinea’, N’2000′, N’Male’, CAST(51.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Paraguay’, N’2000′, N’Male’, CAST(61.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Peru’, N’2000′, N’Male’, CAST(57.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Philippines’, N’2000′, N’Male’, CAST(56.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Poland’, N’2000′, N’Male’, CAST(62.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Portugal’, N’2000′, N’Male’, CAST(65.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Qatar’, N’2000′, N’Male’, CAST(64.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Republic of Korea’, N’2000′, N’Male’, CAST(65.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Republic of Moldova’, N’2000′, N’Male’, CAST(57.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Romania’, N’2000′, N’Male’, CAST(60.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Russian Federation’, N’2000′, N’Male’, CAST(53.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Rwanda’, N’2000′, N’Male’, CAST(35.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saint Lucia’, N’2000′, N’Male’, CAST(62.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saint Vincent and the Grenadines’, N’2000′, N’Male’, CAST(61.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Samoa’, N’2000′, N’Male’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sao Tome and Principe’, N’2000′, N’Male’, CAST(53.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saudi Arabia’, N’2000′, N’Male’, CAST(61.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Senegal’, N’2000′, N’Male’, CAST(49.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Serbia’, N’2000′, N’Male’, CAST(62.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Seychelles’, N’2000′, N’Male’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sierra Leone’, N’2000′, N’Male’, CAST(33.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Singapore’, N’2000′, N’Male’, CAST(68.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Slovakia’, N’2000′, N’Male’, CAST(61.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Slovenia’, N’2000′, N’Male’, CAST(63.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Solomon Islands’, N’2000′, N’Male’, CAST(58.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Somalia’, N’2000′, N’Male’, CAST(42.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’South Africa’, N’2000′, N’Male’, CAST(48.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’South Sudan’, N’2000′, N’Male’, CAST(41.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Spain’, N’2000′, N’Male’, CAST(66.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sri Lanka’, N’2000′, N’Male’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sudan’, N’2000′, N’Male’, CAST(49.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Suriname’, N’2000′, N’Male’, CAST(57.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Swaziland’, N’2000′, N’Male’, CAST(41.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sweden’, N’2000′, N’Male’, CAST(68.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Switzerland’, N’2000′, N’Male’, CAST(67.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Syrian Arab Republic’, N’2000′, N’Male’, CAST(60.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tajikistan’, N’2000′, N’Male’, CAST(53.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Thailand’, N’2000′, N’Male’, CAST(61.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Macedonia’, N’2000′, N’Male’, CAST(62.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Timor-Leste’, N’2000′, N’Male’, CAST(50.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Togo’, N’2000′, N’Male’, CAST(47.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tonga’, N’2000′, N’Male’, CAST(63.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Trinidad and Tobago’, N’2000′, N’Male’, CAST(59.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tunisia’, N’2000′, N’Male’, CAST(62.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Turkey’, N’2000′, N’Male’, CAST(59.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Turkmenistan’, N’2000′, N’Male’, CAST(54.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uganda’, N’2000′, N’Male’, CAST(39.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ukraine’, N’2000′, N’Male’, CAST(56.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Arab Emirates’, N’2000′, N’Male’, CAST(64.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Kingdom’, N’2000′, N’Male’, CAST(67.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Republic of Tanzania’, N’2000′, N’Male’, CAST(42.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United States of America’, N’2000′, N’Male’, CAST(65.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uruguay’, N’2000′, N’Male’, CAST(63.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uzbekistan’, N’2000′, N’Male’, CAST(57.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Vanuatu’, N’2000′, N’Male’, CAST(60.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Venezuela’, N’2000′, N’Male’, CAST(60.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Viet Nam’, N’2000′, N’Male’, CAST(59.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Yemen’, N’2000′, N’Male’, CAST(52.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Zambia’, N’2000′, N’Male’, CAST(36.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Zimbabwe’, N’2000′, N’Male’, CAST(39.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Afghanistan’, N’2000′, N’Male’, CAST(45.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Albania’, N’2000′, N’Male’, CAST(61.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Algeria’, N’2000′, N’Male’, CAST(61.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Angola’, N’2000′, N’Male’, CAST(38.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Antigua and Barbuda’, N’2000′, N’Male’, CAST(63.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Argentina’, N’2000′, N’Male’, CAST(62.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Armenia’, N’2000′, N’Male’, CAST(61.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Australia’, N’2000′, N’Male’, CAST(67.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Austria’, N’2000′, N’Male’, CAST(66.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Azerbaijan’, N’2000′, N’Male’, CAST(57.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bahamas’, N’2000′, N’Male’, CAST(61.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bahrain’, N’2000′, N’Male’, CAST(64.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bangladesh’, N’2000′, N’Male’, CAST(56.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Barbados’, N’2000′, N’Male’, CAST(63.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belarus’, N’2000′, N’Male’, CAST(57.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belgium’, N’2000′, N’Male’, CAST(65.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belize’, N’2000′, N’Male’, CAST(58.90 AS Numeric(18, 2)))
GO
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Benin’, N’2000′, N’Male’, CAST(47.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bhutan’, N’2000′, N’Male’, CAST(53.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bolivia (Plurinational State of)’, N’2000′, N’Male’, CAST(54.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bosnia and Herzegovina’, N’2000′, N’Male’, CAST(62.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Botswana’, N’2000′, N’Male’, CAST(42.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Brazil’, N’2000′, N’Male’, CAST(59.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Brunei Darussalam’, N’2000′, N’Male’, CAST(66.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bulgaria’, N’2000′, N’Male’, CAST(60.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Burkina Faso’, N’2000′, N’Male’, CAST(42.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Burundi’, N’2000′, N’Male’, CAST(41.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cote d”Ivoire’, N’2000′, N’Male’, CAST(41.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cabo Verde’, N’2000′, N’Male’, CAST(60.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cambodia’, N’2000′, N’Male’, CAST(42.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cameroon’, N’2000′, N’Male’, CAST(43.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Canada’, N’2000′, N’Male’, CAST(68.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Central African Republic’, N’2000′, N’Male’, CAST(39.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Chad’, N’2000′, N’Male’, CAST(39.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Chile’, N’2000′, N’Male’, CAST(65.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’China’, N’2000′, N’Male’, CAST(63.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Colombia’, N’2000′, N’Male’, CAST(59.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Comoros’, N’2000′, N’Male’, CAST(50.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Congo’, N’2000′, N’Male’, CAST(45.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Costa Rica’, N’2000′, N’Male’, CAST(66.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Croatia’, N’2000′, N’Male’, CAST(63.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cuba’, N’2000′, N’Male’, CAST(66.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cyprus’, N’2000′, N’Male’, CAST(67.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Czech Republic’, N’2000′, N’Male’, CAST(63.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Democratic People”s Republic of Korea’, N’2000′, N’Male’, CAST(55.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Democratic Republic of the Congo’, N’2000′, N’Male’, CAST(42.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Denmark’, N’2000′, N’Male’, CAST(66.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Djibouti’, N’2000′, N’Male’, CAST(49.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Dominican Republic’, N’2000′, N’Male’, CAST(61.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ecuador’, N’2000′, N’Male’, CAST(61.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Egypt’, N’2000′, N’Male’, CAST(58.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’El Salvador’, N’2000′, N’Male’, CAST(54.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Equatorial Guinea’, N’2000′, N’Male’, CAST(45.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Eritrea’, N’2000′, N’Male’, CAST(34.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Estonia’, N’2000′, N’Male’, CAST(59.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ethiopia’, N’2000′, N’Male’, CAST(42.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Fiji’, N’2000′, N’Male’, CAST(59.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Finland’, N’2000′, N’Male’, CAST(65.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’France’, N’2000′, N’Male’, CAST(67.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Gabon’, N’2000′, N’Male’, CAST(51.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Gambia’, N’2000′, N’Male’, CAST(48.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Georgia’, N’2000′, N’Male’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Germany’, N’2000′, N’Male’, CAST(66.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ghana’, N’2000′, N’Male’, CAST(49.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Greece’, N’2000′, N’Male’, CAST(67.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Grenada’, N’2000′, N’Male’, CAST(60.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guatemala’, N’2000′, N’Male’, CAST(53.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guinea’, N’2000′, N’Male’, CAST(45.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guinea-Bissau’, N’2000′, N’Male’, CAST(44.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guyana’, N’2000′, N’Male’, CAST(55.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Haiti’, N’2000′, N’Male’, CAST(49.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Honduras’, N’2000′, N’Male’, CAST(60.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Hungary’, N’2000′, N’Male’, CAST(60.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iceland’, N’2000′, N’Male’, CAST(69.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’India’, N’2000′, N’Male’, CAST(53.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Indonesia’, N’2000′, N’Male’, CAST(58.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iran (Islamic Republic of)’, N’2000′, N’Male’, CAST(61.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iraq’, N’2000′, N’Male’, CAST(59.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ireland’, N’2000′, N’Male’, CAST(65.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Israel’, N’2000′, N’Male’, CAST(68.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Italy’, N’2000′, N’Male’, CAST(68.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Jamaica’, N’2000′, N’Male’, CAST(62.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Japan’, N’2000′, N’Male’, CAST(70.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Jordan’, N’2000′, N’Male’, CAST(62.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kazakhstan’, N’2000′, N’Male’, CAST(53.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kenya’, N’2000′, N’Male’, CAST(44.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kiribati’, N’2000′, N’Male’, CAST(54.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kuwait’, N’2000′, N’Male’, CAST(63.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kyrgyzstan’, N’2000′, N’Male’, CAST(56.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lao People”s Democratic Republic’, N’2000′, N’Male’, CAST(49.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Latvia’, N’2000′, N’Male’, CAST(58.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lebanon’, N’2000′, N’Male’, CAST(59.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lesotho’, N’2000′, N’Male’, CAST(42.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Liberia’, N’2000′, N’Male’, CAST(43.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Libya’, N’2000′, N’Male’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lithuania’, N’2000′, N’Male’, CAST(59.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Luxembourg’, N’2000′, N’Male’, CAST(66.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Madagascar’, N’2000′, N’Male’, CAST(49.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malawi’, N’2000′, N’Male’, CAST(36.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malaysia’, N’2000′, N’Male’, CAST(62.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Maldives’, N’2000′, N’Male’, CAST(61.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mali’, N’2000′, N’Male’, CAST(43.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malta’, N’2000′, N’Male’, CAST(67.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mauritania’, N’2000′, N’Male’, CAST(51.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mauritius’, N’2000′, N’Male’, CAST(61.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mexico’, N’2000′, N’Male’, CAST(64.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Micronesia (Federated States of)’, N’2000′, N’Male’, CAST(59.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mongolia’, N’2000′, N’Male’, CAST(54.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Montenegro’, N’2000′, N’Male’, CAST(62.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Morocco’, N’2000′, N’Male’, CAST(59.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mozambique’, N’2000′, N’Male’, CAST(41.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Myanmar’, N’2000′, N’Male’, CAST(53.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Namibia’, N’2000′, N’Male’, CAST(49.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nepal’, N’2000′, N’Male’, CAST(54.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Netherlands’, N’2000′, N’Male’, CAST(67.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’New Zealand’, N’2000′, N’Male’, CAST(67.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nicaragua’, N’2000′, N’Male’, CAST(48.60 AS Numeric(18, 2)))
GO
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Niger’, N’2000′, N’Male’, CAST(43.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nigeria’, N’2000′, N’Male’, CAST(40.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Norway’, N’2000′, N’Male’, CAST(67.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Oman’, N’2000′, N’Male’, CAST(62.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Pakistan’, N’2000′, N’Male’, CAST(54.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Panama’, N’2000′, N’Male’, CAST(64.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Papua New Guinea’, N’2000′, N’Male’, CAST(51.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Paraguay’, N’2000′, N’Male’, CAST(61.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Peru’, N’2000′, N’Male’, CAST(57.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Philippines’, N’2000′, N’Male’, CAST(56.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Poland’, N’2000′, N’Male’, CAST(62.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Portugal’, N’2000′, N’Male’, CAST(65.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Qatar’, N’2000′, N’Male’, CAST(64.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Republic of Korea’, N’2000′, N’Male’, CAST(65.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Republic of Moldova’, N’2000′, N’Male’, CAST(57.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Romania’, N’2000′, N’Male’, CAST(60.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Russian Federation’, N’2000′, N’Male’, CAST(53.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Rwanda’, N’2000′, N’Male’, CAST(35.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saint Lucia’, N’2000′, N’Male’, CAST(62.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saint Vincent and the Grenadines’, N’2000′, N’Male’, CAST(61.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Samoa’, N’2000′, N’Male’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sao Tome and Principe’, N’2000′, N’Male’, CAST(53.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saudi Arabia’, N’2000′, N’Male’, CAST(61.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Senegal’, N’2000′, N’Male’, CAST(49.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Serbia’, N’2000′, N’Male’, CAST(62.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Seychelles’, N’2000′, N’Male’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sierra Leone’, N’2000′, N’Male’, CAST(33.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Singapore’, N’2000′, N’Male’, CAST(68.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Slovakia’, N’2000′, N’Male’, CAST(61.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Slovenia’, N’2000′, N’Male’, CAST(63.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Solomon Islands’, N’2000′, N’Male’, CAST(58.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Somalia’, N’2000′, N’Male’, CAST(42.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’South Africa’, N’2000′, N’Male’, CAST(48.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’South Sudan’, N’2000′, N’Male’, CAST(41.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Spain’, N’2000′, N’Male’, CAST(66.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sri Lanka’, N’2000′, N’Male’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sudan’, N’2000′, N’Male’, CAST(49.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Suriname’, N’2000′, N’Male’, CAST(57.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Swaziland’, N’2000′, N’Male’, CAST(41.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sweden’, N’2000′, N’Male’, CAST(68.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Switzerland’, N’2000′, N’Male’, CAST(67.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Syrian Arab Republic’, N’2000′, N’Male’, CAST(60.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tajikistan’, N’2000′, N’Male’, CAST(53.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Thailand’, N’2000′, N’Male’, CAST(61.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Macedonia’, N’2000′, N’Male’, CAST(62.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Timor-Leste’, N’2000′, N’Male’, CAST(50.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Togo’, N’2000′, N’Male’, CAST(47.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tonga’, N’2000′, N’Male’, CAST(63.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Trinidad and Tobago’, N’2000′, N’Male’, CAST(59.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tunisia’, N’2000′, N’Male’, CAST(62.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Turkey’, N’2000′, N’Male’, CAST(59.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Turkmenistan’, N’2000′, N’Male’, CAST(54.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uganda’, N’2000′, N’Male’, CAST(39.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ukraine’, N’2000′, N’Male’, CAST(56.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Arab Emirates’, N’2000′, N’Male’, CAST(64.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Kingdom’, N’2000′, N’Male’, CAST(67.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Republic of Tanzania’, N’2000′, N’Male’, CAST(42.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United States of America’, N’2000′, N’Male’, CAST(65.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uruguay’, N’2000′, N’Male’, CAST(63.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uzbekistan’, N’2000′, N’Male’, CAST(57.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Vanuatu’, N’2000′, N’Male’, CAST(60.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Venezuela’, N’2000′, N’Male’, CAST(60.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Viet Nam’, N’2000′, N’Male’, CAST(59.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Yemen’, N’2000′, N’Male’, CAST(52.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Zambia’, N’2000′, N’Male’, CAST(36.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Zimbabwe’, N’2000′, N’Male’, CAST(39.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Afghanistan’, N’2015′, N’Female’, CAST(53.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Albania’, N’2015′, N’Female’, CAST(71.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Algeria’, N’2015′, N’Female’, CAST(67.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Angola’, N’2015′, N’Female’, CAST(47.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Antigua and Barbuda’, N’2015′, N’Female’, CAST(68.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Argentina’, N’2015′, N’Female’, CAST(70.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Armenia’, N’2015′, N’Female’, CAST(68.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Australia’, N’2015′, N’Female’, CAST(72.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Austria’, N’2015′, N’Female’, CAST(73.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Azerbaijan’, N’2015′, N’Female’, CAST(66.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bahamas’, N’2015′, N’Female’, CAST(68.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bahrain’, N’2015′, N’Female’, CAST(67.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bangladesh’, N’2015′, N’Female’, CAST(62.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Barbados’, N’2015′, N’Female’, CAST(68.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belarus’, N’2015′, N’Female’, CAST(69.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belgium’, N’2015′, N’Female’, CAST(72.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belize’, N’2015′, N’Female’, CAST(63.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Benin’, N’2015′, N’Female’, CAST(52.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bhutan’, N’2015′, N’Female’, CAST(61.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bolivia (Plurinational State of)’, N’2015′, N’Female’, CAST(64.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bosnia and Herzegovina’, N’2015′, N’Female’, CAST(70.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Botswana’, N’2015′, N’Female’, CAST(58.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Brazil’, N’2015′, N’Female’, CAST(67.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Brunei Darussalam’, N’2015′, N’Female’, CAST(71.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bulgaria’, N’2015′, N’Female’, CAST(69.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Burkina Faso’, N’2015′, N’Female’, CAST(52.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Burundi’, N’2015′, N’Female’, CAST(53.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cote d”Ivoire’, N’2015′, N’Female’, CAST(47.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cabo Verde’, N’2015′, N’Female’, CAST(65.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cambodia’, N’2015′, N’Female’, CAST(60.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cameroon’, N’2015′, N’Female’, CAST(51.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Canada’, N’2015′, N’Female’, CAST(73.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Central African Republic’, N’2015′, N’Female’, CAST(47.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Chad’, N’2015′, N’Female’, CAST(47.10 AS Numeric(18, 2)))
GO
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Chile’, N’2015′, N’Female’, CAST(72.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’China’, N’2015′, N’Female’, CAST(69.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Colombia’, N’2015′, N’Female’, CAST(67.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Comoros’, N’2015′, N’Female’, CAST(57.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Congo’, N’2015′, N’Female’, CAST(57.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Costa Rica’, N’2015′, N’Female’, CAST(71.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Croatia’, N’2015′, N’Female’, CAST(71.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cuba’, N’2015′, N’Female’, CAST(70.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cyprus’, N’2015′, N’Female’, CAST(72.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Czech Republic’, N’2015′, N’Female’, CAST(71.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Democratic People”s Republic of Korea’, N’2015′, N’Female’, CAST(66.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Democratic Republic of the Congo’, N’2015′, N’Female’, CAST(53.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Denmark’, N’2015′, N’Female’, CAST(72.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Djibouti’, N’2015′, N’Female’, CAST(57.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Dominican Republic’, N’2015′, N’Female’, CAST(67.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ecuador’, N’2015′, N’Female’, CAST(68.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Egypt’, N’2015′, N’Female’, CAST(63.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’El Salvador’, N’2015′, N’Female’, CAST(67.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Equatorial Guinea’, N’2015′, N’Female’, CAST(52.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Eritrea’, N’2015′, N’Female’, CAST(57.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Estonia’, N’2015′, N’Female’, CAST(72.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ethiopia’, N’2015′, N’Female’, CAST(57.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Fiji’, N’2015′, N’Female’, CAST(65.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Finland’, N’2015′, N’Female’, CAST(72.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’France’, N’2015′, N’Female’, CAST(74.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Gabon’, N’2015′, N’Female’, CAST(58.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Gambia’, N’2015′, N’Female’, CAST(54.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Georgia’, N’2015′, N’Female’, CAST(69.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Germany’, N’2015′, N’Female’, CAST(72.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ghana’, N’2015′, N’Female’, CAST(56.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Greece’, N’2015′, N’Female’, CAST(73.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Grenada’, N’2015′, N’Female’, CAST(66.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guatemala’, N’2015′, N’Female’, CAST(64.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guinea’, N’2015′, N’Female’, CAST(51.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guinea-Bissau’, N’2015′, N’Female’, CAST(52.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guyana’, N’2015′, N’Female’, CAST(60.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Haiti’, N’2015′, N’Female’, CAST(56.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Honduras’, N’2015′, N’Female’, CAST(66.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Hungary’, N’2015′, N’Female’, CAST(69.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iceland’, N’2015′, N’Female’, CAST(73.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’India’, N’2015′, N’Female’, CAST(60.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Indonesia’, N’2015′, N’Female’, CAST(63.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iran (Islamic Republic of)’, N’2015′, N’Female’, CAST(66.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iraq’, N’2015′, N’Female’, CAST(62.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ireland’, N’2015′, N’Female’, CAST(72.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Israel’, N’2015′, N’Female’, CAST(73.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Italy’, N’2015′, N’Female’, CAST(73.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Jamaica’, N’2015′, N’Female’, CAST(68.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Japan’, N’2015′, N’Female’, CAST(77.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Jordan’, N’2015′, N’Female’, CAST(65.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kazakhstan’, N’2015′, N’Female’, CAST(66.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kenya’, N’2015′, N’Female’, CAST(57.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kiribati’, N’2015′, N’Female’, CAST(60.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kuwait’, N’2015′, N’Female’, CAST(66.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kyrgyzstan’, N’2015′, N’Female’, CAST(66.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lao People”s Democratic Republic’, N’2015′, N’Female’, CAST(59.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Latvia’, N’2015′, N’Female’, CAST(70.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lebanon’, N’2015′, N’Female’, CAST(66.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lesotho’, N’2015′, N’Female’, CAST(47.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Liberia’, N’2015′, N’Female’, CAST(53.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Libya’, N’2015′, N’Female’, CAST(65.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lithuania’, N’2015′, N’Female’, CAST(70.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Luxembourg’, N’2015′, N’Female’, CAST(73.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Madagascar’, N’2015′, N’Female’, CAST(58.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malawi’, N’2015′, N’Female’, CAST(52.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malaysia’, N’2015′, N’Female’, CAST(68.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Maldives’, N’2015′, N’Female’, CAST(70.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mali’, N’2015′, N’Female’, CAST(50.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malta’, N’2015′, N’Female’, CAST(72.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mauritania’, N’2015′, N’Female’, CAST(55.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mauritius’, N’2015′, N’Female’, CAST(69.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mexico’, N’2015′, N’Female’, CAST(69.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Micronesia (Federated States of)’, N’2015′, N’Female’, CAST(63.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mongolia’, N’2015′, N’Female’, CAST(65.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Montenegro’, N’2015′, N’Female’, CAST(69.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Morocco’, N’2015′, N’Female’, CAST(65.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mozambique’, N’2015′, N’Female’, CAST(50.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Myanmar’, N’2015′, N’Female’, CAST(60.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Namibia’, N’2015′, N’Female’, CAST(59.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nepal’, N’2015′, N’Female’, CAST(62.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Netherlands’, N’2015′, N’Female’, CAST(73.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’New Zealand’, N’2015′, N’Female’, CAST(72.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nicaragua’, N’2015′, N’Female’, CAST(67.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Niger’, N’2015′, N’Female’, CAST(54.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nigeria’, N’2015′, N’Female’, CAST(48.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Norway’, N’2015′, N’Female’, CAST(73.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Oman’, N’2015′, N’Female’, CAST(67.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Pakistan’, N’2015′, N’Female’, CAST(58.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Panama’, N’2015′, N’Female’, CAST(70.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Papua New Guinea’, N’2015′, N’Female’, CAST(58.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Paraguay’, N’2015′, N’Female’, CAST(66.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Peru’, N’2015′, N’Female’, CAST(67.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Philippines’, N’2015′, N’Female’, CAST(63.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Poland’, N’2015′, N’Female’, CAST(71.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Portugal’, N’2015′, N’Female’, CAST(73.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Qatar’, N’2015′, N’Female’, CAST(68.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Republic of Korea’, N’2015′, N’Female’, CAST(75.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Republic of Moldova’, N’2015′, N’Female’, CAST(67.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Romania’, N’2015′, N’Female’, CAST(69.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Russian Federation’, N’2015′, N’Female’, CAST(67.80 AS Numeric(18, 2)))
GO
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Rwanda’, N’2015′, N’Female’, CAST(60.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saint Lucia’, N’2015′, N’Female’, CAST(67.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saint Vincent and the Grenadines’, N’2015′, N’Female’, CAST(65.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Samoa’, N’2015′, N’Female’, CAST(69.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sao Tome and Principe’, N’2015′, N’Female’, CAST(60.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saudi Arabia’, N’2015′, N’Female’, CAST(64.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Senegal’, N’2015′, N’Female’, CAST(59.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Serbia’, N’2015′, N’Female’, CAST(69.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Seychelles’, N’2015′, N’Female’, CAST(69.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sierra Leone’, N’2015′, N’Female’, CAST(44.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Singapore’, N’2015′, N’Female’, CAST(75.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Slovakia’, N’2015′, N’Female’, CAST(70.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Slovenia’, N’2015′, N’Female’, CAST(73.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Solomon Islands’, N’2015′, N’Female’, CAST(62.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Somalia’, N’2015′, N’Female’, CAST(48.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’South Africa’, N’2015′, N’Female’, CAST(56.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’South Sudan’, N’2015′, N’Female’, CAST(50.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Spain’, N’2015′, N’Female’, CAST(74.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sri Lanka’, N’2015′, N’Female’, CAST(69.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sudan’, N’2015′, N’Female’, CAST(56.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Suriname’, N’2015′, N’Female’, CAST(64.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Swaziland’, N’2015′, N’Female’, CAST(52.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sweden’, N’2015′, N’Female’, CAST(73.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Switzerland’, N’2015′, N’Female’, CAST(74.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Syrian Arab Republic’, N’2015′, N’Female’, CAST(59.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tajikistan’, N’2015′, N’Female’, CAST(65.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Thailand’, N’2015′, N’Female’, CAST(68.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Macedonia’, N’2015′, N’Female’, CAST(69.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Timor-Leste’, N’2015′, N’Female’, CAST(62.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Togo’, N’2015′, N’Female’, CAST(53.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tonga’, N’2015′, N’Female’, CAST(67.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Trinidad and Tobago’, N’2015′, N’Female’, CAST(65.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tunisia’, N’2015′, N’Female’, CAST(68.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Turkey’, N’2015′, N’Female’, CAST(67.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Turkmenistan’, N’2015′, N’Female’, CAST(63.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uganda’, N’2015′, N’Female’, CAST(55.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ukraine’, N’2015′, N’Female’, CAST(67.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Arab Emirates’, N’2015′, N’Female’, CAST(68.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Kingdom ‘, N’2015′, N’Female’, CAST(72.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Republic of Tanzania’, N’2015′, N’Female’, CAST(55.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United States of America’, N’2015′, N’Female’, CAST(70.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uruguay’, N’2015′, N’Female’, CAST(70.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uzbekistan’, N’2015′, N’Female’, CAST(65.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Vanuatu’, N’2015′, N’Female’, CAST(66.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Venezuela’, N’2015′, N’Female’, CAST(68.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Viet Nam’, N’2015′, N’Female’, CAST(69.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Yemen’, N’2015′, N’Female’, CAST(58.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Zambia’, N’2015′, N’Female’, CAST(55.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Zimbabwe’, N’2015′, N’Female’, CAST(53.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Afghanistan’, N’2000′, N’Female’, CAST(48.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Albania’, N’2000′, N’Female’, CAST(66.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Algeria’, N’2000′, N’Female’, CAST(63.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Angola’, N’2000′, N’Female’, CAST(40.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Antigua and Barbuda’, N’2000′, N’Female’, CAST(66.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Argentina’, N’2000′, N’Female’, CAST(67.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Armenia’, N’2000′, N’Female’, CAST(66.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Australia’, N’2000′, N’Female’, CAST(71.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Austria’, N’2000′, N’Female’, CAST(70.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Azerbaijan’, N’2000′, N’Female’, CAST(61.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bahamas’, N’2000′, N’Female’, CAST(65.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bahrain’, N’2000′, N’Female’, CAST(65.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bangladesh’, N’2000′, N’Female’, CAST(56.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Barbados’, N’2000′, N’Female’, CAST(66.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belarus’, N’2000′, N’Female’, CAST(65.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belgium’, N’2000′, N’Female’, CAST(70.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belize’, N’2000′, N’Female’, CAST(62.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Benin’, N’2000′, N’Female’, CAST(48.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bhutan’, N’2000′, N’Female’, CAST(52.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bolivia (Plurinational State of)’, N’2000′, N’Female’, CAST(56.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bosnia and Herzegovina’, N’2000′, N’Female’, CAST(67.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Botswana’, N’2000′, N’Female’, CAST(41.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Brazil’, N’2000′, N’Female’, CAST(64.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Brunei Darussalam’, N’2000′, N’Female’, CAST(68.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bulgaria’, N’2000′, N’Female’, CAST(66.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Burkina Faso’, N’2000′, N’Female’, CAST(44.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Burundi’, N’2000′, N’Female’, CAST(45.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cote d”Ivoire’, N’2000′, N’Female’, CAST(42.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cabo Verde’, N’2000′, N’Female’, CAST(61.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cambodia’, N’2000′, N’Female’, CAST(48.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cameroon’, N’2000′, N’Female’, CAST(45.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Canada’, N’2000′, N’Female’, CAST(71.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Central African Republic’, N’2000′, N’Female’, CAST(40.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Chad’, N’2000′, N’Female’, CAST(42.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Chile’, N’2000′, N’Female’, CAST(69.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’China’, N’2000′, N’Female’, CAST(65.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Colombia’, N’2000′, N’Female’, CAST(65.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Comoros’, N’2000′, N’Female’, CAST(53.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Congo’, N’2000′, N’Female’, CAST(46.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Costa Rica’, N’2000′, N’Female’, CAST(69.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Croatia’, N’2000′, N’Female’, CAST(69.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cuba’, N’2000′, N’Female’, CAST(68.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cyprus’, N’2000′, N’Female’, CAST(70.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Czech Republic’, N’2000′, N’Female’, CAST(68.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Democratic People”s Republic of Korea’, N’2000′, N’Female’, CAST(61.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Democratic Republic of the Congo’, N’2000′, N’Female’, CAST(45.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Denmark’, N’2000′, N’Female’, CAST(69.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Djibouti’, N’2000′, N’Female’, CAST(51.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Dominican Republic’, N’2000′, N’Female’, CAST(64.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ecuador’, N’2000′, N’Female’, CAST(65.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Egypt’, N’2000′, N’Female’, CAST(61.10 AS Numeric(18, 2)))
GO
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’El Salvador’, N’2000′, N’Female’, CAST(63.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Equatorial Guinea’, N’2000′, N’Female’, CAST(47.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Eritrea’, N’2000′, N’Female’, CAST(44.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Estonia’, N’2000′, N’Female’, CAST(67.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ethiopia’, N’2000′, N’Female’, CAST(46.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Fiji’, N’2000′, N’Female’, CAST(62.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Finland’, N’2000′, N’Female’, CAST(70.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’France’, N’2000′, N’Female’, CAST(72.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Gabon’, N’2000′, N’Female’, CAST(52.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Gambia’, N’2000′, N’Female’, CAST(49.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Georgia’, N’2000′, N’Female’, CAST(66.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Germany’, N’2000′, N’Female’, CAST(70.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ghana’, N’2000′, N’Female’, CAST(51.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Greece’, N’2000′, N’Female’, CAST(71.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Grenada’, N’2000′, N’Female’, CAST(63.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guatemala’, N’2000′, N’Female’, CAST(60.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guinea’, N’2000′, N’Female’, CAST(46.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guinea-Bissau’, N’2000′, N’Female’, CAST(46.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guyana’, N’2000′, N’Female’, CAST(59.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Haiti’, N’2000′, N’Female’, CAST(52.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Honduras’, N’2000′, N’Female’, CAST(62.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Hungary’, N’2000′, N’Female’, CAST(66.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iceland’, N’2000′, N’Female’, CAST(71.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’India’, N’2000′, N’Female’, CAST(54.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Indonesia’, N’2000′, N’Female’, CAST(60.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iran (Islamic Republic of)’, N’2000′, N’Female’, CAST(62.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iraq’, N’2000′, N’Female’, CAST(62.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ireland’, N’2000′, N’Female’, CAST(69.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Israel’, N’2000′, N’Female’, CAST(70.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Italy’, N’2000′, N’Female’, CAST(71.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Jamaica’, N’2000′, N’Female’, CAST(65.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Japan’, N’2000′, N’Female’, CAST(75.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Jordan’, N’2000′, N’Female’, CAST(63.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kazakhstan’, N’2000′, N’Female’, CAST(62.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kenya’, N’2000′, N’Female’, CAST(46.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kiribati’, N’2000′, N’Female’, CAST(58.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kuwait’, N’2000′, N’Female’, CAST(65.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kyrgyzstan’, N’2000′, N’Female’, CAST(63.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lao People”s Democratic Republic’, N’2000′, N’Female’, CAST(52.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Latvia’, N’2000′, N’Female’, CAST(67.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lebanon’, N’2000′, N’Female’, CAST(62.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lesotho’, N’2000′, N’Female’, CAST(43.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Liberia’, N’2000′, N’Female’, CAST(44.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Libya’, N’2000′, N’Female’, CAST(63.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lithuania’, N’2000′, N’Female’, CAST(68.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Luxembourg’, N’2000′, N’Female’, CAST(70.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Madagascar’, N’2000′, N’Female’, CAST(51.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malawi’, N’2000′, N’Female’, CAST(37.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malaysia’, N’2000′, N’Female’, CAST(66.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Maldives’, N’2000′, N’Female’, CAST(62.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mali’, N’2000′, N’Female’, CAST(43.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malta’, N’2000′, N’Female’, CAST(69.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mauritania’, N’2000′, N’Female’, CAST(52.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mauritius’, N’2000′, N’Female’, CAST(66.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mexico’, N’2000′, N’Female’, CAST(67.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Micronesia (Federated States of)’, N’2000′, N’Female’, CAST(60.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mongolia’, N’2000′, N’Female’, CAST(59.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Montenegro’, N’2000′, N’Female’, CAST(66.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Morocco’, N’2000′, N’Female’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mozambique’, N’2000′, N’Female’, CAST(43.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Myanmar’, N’2000′, N’Female’, CAST(56.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Namibia’, N’2000′, N’Female’, CAST(50.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nepal’, N’2000′, N’Female’, CAST(55.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Netherlands’, N’2000′, N’Female’, CAST(70.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’New Zealand’, N’2000′, N’Female’, CAST(70.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nicaragua’, N’2000′, N’Female’, CAST(60.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Niger’, N’2000′, N’Female’, CAST(43.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nigeria’, N’2000′, N’Female’, CAST(41.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Norway’, N’2000′, N’Female’, CAST(71.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Oman’, N’2000′, N’Female’, CAST(64.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Pakistan’, N’2000′, N’Female’, CAST(54.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Panama’, N’2000′, N’Female’, CAST(68.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Papua New Guinea’, N’2000′, N’Female’, CAST(54.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Paraguay’, N’2000′, N’Female’, CAST(63.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Peru’, N’2000′, N’Female’, CAST(62.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Philippines’, N’2000′, N’Female’, CAST(61.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Poland’, N’2000′, N’Female’, CAST(68.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Portugal’, N’2000′, N’Female’, CAST(70.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Qatar’, N’2000′, N’Female’, CAST(66.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Republic of Korea’, N’2000′, N’Female’, CAST(70.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Republic of Moldova’, N’2000′, N’Female’, CAST(63.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Romania’, N’2000′, N’Female’, CAST(66.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Russian Federation’, N’2000′, N’Female’, CAST(63.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Rwanda’, N’2000′, N’Female’, CAST(44.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saint Lucia’, N’2000′, N’Female’, CAST(64.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saint Vincent and the Grenadines’, N’2000′, N’Female’, CAST(63.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Samoa’, N’2000′, N’Female’, CAST(66.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sao Tome and Principe’, N’2000′, N’Female’, CAST(56.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saudi Arabia’, N’2000′, N’Female’, CAST(64.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Senegal’, N’2000′, N’Female’, CAST(51.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Serbia’, N’2000′, N’Female’, CAST(66.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Seychelles’, N’2000′, N’Female’, CAST(68.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sierra Leone’, N’2000′, N’Female’, CAST(34.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Singapore’, N’2000′, N’Female’, CAST(71.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Slovakia’, N’2000′, N’Female’, CAST(68.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Slovenia’, N’2000′, N’Female’, CAST(69.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Solomon Islands’, N’2000′, N’Female’, CAST(59.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Somalia’, N’2000′, N’Female’, CAST(44.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’South Africa’, N’2000′, N’Female’, CAST(52.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’South Sudan’, N’2000′, N’Female’, CAST(43.20 AS Numeric(18, 2)))
GO
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Spain’, N’2000′, N’Female’, CAST(71.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sri Lanka’, N’2000′, N’Female’, CAST(66.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sudan’, N’2000′, N’Female’, CAST(52.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Suriname’, N’2000′, N’Female’, CAST(61.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Swaziland’, N’2000′, N’Female’, CAST(42.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sweden’, N’2000′, N’Female’, CAST(71.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Switzerland’, N’2000′, N’Female’, CAST(71.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Syrian Arab Republic’, N’2000′, N’Female’, CAST(63.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tajikistan’, N’2000′, N’Female’, CAST(59.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Thailand’, N’2000′, N’Female’, CAST(65.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Macedonia’, N’2000′, N’Female’, CAST(66.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Timor-Leste’, N’2000′, N’Female’, CAST(53.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Togo’, N’2000′, N’Female’, CAST(48.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tonga’, N’2000′, N’Female’, CAST(65.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Trinidad and Tobago’, N’2000′, N’Female’, CAST(64.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tunisia’, N’2000′, N’Female’, CAST(66.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Turkey’, N’2000′, N’Female’, CAST(63.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Turkmenistan’, N’2000′, N’Female’, CAST(60.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uganda’, N’2000′, N’Female’, CAST(40.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ukraine’, N’2000′, N’Female’, CAST(65.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Arab Emirates’, N’2000′, N’Female’, CAST(66.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Kingdom’, N’2000′, N’Female’, CAST(70.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Republic of Tanzania’, N’2000′, N’Female’, CAST(43.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United States of America’, N’2000′, N’Female’, CAST(68.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uruguay’, N’2000′, N’Female’, CAST(68.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uzbekistan’, N’2000′, N’Female’, CAST(62.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Vanuatu’, N’2000′, N’Female’, CAST(63.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Venezuela’, N’2000′, N’Female’, CAST(67.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Viet Nam’, N’2000′, N’Female’, CAST(65.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Yemen’, N’2000′, N’Female’, CAST(53.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Zambia’, N’2000′, N’Female’, CAST(39.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Zimbabwe’, N’2000′, N’Female’, CAST(39.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Afghanistan’, N’2015′, N’Male’, CAST(51.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Albania’, N’2015′, N’Male’, CAST(66.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Algeria’, N’2015′, N’Male’, CAST(65.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Angola’, N’2015′, N’Male’, CAST(44.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Antigua and Barbuda’, N’2015′, N’Male’, CAST(66.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Argentina’, N’2015′, N’Male’, CAST(65.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Armenia’, N’2015′, N’Male’, CAST(64.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Australia’, N’2015′, N’Male’, CAST(70.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Austria’, N’2015′, N’Male’, CAST(70.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Azerbaijan’, N’2015′, N’Male’, CAST(62.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bahamas’, N’2015′, N’Male’, CAST(64.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bahrain’, N’2015′, N’Male’, CAST(66.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bangladesh’, N’2015′, N’Male’, CAST(61.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Barbados’, N’2015′, N’Male’, CAST(65.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belarus’, N’2015′, N’Male’, CAST(60.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belgium’, N’2015′, N’Male’, CAST(69.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Belize’, N’2015′, N’Male’, CAST(60.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Benin’, N’2015′, N’Male’, CAST(52.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bhutan’, N’2015′, N’Male’, CAST(61.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bolivia (Plurinational State of)’, N’2015′, N’Male’, CAST(61.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bosnia and Herzegovina’, N’2015′, N’Male’, CAST(66.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Botswana’, N’2015′, N’Male’, CAST(55.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Brazil’, N’2015′, N’Male’, CAST(63.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Brunei Darussalam’, N’2015′, N’Male’, CAST(69.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Bulgaria’, N’2015′, N’Male’, CAST(63.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Burkina Faso’, N’2015′, N’Male’, CAST(52.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Burundi’, N’2015′, N’Male’, CAST(50.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cote d”Ivoire’, N’2015′, N’Male’, CAST(46.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cabo Verde’, N’2015′, N’Male’, CAST(63.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cambodia’, N’2015′, N’Male’, CAST(55.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cameroon’, N’2015′, N’Male’, CAST(49.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Canada’, N’2015′, N’Male’, CAST(71.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Central African Republic’, N’2015′, N’Male’, CAST(44.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Chad’, N’2015′, N’Male’, CAST(45.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Chile’, N’2015′, N’Male’, CAST(68.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’China’, N’2015′, N’Male’, CAST(67.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Colombia’, N’2015′, N’Male’, CAST(62.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Comoros’, N’2015′, N’Male’, CAST(54.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Congo’, N’2015′, N’Male’, CAST(55.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Costa Rica’, N’2015′, N’Male’, CAST(68.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Croatia’, N’2015′, N’Male’, CAST(67.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cuba’, N’2015′, N’Male’, CAST(68.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Cyprus’, N’2015′, N’Male’, CAST(70.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Czech Republic’, N’2015′, N’Male’, CAST(67.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Democratic People”s Republic of Korea’, N’2015′, N’Male’, CAST(61.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Democratic Republic of the Congo’, N’2015′, N’Male’, CAST(50.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Denmark’, N’2015′, N’Male’, CAST(70.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Djibouti’, N’2015′, N’Male’, CAST(54.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Dominican Republic’, N’2015′, N’Male’, CAST(63.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ecuador’, N’2015′, N’Male’, CAST(65.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Egypt’, N’2015′, N’Male’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’El Salvador’, N’2015′, N’Male’, CAST(60.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Equatorial Guinea’, N’2015′, N’Male’, CAST(50.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Eritrea’, N’2015′, N’Male’, CAST(54.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Estonia’, N’2015′, N’Male’, CAST(65.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ethiopia’, N’2015′, N’Male’, CAST(54.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Fiji’, N’2015′, N’Male’, CAST(60.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Finland’, N’2015′, N’Male’, CAST(69.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’France’, N’2015′, N’Male’, CAST(70.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Gabon’, N’2015′, N’Male’, CAST(56.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Gambia’, N’2015′, N’Male’, CAST(53.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Georgia’, N’2015′, N’Male’, CAST(63.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Germany’, N’2015′, N’Male’, CAST(69.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ghana’, N’2015′, N’Male’, CAST(54.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Greece’, N’2015′, N’Male’, CAST(70.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Grenada’, N’2015′, N’Male’, CAST(63.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guatemala’, N’2015′, N’Male’, CAST(59.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guinea’, N’2015′, N’Male’, CAST(51.50 AS Numeric(18, 2)))
GO
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guinea-Bissau’, N’2015′, N’Male’, CAST(50.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Guyana’, N’2015′, N’Male’, CAST(57.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Haiti’, N’2015′, N’Male’, CAST(54.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Honduras’, N’2015′, N’Male’, CAST(63.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Hungary’, N’2015′, N’Male’, CAST(64.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iceland’, N’2015′, N’Male’, CAST(71.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’India’, N’2015′, N’Male’, CAST(58.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Indonesia’, N’2015′, N’Male’, CAST(60.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iran (Islamic Republic of)’, N’2015′, N’Male’, CAST(66.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Iraq’, N’2015′, N’Male’, CAST(58.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ireland’, N’2015′, N’Male’, CAST(70.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Israel’, N’2015′, N’Male’, CAST(71.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Italy’, N’2015′, N’Male’, CAST(71.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Jamaica’, N’2015′, N’Male’, CAST(65.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Japan’, N’2015′, N’Male’, CAST(72.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Jordan’, N’2015′, N’Male’, CAST(64.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kazakhstan’, N’2015′, N’Male’, CAST(59.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kenya’, N’2015′, N’Male’, CAST(53.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kiribati’, N’2015′, N’Male’, CAST(56.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kuwait’, N’2015′, N’Male’, CAST(65.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Kyrgyzstan’, N’2015′, N’Male’, CAST(61.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lao People”s Democratic Republic’, N’2015′, N’Male’, CAST(56.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Latvia’, N’2015′, N’Male’, CAST(63.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lebanon’, N’2015′, N’Male’, CAST(64.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lesotho’, N’2015′, N’Male’, CAST(45.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Liberia’, N’2015′, N’Male’, CAST(51.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Libya’, N’2015′, N’Male’, CAST(62.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Lithuania’, N’2015′, N’Male’, CAST(62.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Luxembourg’, N’2015′, N’Male’, CAST(70.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Madagascar’, N’2015′, N’Male’, CAST(55.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malawi’, N’2015′, N’Male’, CAST(50.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malaysia’, N’2015′, N’Male’, CAST(64.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Maldives’, N’2015′, N’Male’, CAST(68.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mali’, N’2015′, N’Male’, CAST(51.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Malta’, N’2015′, N’Male’, CAST(70.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mauritania’, N’2015′, N’Male’, CAST(54.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mauritius’, N’2015′, N’Male’, CAST(64.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mexico’, N’2015′, N’Male’, CAST(65.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Micronesia (Federated States of)’, N’2015′, N’Male’, CAST(61.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mongolia’, N’2015′, N’Male’, CAST(58.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Montenegro’, N’2015′, N’Male’, CAST(66.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Morocco’, N’2015′, N’Male’, CAST(64.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Mozambique’, N’2015′, N’Male’, CAST(48.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Myanmar’, N’2015′, N’Male’, CAST(57.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Namibia’, N’2015′, N’Male’, CAST(55.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nepal’, N’2015′, N’Male’, CAST(60.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Netherlands’, N’2015′, N’Male’, CAST(71.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’New Zealand’, N’2015′, N’Male’, CAST(70.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nicaragua’, N’2015′, N’Male’, CAST(60.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Niger’, N’2015′, N’Male’, CAST(53.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Nigeria’, N’2015′, N’Male’, CAST(46.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Norway’, N’2015′, N’Male’, CAST(70.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Oman’, N’2015′, N’Male’, CAST(65.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Pakistan’, N’2015′, N’Male’, CAST(57.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Panama’, N’2015′, N’Male’, CAST(66.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Papua New Guinea’, N’2015′, N’Male’, CAST(54.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Paraguay’, N’2015′, N’Male’, CAST(64.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Peru’, N’2015′, N’Male’, CAST(63.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Philippines’, N’2015′, N’Male’, CAST(58.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Poland’, N’2015′, N’Male’, CAST(65.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Portugal’, N’2015′, N’Male’, CAST(69.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Qatar’, N’2015′, N’Male’, CAST(67.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Republic of Korea’, N’2015′, N’Male’, CAST(70.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Republic of Moldova’, N’2015′, N’Male’, CAST(61.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Romania’, N’2015′, N’Male’, CAST(64.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Russian Federation’, N’2015′, N’Male’, CAST(59.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Rwanda’, N’2015′, N’Male’, CAST(52.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saint Lucia’, N’2015′, N’Male’, CAST(64.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saint Vincent and the Grenadines’, N’2015′, N’Male’, CAST(63.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Samoa’, N’2015′, N’Male’, CAST(64.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sao Tome and Principe’, N’2015′, N’Male’, CAST(57.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Saudi Arabia’, N’2015′, N’Male’, CAST(64.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Senegal’, N’2015′, N’Male’, CAST(57.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Serbia’, N’2015′, N’Male’, CAST(65.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Seychelles’, N’2015′, N’Male’, CAST(62.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sierra Leone’, N’2015′, N’Male’, CAST(43.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Singapore’, N’2015′, N’Male’, CAST(71.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Slovakia’, N’2015′, N’Male’, CAST(65.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Slovenia’, N’2015′, N’Male’, CAST(68.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Solomon Islands’, N’2015′, N’Male’, CAST(61.50 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Somalia’, N’2015′, N’Male’, CAST(46.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’South Africa’, N’2015′, N’Male’, CAST(51.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’South Sudan’, N’2015′, N’Male’, CAST(49.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Spain’, N’2015′, N’Male’, CAST(70.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sri Lanka’, N’2015′, N’Male’, CAST(64.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sudan’, N’2015′, N’Male’, CAST(54.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Suriname’, N’2015′, N’Male’, CAST(61.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Swaziland’, N’2015′, N’Male’, CAST(49.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Sweden’, N’2015′, N’Male’, CAST(71.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Switzerland’, N’2015′, N’Male’, CAST(71.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Syrian Arab Republic’, N’2015′, N’Male’, CAST(52.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tajikistan’, N’2015′, N’Male’, CAST(59.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Thailand’, N’2015′, N’Male’, CAST(64.80 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Macedonia’, N’2015′, N’Male’, CAST(65.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Timor-Leste’, N’2015′, N’Male’, CAST(59.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Togo’, N’2015′, N’Male’, CAST(52.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tonga’, N’2015′, N’Male’, CAST(64.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Trinidad and Tobago’, N’2015′, N’Male’, CAST(61.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Tunisia’, N’2015′, N’Male’, CAST(65.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Turkey’, N’2015′, N’Male’, CAST(64.50 AS Numeric(18, 2)))
GO
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Turkmenistan’, N’2015′, N’Male’, CAST(56.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uganda’, N’2015′, N’Male’, CAST(53.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Ukraine’, N’2015′, N’Male’, CAST(60.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Arab Emirates’, N’2015′, N’Male’, CAST(68.00 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Kingdom’, N’2015′, N’Male’, CAST(70.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United Republic of Tanzania’, N’2015′, N’Male’, CAST(52.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’United States of America’, N’2015′, N’Male’, CAST(67.70 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uruguay’, N’2015′, N’Male’, CAST(65.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Uzbekistan’, N’2015′, N’Male’, CAST(59.90 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Vanuatu’, N’2015′, N’Male’, CAST(63.40 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Venezuela’, N’2015′, N’Male’, CAST(62.30 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Viet Nam’, N’2015′, N’Male’, CAST(63.20 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Yemen’, N’2015′, N’Male’, CAST(57.10 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Zambia’, N’2015′, N’Male’, CAST(51.60 AS Numeric(18, 2)))
INSERT [dbo].[WHO_LifeExpectancy] ([Country], [Year], [Gender], [Age]) VALUES (N’Zimbabwe’, N’2015′, N’Male’, CAST(50.90 AS Numeric(18, 2)))

Descriptive Statistics with SQL and R – 1

I started my re-discovery of statistics with an introduction here. This second post is about descriptive statistics – very basic, simple statistics you begin with as a learner. Descriptive Statistics are also called Summary Statistics and serve to describe/summarize the data. They allow you to understand what the data is about and get a feel for its common features. There are two types of descriptive statistics

Measures of Central Tendency – for example, mean, median and mode.
Measures of Dispersion – or variation from Central Tendency such as standard deviation, interquartile range and so on.

You can figure out minimum and maximum values, outliers, average and most frequently occuring values with descriptive statistics. It takes you no further than that – it is not for deeper diagnostics of data, predictive or prescriptive analytics – but it is where you begin with in terms of understanding your data. In this post I took 5 very basic measures of descriptive statistics in category 1 for my specific measure – which is life expectancy across the globe.

Minimum life expectancy
Maximum life expectancy
Mean or Average life expectancy
Median or Central/mid point value of life expectancy
Mode or most common life expectancy.

It is easy to understand what are minimum and maximum values.They help you understand how wide the data set is. Some people also look at number of nulls in the dataset.
Mean or average is the sum of all values divided by number of values. Mean is very commonly used but does a poor job when there are outliers in the data such an unsually large or small value that can skew the average value.
Median is what you see as mid-point on a sorted scale of values. In other words median is the physical center of the data.Since median is not mathematically based it is rarely used in calculations. It does help with outliers better than mean does.
Mode is the most common value – very useful when you need to know to understand what are the values that occur most frequently. Mode can be used on nominal and ordinal data, hence it is the most commonly used measure of central tendency. There can be more than one mode in a sample.

The formulas to derive at these values are relatively simple – I tried them using both T-SQL and R, and also calling the R script via SQL. T-SQL is not really the best tool for statistical analysis, although it is useful for a beginner to get started.R are on the other hand has built-in functions for most of this.

With R integration into SQL Server 2016 we can pull an R script and integrate it rather easily. I will be covering all 3 approaches. I am using a small dataset – a single table with 915 rows, with a SQL Server 2016 installation and R Studio. The complexities of doing this type of analysis in the real world with bigger datasets involve setting various options for performance and dealing with memory issues – because R is very memory intensive and single threaded.

My table and the data it contains can be created with scripts here. For this specific post I used just one column in the table – age. For further posts I will be using the other fields such as country and gender.

Using T-SQL:

Below are my T-SQL Queries to get minimum, maximum, mean and mode. The mode is rather difficult using T-SQL. Given how easy it is do with R, I did not spend a lot of time on it. How to arrive at the mode of a dataset using T-SQL has been researched well and information can be found here for those interested.

SELECT MIN(age) AS [MINIMUM-AGE],MAX(age) AS [MAXIMUM-AGE],
ROUND((SUM(age)/COUNT(*)),2) AS MEANAGE FROM [dbo].[WHO_LifeExpectancy]
WHERE AGE IS NOT NULL

SELECT TOP 1 AGE AS MODE FROM [dbo].[WHO_LifeExpectancy]
GROUP BY AGE
ORDER BY count(*) DESC

The results I got were as below:
sql-results

Using R:

I downloaded and installed R Studio from here. The script should work just the same with any other version of R.
Before running the actual functions to get results, one has to load up the right libraries in R and connect to the database, then load the table contents into what is called a dataframe in R.Below commands help us do that.

install.packages(“RODBC”)
library(RODBC)

cn <- odbcDriverConnect(connection=”Driver={SQL Server Native Client 11.0};server=MALATH-PC\\SQL;database=WorldHealth;Uid=sa;Pwd=<password>”)

data <- sqlQuery(cn, ‘select age from [dbo].[WHO_LifeExpectancy] where age is not null’)

The data in my table is now in a dataframe called ‘data’ with R. To run statistical functions I need to ‘unpivot’ the dataframe into a single vector, and I have to use the ‘unlist‘ function in R for that purpose. When I run the R script via SQL, this is not necessary as it reads directly from the SQL tables. The R script i used to get the values is as below.

# Calculate the minimum value of data
minvalue<- min(unlist(data))
cat(“Minimum life expectancy”, minvalue)

#Calculate the maximum value of data
maxvalue<-max(unlist(data))
cat(“Maximum life expectancy”, maxvalue)

# Find mean.
data.mean <-mean(unlist(data))
cat(“Average Life Expectancy”, data.mean)

#Find mode
# Create the function.
getmode <- function(v) {
uniqv <- unique(v)
uniqv[which.max(tabulate(match(v, uniqv)))]
}

# Calculate the mode using the user function.
data.mode <- getmode(unlist(data))
cat(“Most common life expectancy”, data.mode)

data.median<-median(unlist(data))
data.median

Note that aside from mode all the rest are built-in functions in R. I borrowed the code for mode from here (the cool thing about R is the huge # of pre written scripts to do just about anything).

The results I got are as below:

r-studio

To be noted that the values of max, min, mean and mode are exactly the same as what we got from T-SQL which means this is correct.

3. Using R function calls with T-SQL

Details on configuration needed to use R within SQL Server are explained here.

The last and final step was to try the same script, without certain R specific commans such as ‘unlist’ to unlist the dataframe, and ‘cat’ to display concatenated results. The scripts are as below. The first one is the call to basic statistics and the second is to get the mode. I separated the function for mode into a script in itself as it was multiple lines and hard to include within same call.

EXEC sp_execute_external_script
@language = N’R’
,@script = N’minvalue <-min(InputDataSet$LifeExpectancies);
cat(“Minimum life expectancy”, minvalue,”\n”);
maxvalue <-max(InputDataSet$LifeExpectancies);
cat(” Maximum life expectancy”, maxvalue,”\n”);
average <-mean(InputDataSet$LifeExpectancies);
cat(” Average life expectancy”, average,”\n”);
medianle <-median(InputDataSet$LifeExpectancies);
cat(” Median Life Expectancy”, medianle,”\n”);
‘
,@input_data_1 = N’SELECT LifeExpectancies = Age FROM [WorldHealth].[dbo].[WHO_LifeExpectancy];’
;

EXEC sp_execute_external_script
@language = N’R’
,@script = N’getmode <- function(v) {
uniqv <- unique(v)
uniqv[which.max(tabulate(match(v, uniqv)))]
};
modele <- getmode(InputDataSet$LifeExpectancies);
cat(” Most Common Life Expectancy”, modele);
‘
,@input_data_1 = N’SELECT LifeExpectancies = Age FROM [WorldHealth].[dbo].[WHO_LifeExpectancy];’
;

sql-r-results

Other than a slight variation in mode , which i suspect is because of decimal rounding issues, the results are exactly the same as what we got via TSQL and R Studio.

In the next post I am going to deal with measure of dispersion. Thank you for reading and do leave me comments if you can!

Basic Statistics with SQL – Introduction

I was a student of statistics in school and college. I didn’t get to use much of anything I learned at school, and this was considered one of them. But apparently with the boom in interest in data mining, knowledge of statistics has become more important than ever before. Along with learning basics of statistics comes numerous tools available to mine data, and get appropriate metrics for business. For many people including me – we’d like to get involved with meaningful data mining but don’t know where to start. I personally decided to go back into revising some concepts I knew back in the days off the top of my head. I am going to blog every week on one concept that I am re-learning and applying to some data. I have great interest in data related to healthcare, so I used a data set available for public download from World Health Organization to help me. I also used T-SQL to run basic statistical queries. T-SQL is far from the best tool there is for statistical analysis, but it is certainly useful for getting a start on the subject of understanding and summarizing data.

You are given a dataset. It could a table, or multiple tables. What are the appropriate questions to ask before you get around to analyzing/mining this dataset? Below are a few that are recommended that I found useful to begin with:

What is the variable being measured? (There may be multiple, but for simplicity’s sake, let us make it 1).
In my case that is life expectancy of people around the globe,summarized at country level.
What is the population used? (The population is the potential collection of people that are ideally part of the sample used.)
People living in the countries around the globe.
What is the sample used? (The sample is the subset of the population used for this specific purpose)
People living in the countries targeted for this study.

The reason for asking these questions is to ensure that the dataset is representative of what we intend to present – if we say we are presenting statistics on global life expectancy there better be numbers related to that from many different countries around the world. There need not be every country on the list, but several countries are necessary to make the sample worthy of study. Sampling and sample size is in itself a very vast and deep subject. But this is just about understanding its basics and why we ask certain questions.

The last question that would determine the nature of our queries is about type of the variable being measured. Data used for statistical analysis can fall into one of 4 categories ,also called statistical scales – Nominal, Ordinal, Interval and Ratio. Like it is with rules of normalization – there are 4 rules to determine nature of measurement –

Identity – each value is unique
Magnitude – values have a relationship to each other
Equal Intervals – difference between two unique values is the same
Minimum value of 0 – the minimal value of the variable is 0.

Applying these rules to the above types of data –

Nominal data is what falls into specific mutually exclusive categories (the ones commonly under radio buttons) – male/female, ethnicity, nationality and so on. It satisfies rule 1.

Ordinal data is basically nominal data but has buckets that are gradeable or have some sort of order to them – such as ‘how good was this presentation – excellent to horrible’, or ‘how do you feel’, or even for example, work related titles – like data entry clerk, programmer, dba, senior dba and so on. It satisfies rules 1 and 2.

Interval data is numbers, and like ordinal – very specific numbers but you can calculate the difference between them. Interval data satisfies rules 1,2 and 3 but not 4 – because it does not stop at 0. An example would be temperature.

Ratio data is numbers like interval data but the minimum stops at 0. This enables data to be ratio friendly and hence is the best kind for statistical analysis.Examples would be weight, speed of a vehicle and so on.

In my specific data set – the variable am analyzing is life expectancies/age, which is ratio data by some and ordinal by others. This link addresses why. (There are a lot of such ambiguities and in the end what we call it is secondary to the value we derive out it). Now that i know my data, i need to go about running some basic statistics on it. More on that in the next post.

TSQL Tuesday #75 – PowerBI

SqlTuesday

This month’s TSQL Tuesday post is from one of my favorite people in the community – Jorge Segarra a.k.a. SQL Chicken. It is an invite to play with a new and shiny toy – Power BI. Now – like most people, my initial reaction was like ‘naaah, am not a BI person!’. I dread TSQL Tuesdays that leave me staring at a wall wondering what to write, and there have been a few of them. Certain features are not easy to try in a test lab environment – and work environments do not always lend themselves to that flexibility. But this seemed like something very easy to install and play with, on one’s own desktop.

After some hiccups with email and such which Jorge helped me resolve – (details on how to download the tool are in his post) I got the tool installed very easily. I considered various test data to play with it – felt it would be fun to use data accumulated over our sql saturdays at Louisville, which I have been the lead organizer for. We have had 8 events to date, but only 5 are available as history on website. But this was information enough. I pulled the reports on attendee registration going back five years from the sql saturday website, saved them as excel files, removed attendee personal information, and consolidated all of it into one CSV file. I learned later that you can actually do some data scrubbing within PowerBI itself but this was something I did outside and was ready with.

I launched the PowerBI desktop – pointed to my csv file as data source, and bingo, I was ready to go. The reports I needed were not raw data from the file – needed some grouping and consolidation – so I clicked on new query – which by default will bring up your raw data for you. In my case I needed the data to be grouped in several ways for my reports.Details of grouping are as below.

pb5

I created 4 queries – one each for each of my reports.
1 Query 1 – really simple, year wise grouping of attendee count.
2 Query 2 – two levels of grouping – year, meal preferences, count of people with those preferences.
3 Query 3 – two levels of grouping- year, opt in choice for emails, count for opt in choices.
4 Query 4 – two levels of grouping – year, state attendee is from, count of attendees. Here I had to filter out some junk data for name of state – and consolidate some verbage, like KY=Kentucky and so on.

When I was done the list of my data sources looked like below.

pb6

Now with my data ready, I launched into getting my reports up. I used each data source from above list for each graph (you can also use multiple but wanted to keep this simple).

pb4

The interactive graph can be viewed with better fonts here

https://app.powerbi.com/view?r=eyJrIjoiY2EzMWI1ZWQtYTQxNC00YjJhLTgxZTQtYjEyZjBkNzU5YTllIiwidCI6IjU2MzQ0OTU1LTJiZWYtNGFhZi1iYzg2LTQ4YWEzNzMzNzI0MSIsImMiOjZ9

Based on above graphs I was able to draw following conclusions:

1 First bar graph on the top left: Attendee by year: Our highest turnout was in 2011 (301) in the past five years. Hope to beat that record in 2016! Last year was 263 people.

2 Second horizontal bar on the right: Food payment preferences by year: A lot more people opted to bring their own lunch last year – this may be because we hiked the lunch fee to 10$ after several years (yeah Kentucky:)) . There are more people being comped as well due to higher number of sponsors and volunteers, which is not a bad thing. It would be interesting to see how this graph changes this year, because we provided a fantastic BBQ lunch last year. We have also hiked lunch fee from 10-12$ so it could go either way.

3 First bar graph on bottom left: Optin attendees over years: People who have opted out from vendor emails has gone up and was highest last year.We need to work harder on getting more people to opt-in as this means lesser reach for vendors.

4 Last graph bottom right: Attendee count by state: Looks like we did not have significant people from TN until 2013…(I filtered out #s less than 10 for this graph as we are not interested in 1 or 2 random attendees from other states). Our largest # of people are from KY, which is no surprise at all..but what was surprising to me for sure was that IN and OH both had around similar number of people.We did have several speakers from OH – but not 23, and there are certainly more people coming in from there. This shows that we have to promote our event harder in OH, as well as work on getting more people from TN, another border state.

All said and done, I had an absolute ball doing this. Not only is it easy and convenient to use but comes in handy for a variety of different things, including analysing personal finances and such. I highly recommend it!

Advent of Code – Day 2 – Using Cross apply

For this post i worked on second puzzle in the Adventofcode series. This wasn’t as challenging as the first one, but still very doable with TSQL.

Part 1 of the puzzle was as below:

The elves are running low on wrapping paper, and so they need to submit an order for more. They have a list of the dimensions (length l, width w, and height h) of each present, and only want to order exactly as much as they need.

Fortunately, every present is a box (a perfect right rectangular prism), which makes calculating the required wrapping paper for each gift a little easier: find the surface area of the box, which is 2*l*w + 2*w*h + 2*h*l. The elves also need a little extra paper for each present: the area of the smallest side.

For example:

A present with dimensions 2x3x4 requires 2*6 + 2*12 + 2*8 = 52 square feet of wrapping paper plus 6 square feet of slack, for a total of 58square feet.
A present with dimensions 1x1x10 requires 2*1 + 2*10 + 2*10 = 42square feet of wrapping paper plus 1 square foot of slack, for a total of 43 square feet.

All numbers in the elves’ list are in feet. How many total square feet of wrapping paper should they order?

Solution: The input was about 1000 lines long, in the format of axbxc, with a , b and c being numbers for each of the three dimensions. It was too long to stick into an insert statement, so I put it into a text file and imported that text file into a table. I then parsed the string to get the 3 numbers out as length,breadth and width, different fields in the same table. Don’t think that part is really necessary as it is simple TSQL. For getting the answer to the puzzle, I used below query:

SELECT SUM( 2*(length*breadth)
+ 2*(Breadth*Width)
+ 2*(Width*Length)
+ (IIF(Length*Breadth > Breadth*Width, IIF(BREADTH*width > Width*Length, WIDTH*Length, Breadth*Width),IIF(LengTH*Breadth > Width*Length, Width*Length, Length*Breadth))
)) FROM [dbo].[listofcodes]

For part 2:

The elves are also running low on ribbon. Ribbon is all the same width, so they only have to worry about the length they need to order, which they would again like to be exact.

The ribbon required to wrap a present is the shortest distance around its sides, or the smallest perimeter of any one face. Each present also requires a bow made out of ribbon as well; the feet of ribbon required for the perfect bow is equal to the cubic feet of volume of the present. Don’t ask how they tie the bow, though; they’ll never tell.

For example:

A present with dimensions 2x3x4 requires 2+2+3+3 = 10 feet of ribbon to wrap the present plus 2*3*4 = 24 feet of ribbon for the bow, for a total of 34 feet.
A present with dimensions 1x1x10 requires 1+1+1+1 = 4 feet of ribbon to wrap the present plus 1*1*10 = 10 feet of ribbon for the bow, for a total of 14 feet.

How many total feet of ribbon should they order?

Solution: This needed a table valued UDF that returns the sum of the least two values given 3 values. Again, simple TSQL which I don’t think is worth a cut and paste. The final solution was as below. I learnt something from this. I always assumed that a table valued UDF would return something (null if there was no value) – but there was a bug in mine which caused it to return nothing for some rows. When the cross apply returned fewer rows than main table it led me to investigate and figure this out – This was an interesting new discovery. But otherwise, the solution was simple.

SELECT SUM((2*minvalue)+(length*breadth*width))
FROM [dbo].[listofcodes] l CROSS APPLY dbo.[udf_summingsides](length,l.breadth,l.width) f

On to the next one…am not sure I’d be blogging every one of these since several of them are seriously procedural in solution. But when I find one that is TSQL Friendly will get to it again. Thank you for reading.

Advent of Code – Day 1 – Parsing a variable

I have been following the series of posts written by my friend and SQL MCM Wayne Sheffield on some TSQL puzzles – these puzzles are from a guy named Eric Wastl and called ‘Advent of Code‘.
Your challenge basically after you sign up is to solve a series of puzzles arranged in the form of a christmas tree – each puzzle has two parts to it, the second part will be revealed after the first part is successfully solved. While the fundamental puzzle is the same, each person will be presented with a different data set for solving it, so no two people get the same answer. You can paste your answer in and verify it for correctness. These puzzles are not TSQL/SQL Server specific, but TSQL lends itself beautifully well to solving them.

I took up the challenge and came up with my own answers – Day 1 as below:

Part 1 of puzzle:

Santa is trying to deliver presents in a large apartment building, but he can’t find the right floor – the directions he got are a little confusing. He starts on the ground floor (floor 0) and then follows the instructions one character at a time.

An opening parenthesis, (, means he should go up one floor, and a closing parenthesis, ), means he should go down one floor.

The apartment building is very tall, and the basement is very deep; he will never find the top or bottom floors.

For example:

(()) and ()() both result in floor 0.
((( and (()(()( both result in floor 3.
))((((( also results in floor 3.
()) and ))( both result in floor -1 (the first basement level).
))) and )())()) both result in floor -3.

To what floor do the instructions take Santa? I am supplied with the string of braces as my data.

Solution :

DECLARE @leftbrace CHAR(1), @rightbrace CHAR(1)
DECLARE @string VARCHAR(MAX)
SET @string = '()()(()()()(()()((()((()))((()((((()()((((()))()((((())(((((((()(((((((((()(((())(()()(()((()()(()(())(()((((()((()()()((((())((((((()(()(((()())(()((((()))())(())(()(()()))))))))((((((((((((()())()())())(())))(((()()()((((()(((()(()(()()(()(()()(()(((((((())(())(())())))((()())()((((()()((()))(((()()()())))(())))((((())(((()())(())(()))(()((((()())))())((()(())(((()((((()((()(())())))((()))()()(()(()))))((((((((()())((((()()((((()(()())(((((()(()())()))())(((()))()(()(()(()((((()(())(()))(((((()()(()()()(()(((())())(((()()(()()))(((()()(((())())(()(())())()()(())()()()((()(((()(())((()()((())()))((()()))((()()())((((()(()()(()(((()))()(()))))((()(((()()()))(()(((())()(()((()())(()(()()(()())(())()(((()(()())()((((()((()))))())()))((()()()()(())()())()()()((((()))))(()(((()()(((((((())()))()((((()((())()(()())(())()))(()(()())(((((((())))(((()))())))))()))())((())(()()((())()())()))))()((()()())(())((())((((()())())()()()(((()))())))()()))())(()()()(()((((((()()))())()))()(((()(((())((((()()()(()))())()()))))())()))())((())()())(((((())())((())())))(((())(((())(((((()(((((())(()(()())())(()(())(()))(()((((()))())()))))())))((()(()))))())))(((((())()))())()))))()))))(((()))()))))((()))((()((()(()(())()())))(()()()(())()))()((((())))))))(())(()((()()))(()))(()))(()((()))))))()()((((()()))()())()))))))()()()))(()((())(()))((()()()())()(((()((((())())))()((((()(()))))))())))()()())()))(()))))(()())()))))))((())))))))())()))()((())())))(()((()))()))(())))))(()))()())()()))((()(()))()()()()))))())()()))())(())()()))()))((()))))()()(()())))))()()()))((((()))()))))(()(())))(()())))((())())(()))()))))()())))()())()())))))))))()()))))())))((())((()))))())))(((()())))))))(()))()()))(()))()))))()())))))())((((()())))))))())))()()))))))))()))()))))()))))))(())))))))))())))))))))))))))())())((())))))))))()))((())))()))))))))())()(()))))))())))))()()()())()(()()()(()())(()))()()()(()())))())())))()))))())))))))()()()()())(())())()())()))))(()()()()()))))()))())())))((()())()())))()))()))))(()())))()))))))))(((()))()()))))))))))))))))))))(()))(()((()))())))())(()))(()(()(())))))()(()))()))()()))))))))))))()((()())(())())()(())))))())()())((()()))))(()()))))())()(())()))))))))))))))))))))()))(()(()())))))))()()((()))()))))))((())))()))))))))((()))())()()))())()()))((()))())))))))))))(()())()))(())((()(()()))(()())(())))()())(()(())()()))))()))()(()))))))(()))))))))))(()))())))))))))())))))())))(())))))()))))(())())))))))))()(()))))()())))())(()))()())))))))))))))())()()))))()))))))())))))()))))(())(()()()()((())()))())(()))((())()))())())(())(()()))))()))(())()()((())(())))(())))()))())))))))))()(((((())())))(())()))))(())))((()))()(((((((()))))()()))(())))))()(()))))(()()))()))())))))))(()())()))))))))())))(()))())()))(())()((())())()())())(()(()))))()))))))((()())(())()()(()())))()()))(())(())(()))())))()))(()))()()))((((()))))()))((()()()))))()))()))())))(()))()))))(())))()))())()(()))()())))())))))))())))())))()()))))))(()))())())))()))()()())())))))))))))))())))()))(()()))))())))())()(())))())))))))))))))))))()()())())))))()()()((()(()))()()(())()())()))()))))()()()))))))((()))))))))()(()(()((((((()()((()())))))))))))()))())))))((())())(()))())))())))))())()()())(())))())))()())())(())))))))()()(())))()))())))())())())()))))))))()))(()()()())())())))(())())))))))()()())()))))())))())()(())())))))))()())()))(()()(())())))()(()((()()((()()(((((())(()())()))(())()))(())))(())))))))()))()))((()))()))()))))))))()))))))))((()()())(()))(((()))(())))()))((())(((())))()())))())))))((())))))(())())((((((())())()(()))()(()((()())))((())()(()(()))))(())(()()())(())))())((()(((())())))(((()())())))())()(())())((((()()))))())((()))()()()()(())(((((((()()()((()))())(()())))(())())((((()()(()))))()((())))((())()))()(((()))())))()))((()(()))(())(()((((())((((()()(()()))(((())(()))))((((()(()))(())))))((()))(()))((()(((()(()))(()(()((()(())(()(()(()(()()((()))())(((())(()(()))))(()))()()))(())))(())()(((())(()))()((((()()))))())(()))))((())()((((()(((()))())())(((()))()())((())(())())(())()(())()(()()((((((()()))))()()(((()()))))()())()(((()(()))(()(()())(()(()))))(((((()(((())())))))(((((()((()()((())())((((((()(())(()()((()()()()()()()(()()))()(((()))()))(((((((())(((()((()())()((((())(((()(())))()((()(()()()((())((()())()))()))())))())((((((()))(()(()()()))(()((()(()(()))()((()(((()()()((())(((((())()(()))())())((()(())))(()(()())(())((())())())(((()()()(())))))())(()))))))()))))))())((()()()))((()((((((()))(((()((((()()()(((()))())()(()()(((()((()()()()())()()))()()()(()(())((()))))(()))())))))))()(()()(((((())()(()(((((()((()(()()())(()((((((((()((((((())()((((()()()((()((()((((((()))((())))))))())()))((()(()))()(()()(()((())((()()((((((((((((()())(()()()))((((()((((((())(()))())(()()((()()))()(((((((()((()()((((((()(((())))((())))((((((((()()(((((((())(((((()())(((())((())()((((()(((((((()(()(((()((((((()(((()(((((((((((()()((()()(()))((()()(((()(((())))((((())()(()(((())()(()(((())(((((((((((()))())))((((((())((()()((((()())())((((()()))((())(((((()(()()(()()()((())(()((()()((((()(((((()((()(()((((()())((((((()(((((()()(()(()((((())))(())(())(())((((()(()()((((()((((()()((()((((((())))(((((()))))()))(()((((((((()(((())())(((())))(()(()((())(((()((()()(((((()((()()(((())()(()))(((((((())(()(((((()))((()((()((()))(())())((((()((((())()(()))(((()(((((((((((((((())(((((((((()))(((()(()()()()((((((()((())()((((((((()(())(((((((((((()(()((())()((()()(()(()()((((()()((())(()((()()(()()((((()(((((((())))((((())(())()(((()()((()()((((()((()(((()((())(((()()()((((()((((()()(()(()((((((((())(()(((((())(()())(((((((()())()(()((((()((())(()()())((((()()(((()((((())(())(()()(((((((((()()))()(((())(()(()((((((())(()()())(()))()()(((()(((()((())(()(((((((()(()(()((()(((((()(()((()(()((((((()((((()()((((()(((()((())(()(()((()()((((()()(())()(())(((())(()((((((((()())(((((((((()(())()((((())))()))()()(((((()()((((((())(()()(((()(()(((((((()(()(((((((())(())((((()((()(())))((((()()())(()))((()())((((()(((((()(()(())(()(()()())(((((()(((((()((((()()((((((((()()))(()((((((())((((())()(()(((()()()(((()(()(())(())(((((()(())())((((())(())(()(((()(((((())((((())())((()(((((((()(((())(()(()))(((((((((()((()((()()(()((((())(((()((())((((())(()(((()(((()(()((((()(((())(()(((()(()()(()(()((()()(()())(())())((()(()(((()(((()(((()()(((((((((()(((((((((()()(((()(((()())((((()(()(((()()()((())((((((((((())(()(((()((((()())((((()((()))(((()()()(((((()(((((((())((()())(()((((())((((((((())(()((()((((((((((()()((()((()()))(((()())()())()(((()())()()(()(()(((((((())()))(())()))())()()((())()((()((((()((()((())(((((()((((((()(())))(()))())(((()))((()()(()(((()))((((())()(((()))))()(()(())()(((((())(()(()(())(())()((()()()((((()(())((()())(()(()))(()(()(()()(())()()(()((())()((()))))()))((()(()()()()((()())(()))())()(()(((((((((())())((()((()((((((())()((((())(((())((()(()()()((())(()((())(((()((((()()((()(()(((((())()))()((((((()))((())(((()()))(((())(())()))(((((((())(())())()(())(((((()))()((()))()(()()((()()()()()())(((((((';

SET @leftbrace = '('
SET @rightbrace = ')'
SELECT  (LEN(@string) - LEN(REPLACE(@string, @rightbrace, ''))) - (LEN(@string) - LEN(REPLACE(@string, @leftbrace, '')))

Easy peasy right? My answer was 280. Now harder..onto part 2

Part 2 : Now, given the same instructions, find the position of the first character that causes him to enter the basement (floor -1). The first character in the instructions has position 1, the second character has position 2, and so on.

For example:

) causes him to enter the basement at character position 1.
()()) causes him to enter the basement at character position 5.

What is the position of the character that causes Santa to first enter the basement?

This gets much harder..well sort of..it is easy to do character by character, the RBAR way, although you are parsing a variable here and that might be excusable given how TSQL works generally with this..but a better way perhaps would be to parse the string using a recursive CTE – as below. My answer was 1797. I had fun doing this as i had not parsed a variable this way and learnt how. I hope you do too..and do remember, your set of data is different , so don’t make the same mistake I did (cut and paste from here and wonder why the site is not accepting your answer!!).

Happy Coding Fun and for the next part, next week!

DECLARE @start INT, @end INT, @pos INT
DECLARE @leftbrace CHAR(1)
SET @leftbrace = '(';
SET @string = '()()(()()()(()()((()((()))((()((((()()((((()))()((((())(((((((()(((((((((()(((())(()()(()((()()(()(())(()((((()((()()()((((())((((((()(()(((()())(()((((()))())(())(()(()()))))))))((((((((((((()())()())())(())))(((()()()((((()(((()(()(()()(()(()()(()(((((((())(())(())())))((()())()((((()()((()))(((()()()())))(())))((((())(((()())(())(()))(()((((()())))())((()(())(((()((((()((()(())())))((()))()()(()(()))))((((((((()())((((()()((((()(()())(((((()(()())()))())(((()))()(()(()(()((((()(())(()))(((((()()(()()()(()(((())())(((()()(()()))(((()()(((())())(()(())())()()(())()()()((()(((()(())((()()((())()))((()()))((()()())((((()(()()(()(((()))()(()))))((()(((()()()))(()(((())()(()((()())(()(()()(()())(())()(((()(()())()((((()((()))))())()))((()()()()(())()())()()()((((()))))(()(((()()(((((((())()))()((((()((())()(()())(())()))(()(()())(((((((())))(((()))())))))()))())((())(()()((())()())()))))()((()()())(())((())((((()())())()()()(((()))())))()()))())(()()()(()((((((()()))())()))()(((()(((())((((()()()(()))())()()))))())()))())((())()())(((((())())((())())))(((())(((())(((((()(((((())(()(()())())(()(())(()))(()((((()))())()))))())))((()(()))))())))(((((())()))())()))))()))))(((()))()))))((()))((()((()(()(())()())))(()()()(())()))()((((())))))))(())(()((()()))(()))(()))(()((()))))))()()((((()()))()())()))))))()()()))(()((())(()))((()()()())()(((()((((())())))()((((()(()))))))())))()()())()))(()))))(()())()))))))((())))))))())()))()((())())))(()((()))()))(())))))(()))()())()()))((()(()))()()()()))))())()()))())(())()()))()))((()))))()()(()())))))()()()))((((()))()))))(()(())))(()())))((())())(()))()))))()())))()())()())))))))))()()))))())))((())((()))))())))(((()())))))))(()))()()))(()))()))))()())))))())((((()())))))))())))()()))))))))()))()))))()))))))(())))))))))())))))))))))))))())())((())))))))))()))((())))()))))))))())()(()))))))())))))()()()())()(()()()(()())(()))()()()(()())))())())))()))))())))))))()()()()())(())())()())()))))(()()()()()))))()))())())))((()())()())))()))()))))(()())))()))))))))(((()))()()))))))))))))))))))))(()))(()((()))())))())(()))(()(()(())))))()(()))()))()()))))))))))))()((()())(())())()(())))))())()())((()()))))(()()))))())()(())()))))))))))))))))))))()))(()(()())))))))()()((()))()))))))((())))()))))))))((()))())()()))())()()))((()))())))))))))))(()())()))(())((()(()()))(()())(())))()())(()(())()()))))()))()(()))))))(()))))))))))(()))())))))))))())))))())))(())))))()))))(())())))))))))()(()))))()())))())(()))()())))))))))))))())()()))))()))))))())))))()))))(())(()()()()((())()))())(()))((())()))())())(())(()()))))()))(())()()((())(())))(())))()))())))))))))()(((((())())))(())()))))(())))((()))()(((((((()))))()()))(())))))()(()))))(()()))()))())))))))(()())()))))))))())))(()))())()))(())()((())())()())())(()(()))))()))))))((()())(())()()(()())))()()))(())(())(()))())))()))(()))()()))((((()))))()))((()()()))))()))()))())))(()))()))))(())))()))())()(()))()())))())))))))())))())))()()))))))(()))())())))()))()()())())))))))))))))())))()))(()()))))())))())()(())))())))))))))))))))))()()())())))))()()()((()(()))()()(())()())()))()))))()()()))))))((()))))))))()(()(()((((((()()((()())))))))))))()))())))))((())())(()))())))())))))())()()())(())))())))()())())(())))))))()()(())))()))())))())())())()))))))))()))(()()()())())())))(())())))))))()()())()))))())))())()(())())))))))()())()))(()()(())())))()(()((()()((()()(((((())(()())()))(())()))(())))(())))))))()))()))((()))()))()))))))))()))))))))((()()())(()))(((()))(())))()))((())(((())))()())))())))))((())))))(())())((((((())())()(()))()(()((()())))((())()(()(()))))(())(()()())(())))())((()(((())())))(((()())())))())()(())())((((()()))))())((()))()()()()(())(((((((()()()((()))())(()())))(())())((((()()(()))))()((())))((())()))()(((()))())))()))((()(()))(())(()((((())((((()()(()()))(((())(()))))((((()(()))(())))))((()))(()))((()(((()(()))(()(()((()(())(()(()(()(()()((()))())(((())(()(()))))(()))()()))(())))(())()(((())(()))()((((()()))))())(()))))((())()((((()(((()))())())(((()))()())((())(())())(())()(())()(()()((((((()()))))()()(((()()))))()())()(((()(()))(()(()())(()(()))))(((((()(((())())))))(((((()((()()((())())((((((()(())(()()((()()()()()()()(()()))()(((()))()))(((((((())(((()((()())()((((())(((()(())))()((()(()()()((())((()())()))()))())))())((((((()))(()(()()()))(()((()(()(()))()((()(((()()()((())(((((())()(()))())())((()(())))(()(()())(())((())())())(((()()()(())))))())(()))))))()))))))())((()()()))((()((((((()))(((()((((()()()(((()))())()(()()(((()((()()()()())()()))()()()(()(())((()))))(()))())))))))()(()()(((((())()(()(((((()((()(()()())(()((((((((()((((((())()((((()()()((()((()((((((()))((())))))))())()))((()(()))()(()()(()((())((()()((((((((((((()())(()()()))((((()((((((())(()))())(()()((()()))()(((((((()((()()((((((()(((())))((())))((((((((()()(((((((())(((((()())(((())((())()((((()(((((((()(()(((()((((((()(((()(((((((((((()()((()()(()))((()()(((()(((())))((((())()(()(((())()(()(((())(((((((((((()))())))((((((())((()()((((()())())((((()()))((())(((((()(()()(()()()((())(()((()()((((()(((((()((()(()((((()())((((((()(((((()()(()(()((((())))(())(())(())((((()(()()((((()((((()()((()((((((())))(((((()))))()))(()((((((((()(((())())(((())))(()(()((())(((()((()()(((((()((()()(((())()(()))(((((((())(()(((((()))((()((()((()))(())())((((()((((())()(()))(((()(((((((((((((((())(((((((((()))(((()(()()()()((((((()((())()((((((((()(())(((((((((((()(()((())()((()()(()(()()((((()()((())(()((()()(()()((((()(((((((())))((((())(())()(((()()((()()((((()((()(((()((())(((()()()((((()((((()()(()(()((((((((())(()(((((())(()())(((((((()())()(()((((()((())(()()())((((()()(((()((((())(())(()()(((((((((()()))()(((())(()(()((((((())(()()())(()))()()(((()(((()((())(()(((((((()(()(()((()(((((()(()((()(()((((((()((((()()((((()(((()((())(()(()((()()((((()()(())()(())(((())(()((((((((()())(((((((((()(())()((((())))()))()()(((((()()((((((())(()()(((()(()(((((((()(()(((((((())(())((((()((()(())))((((()()())(()))((()())((((()(((((()(()(())(()(()()())(((((()(((((()((((()()((((((((()()))(()((((((())((((())()(()(((()()()(((()(()(())(())(((((()(())())((((())(())(()(((()(((((())((((())())((()(((((((()(((())(()(()))(((((((((()((()((()()(()((((())(((()((())((((())(()(((()(((()(()((((()(((())(()(((()(()()(()(()((()()(()())(())())((()(()(((()(((()(((()()(((((((((()(((((((((()()(((()(((()())((((()(()(((()()()((())((((((((((())(()(((()((((()())((((()((()))(((()()()(((((()(((((((())((()())(()((((())((((((((())(()((()((((((((((()()((()((()()))(((()())()())()(((()())()()(()(()(((((((())()))(())()))())()()((())()((()((((()((()((())(((((()((((((()(())))(()))())(((()))((()()(()(((()))((((())()(((()))))()(()(())()(((((())(()(()(())(())()((()()()((((()(())((()())(()(()))(()(()(()()(())()()(()((())()((()))))()))((()(()()()()((()())(()))())()(()(((((((((())())((()((()((((((())()((((())(((())((()(()()()((())(()((())(((()((((()()((()(()(((((())()))()((((((()))((())(((()()))(((())(())()))(((((((())(())())()(())(((((()))()((()))()(()()((()()()()()())(((((((';
SET @start = 1
SET @pos = 0;

WITH a AS
(SELECT [start] = 1,
 [end] = LEN(@string),
 [pos] = IIF(SUBSTRING(@string, @start, 1) = @leftbrace, @pos + 1, @pos - 1)
 UNION ALL
 SELECT [start] = [start] + 1,
 [end] = LEN(@string),
 [pos] = IIF(SUBSTRING(@string, [start]+1, 1) = @leftbrace, [pos] + 1, [pos] - 1)
 FROM a
 WHERE [start] <= [end])

SELECT TOP(1) [start] FROM a WHERE pos = -1 OPTION (MAXRECURSION 0)

Comparing data in two identical tables

Continuing with the recipes in SQL Server 2012 T-SQL recipes book – I was drawn to this puzzle that asked for how you would compare data in two identical tables using a single query. Now, if they didn’t specify the means I would readily point them to Red Gate’s SQL Data Compare – a nifty great tool that does this kind of stuff and gives an awesome report on differences. But as we all know, not all companies have tools. And, if you are presented this question at an interview – that would probably not be an acceptable answer.
My answer to this problem is different from what is in the book – mainly because I wanted a generic query that I could use on any table. The book deals with grouping on a field-to-field basis which is table specific and would come in handy if the situation demands that.
My solution is as below – I took two tables in Adventureworks, Password and Passwordcopy which is an identical version of Password. I made some changes to the latter as below(updated two records, added one record and changed two more via management studio).

TABLECOMPARE1

Now I ran query as below to give me differences.

TABLECOMPARE2

It gave me the differences I was looking for. I can run the first part of the query before union to see what of these came from first table and second part to see what is in the second. Of course, it is not SQL Data Compare – it does not tell me what the differences are but it is a simple easy way to get a look.