SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;

create table AmazonEC2
(
PricePerUnit nvarchar(25),
Instance_Type nvarchar(25),
Instance_Family nvarchar(25),
Location nvarchar(25)
)


(No column name)


Microsoft SQL Server 2019 (RTM-CU16) (KB5011644) - 15.0.4223.1 (X64) 
	Apr 11 2022 16:24:07 
	Copyright (C) 2019 Microsoft Corporation
	Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1769.52', 'c5.12xlarge', 'Compute optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1681.92', 'c5.12xlarge', 'Compute optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1489.2', 'c5.12xlarge', 'Compute optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2654.28', 'c5.18xlarge', 'Compute optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2522.88', 'c5.18xlarge', 'Compute optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2233.8', 'c5.18xlarge', 'Compute optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('3539.04', 'c5.24xlarge', 'Compute optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('3363.84', 'c5.24xlarge', 'Compute optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2978.4', 'c5.24xlarge', 'Compute optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('294.92', 'c5.2xlarge', 'Compute optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('280.32', 'c5.2xlarge', 'Compute optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('248.2', 'c5.2xlarge', 'Compute optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('589.84', 'c5.4xlarge', 'Compute optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('560.64', 'c5.4xlarge', 'Compute optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('496.4', 'c5.4xlarge', 'Compute optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1327.14', 'c5.9xlarge', 'Compute optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1261.44', 'c5.9xlarge', 'Compute optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1116.9', 'c5.9xlarge', 'Compute optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('73.73', 'c5.large', 'Compute optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('70.08', 'c5.large', 'Compute optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('62.05', 'c5.large', 'Compute optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('147.46', 'c5.xlarge', 'Compute optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('140.16', 'c5.xlarge', 'Compute optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('124.1', 'c5.xlarge', 'Compute optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1944.72', 'm5.12xlarge', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1874.64', 'm5.12xlarge', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1681.92', 'm5.12xlarge', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2592.96', 'm5.16xlarge', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2499.52', 'm5.16xlarge', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2242.56', 'm5.16xlarge', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('3889.44', 'm5.24xlarge', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('3749.28', 'm5.24xlarge', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('3363.84', 'm5.24xlarge', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('324.12', 'm5.2xlarge', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('312.44', 'm5.2xlarge', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('280.32', 'm5.2xlarge', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('648.24', 'm5.4xlarge', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('624.88', 'm5.4xlarge', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('560.64', 'm5.4xlarge', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1296.48', 'm5.8xlarge', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1249.76', 'm5.8xlarge', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1121.28', 'm5.8xlarge', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('81.03', 'm5.large', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('78.11', 'm5.large', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('70.08', 'm5.large', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('162.06', 'm5.xlarge', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('156.22', 'm5.xlarge', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('140.16', 'm5.xlarge', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2592.96', 'r5.12xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2470.32', 'r5.12xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2207.52', 'r5.12xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('3457.28', 'r5.16xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('3293.76', 'r5.16xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2943.36', 'r5.16xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('5185.92', 'r5.24xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('4940.64', 'r5.24xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('4415.04', 'r5.24xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('432.16', 'r5.2xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('411.72', 'r5.2xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('367.92', 'r5.2xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('864.32', 'r5.4xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('823.44', 'r5.4xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('735.84', 'r5.4xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1728.64', 'r5.8xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1646.88', 'r5.8xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1471.68', 'r5.8xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('108.04', 'r5.large', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('102.93', 'r5.large', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('91.98', 'r5.large', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('216.08', 'r5.xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('205.86', 'r5.xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('183.96', 'r5.xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2960.88', 'r5d.12xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2803.2', 'r5d.12xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('2522.88', 'r5d.12xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('3947.84', 'r5d.16xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('3737.6', 'r5d.16xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('3363.84', 'r5d.16xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('5921.76', 'r5d.24xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('5606.4', 'r5d.24xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('5045.76', 'r5d.24xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('493.48', 'r5d.2xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('467.2', 'r5d.2xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('420.48', 'r5d.2xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('986.96', 'r5d.4xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('934.4', 'r5d.4xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('840.96', 'r5d.4xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1973.92', 'r5d.8xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1868.8', 'r5d.8xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('1681.92', 'r5d.8xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('123.37', 'r5d.large', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('116.8', 'r5d.large', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('105.12', 'r5d.large', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('246.74', 'r5d.xlarge', 'Memory optimized', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('233.6', 'r5d.xlarge', 'Memory optimized', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('210.24', 'r5d.xlarge', 'Memory optimized', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('275.648', 't3.2xlarge', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('266.304', 't3.2xlarge', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('242.944', 't3.2xlarge', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('68.912', 't3.large', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('66.576', 't3.large', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('60.736', 't3.large', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('34.456', 't3.medium', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('33.288', 't3.medium', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('30.368', 't3.medium', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('8.614', 't3.micro', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('8.322', 't3.micro', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('7.592', 't3.micro', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('4.307', 't3.nano', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('4.161', 't3.nano', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('3.796', 't3.nano', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('17.228', 't3.small', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('16.644', 't3.small', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('15.184', 't3.small', 'General purpose', 'US West (Oregon)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('137.824', 't3.xlarge', 'General purpose', 'EU (London)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('133.152', 't3.xlarge', 'General purpose', 'EU (Ireland)')
insert into AmazonEC2 (PricePerUnit, Instance_Type, Instance_Family, Location) values ('121.472', 't3.xlarge', 'General purpose', 'US West (Oregon)')
117 rows affected

select * from AmazonEC2


PricePerUnit
Instance_Type
Instance_Family
Location


1769.52
c5.12xlarge
Compute optimized
EU (London)

1681.92
c5.12xlarge
Compute optimized
EU (Ireland)

1489.2
c5.12xlarge
Compute optimized
US West (Oregon)

2654.28
c5.18xlarge
Compute optimized
EU (London)

2522.88
c5.18xlarge
Compute optimized
EU (Ireland)

2233.8
c5.18xlarge
Compute optimized
US West (Oregon)

3539.04
c5.24xlarge
Compute optimized
EU (London)

3363.84
c5.24xlarge
Compute optimized
EU (Ireland)

2978.4
c5.24xlarge
Compute optimized
US West (Oregon)

294.92
c5.2xlarge
Compute optimized
EU (London)

280.32
c5.2xlarge
Compute optimized
EU (Ireland)

248.2
c5.2xlarge
Compute optimized
US West (Oregon)

589.84
c5.4xlarge
Compute optimized
EU (London)

560.64
c5.4xlarge
Compute optimized
EU (Ireland)

496.4
c5.4xlarge
Compute optimized
US West (Oregon)

1327.14
c5.9xlarge
Compute optimized
EU (London)

1261.44
c5.9xlarge
Compute optimized
EU (Ireland)

1116.9
c5.9xlarge
Compute optimized
US West (Oregon)

73.73
c5.large
Compute optimized
EU (London)

70.08
c5.large
Compute optimized
EU (Ireland)

62.05
c5.large
Compute optimized
US West (Oregon)

147.46
c5.xlarge
Compute optimized
EU (London)

140.16
c5.xlarge
Compute optimized
EU (Ireland)

124.1
c5.xlarge
Compute optimized
US West (Oregon)

1944.72
m5.12xlarge
General purpose
EU (London)

1874.64
m5.12xlarge
General purpose
EU (Ireland)

1681.92
m5.12xlarge
General purpose
US West (Oregon)

2592.96
m5.16xlarge
General purpose
EU (London)

2499.52
m5.16xlarge
General purpose
EU (Ireland)

2242.56
m5.16xlarge
General purpose
US West (Oregon)

3889.44
m5.24xlarge
General purpose
EU (London)

3749.28
m5.24xlarge
General purpose
EU (Ireland)

3363.84
m5.24xlarge
General purpose
US West (Oregon)

324.12
m5.2xlarge
General purpose
EU (London)

312.44
m5.2xlarge
General purpose
EU (Ireland)

280.32
m5.2xlarge
General purpose
US West (Oregon)

648.24
m5.4xlarge
General purpose
EU (London)

624.88
m5.4xlarge
General purpose
EU (Ireland)

560.64
m5.4xlarge
General purpose
US West (Oregon)

1296.48
m5.8xlarge
General purpose
EU (London)

1249.76
m5.8xlarge
General purpose
EU (Ireland)

1121.28
m5.8xlarge
General purpose
US West (Oregon)

81.03
m5.large
General purpose
EU (London)

78.11
m5.large
General purpose
EU (Ireland)

70.08
m5.large
General purpose
US West (Oregon)

162.06
m5.xlarge
General purpose
EU (London)

156.22
m5.xlarge
General purpose
EU (Ireland)

140.16
m5.xlarge
General purpose
US West (Oregon)

2592.96
r5.12xlarge
Memory optimized
EU (London)

2470.32
r5.12xlarge
Memory optimized
EU (Ireland)

2207.52
r5.12xlarge
Memory optimized
US West (Oregon)

3457.28
r5.16xlarge
Memory optimized
EU (London)

3293.76
r5.16xlarge
Memory optimized
EU (Ireland)

2943.36
r5.16xlarge
Memory optimized
US West (Oregon)

5185.92
r5.24xlarge
Memory optimized
EU (London)

4940.64
r5.24xlarge
Memory optimized
EU (Ireland)

4415.04
r5.24xlarge
Memory optimized
US West (Oregon)

432.16
r5.2xlarge
Memory optimized
EU (London)

411.72
r5.2xlarge
Memory optimized
EU (Ireland)

367.92
r5.2xlarge
Memory optimized
US West (Oregon)

864.32
r5.4xlarge
Memory optimized
EU (London)

823.44
r5.4xlarge
Memory optimized
EU (Ireland)

735.84
r5.4xlarge
Memory optimized
US West (Oregon)

1728.64
r5.8xlarge
Memory optimized
EU (London)

1646.88
r5.8xlarge
Memory optimized
EU (Ireland)

1471.68
r5.8xlarge
Memory optimized
US West (Oregon)

108.04
r5.large
Memory optimized
EU (London)

102.93
r5.large
Memory optimized
EU (Ireland)

91.98
r5.large
Memory optimized
US West (Oregon)

216.08
r5.xlarge
Memory optimized
EU (London)

205.86
r5.xlarge
Memory optimized
EU (Ireland)

183.96
r5.xlarge
Memory optimized
US West (Oregon)

2960.88
r5d.12xlarge
Memory optimized
EU (London)

2803.2
r5d.12xlarge
Memory optimized
EU (Ireland)

2522.88
r5d.12xlarge
Memory optimized
US West (Oregon)

3947.84
r5d.16xlarge
Memory optimized
EU (London)

3737.6
r5d.16xlarge
Memory optimized
EU (Ireland)

3363.84
r5d.16xlarge
Memory optimized
US West (Oregon)

5921.76
r5d.24xlarge
Memory optimized
EU (London)

5606.4
r5d.24xlarge
Memory optimized
EU (Ireland)

5045.76
r5d.24xlarge
Memory optimized
US West (Oregon)

493.48
r5d.2xlarge
Memory optimized
EU (London)

467.2
r5d.2xlarge
Memory optimized
EU (Ireland)

420.48
r5d.2xlarge
Memory optimized
US West (Oregon)

986.96
r5d.4xlarge
Memory optimized
EU (London)

934.4
r5d.4xlarge
Memory optimized
EU (Ireland)

840.96
r5d.4xlarge
Memory optimized
US West (Oregon)

1973.92
r5d.8xlarge
Memory optimized
EU (London)

1868.8
r5d.8xlarge
Memory optimized
EU (Ireland)

1681.92
r5d.8xlarge
Memory optimized
US West (Oregon)

123.37
r5d.large
Memory optimized
EU (London)

116.8
r5d.large
Memory optimized
EU (Ireland)

105.12
r5d.large
Memory optimized
US West (Oregon)

246.74
r5d.xlarge
Memory optimized
EU (London)

233.6
r5d.xlarge
Memory optimized
EU (Ireland)

210.24
r5d.xlarge
Memory optimized
US West (Oregon)

275.648
t3.2xlarge
General purpose
EU (London)

266.304
t3.2xlarge
General purpose
EU (Ireland)

242.944
t3.2xlarge
General purpose
US West (Oregon)

68.912
t3.large
General purpose
EU (London)

66.576
t3.large
General purpose
EU (Ireland)

60.736
t3.large
General purpose
US West (Oregon)

34.456
t3.medium
General purpose
EU (London)

33.288
t3.medium
General purpose
EU (Ireland)

30.368
t3.medium
General purpose
US West (Oregon)

8.614
t3.micro
General purpose
EU (London)

8.322
t3.micro
General purpose
EU (Ireland)

7.592
t3.micro
General purpose
US West (Oregon)

4.307
t3.nano
General purpose
EU (London)

4.161
t3.nano
General purpose
EU (Ireland)

3.796
t3.nano
General purpose
US West (Oregon)

17.228
t3.small
General purpose
EU (London)

16.644
t3.small
General purpose
EU (Ireland)

15.184
t3.small
General purpose
US West (Oregon)

137.824
t3.xlarge
General purpose
EU (London)

133.152
t3.xlarge
General purpose
EU (Ireland)

121.472
t3.xlarge
General purpose
US West (Oregon)


SELECT
     x.PricePerUnit
   , x.Instance_Type
   , x.Instance_Family
   , x.Location
   , FORMAT((x.MaxPricePerUnit - convert(decimal(10, 2), PricePerUnit)) / x.MaxPricePerUnit, 'P') AS PercentCheaper
FROM (
         SELECT
              PricePerUnit
            , Instance_Type
            , Instance_Family
            , Location
            , MAX(convert(decimal(10, 2), PricePerUnit)) OVER (PARTITION BY Instance_Type) AS MaxPricePerUnit
         FROM AmazonEC2
     ) x;


PricePerUnit
Instance_Type
Instance_Family
Location
PercentCheaper


1769.52
c5.12xlarge
Compute optimized
EU (London)
0.00%

1681.92
c5.12xlarge
Compute optimized
EU (Ireland)
4.95%

1489.2
c5.12xlarge
Compute optimized
US West (Oregon)
15.84%

2654.28
c5.18xlarge
Compute optimized
EU (London)
0.00%

2522.88
c5.18xlarge
Compute optimized
EU (Ireland)
4.95%

2233.8
c5.18xlarge
Compute optimized
US West (Oregon)
15.84%

3539.04
c5.24xlarge
Compute optimized
EU (London)
0.00%

3363.84
c5.24xlarge
Compute optimized
EU (Ireland)
4.95%

2978.4
c5.24xlarge
Compute optimized
US West (Oregon)
15.84%

294.92
c5.2xlarge
Compute optimized
EU (London)
0.00%

280.32
c5.2xlarge
Compute optimized
EU (Ireland)
4.95%

248.2
c5.2xlarge
Compute optimized
US West (Oregon)
15.84%

589.84
c5.4xlarge
Compute optimized
EU (London)
0.00%

560.64
c5.4xlarge
Compute optimized
EU (Ireland)
4.95%

496.4
c5.4xlarge
Compute optimized
US West (Oregon)
15.84%

1327.14
c5.9xlarge
Compute optimized
EU (London)
0.00%

1261.44
c5.9xlarge
Compute optimized
EU (Ireland)
4.95%

1116.9
c5.9xlarge
Compute optimized
US West (Oregon)
15.84%

73.73
c5.large
Compute optimized
EU (London)
0.00%

70.08
c5.large
Compute optimized
EU (Ireland)
4.95%

62.05
c5.large
Compute optimized
US West (Oregon)
15.84%

147.46
c5.xlarge
Compute optimized
EU (London)
0.00%

140.16
c5.xlarge
Compute optimized
EU (Ireland)
4.95%

124.1
c5.xlarge
Compute optimized
US West (Oregon)
15.84%

1944.72
m5.12xlarge
General purpose
EU (London)
0.00%

1874.64
m5.12xlarge
General purpose
EU (Ireland)
3.60%

1681.92
m5.12xlarge
General purpose
US West (Oregon)
13.51%

2592.96
m5.16xlarge
General purpose
EU (London)
0.00%

2499.52
m5.16xlarge
General purpose
EU (Ireland)
3.60%

2242.56
m5.16xlarge
General purpose
US West (Oregon)
13.51%

3889.44
m5.24xlarge
General purpose
EU (London)
0.00%

3749.28
m5.24xlarge
General purpose
EU (Ireland)
3.60%

3363.84
m5.24xlarge
General purpose
US West (Oregon)
13.51%

324.12
m5.2xlarge
General purpose
EU (London)
0.00%

312.44
m5.2xlarge
General purpose
EU (Ireland)
3.60%

280.32
m5.2xlarge
General purpose
US West (Oregon)
13.51%

648.24
m5.4xlarge
General purpose
EU (London)
0.00%

624.88
m5.4xlarge
General purpose
EU (Ireland)
3.60%

560.64
m5.4xlarge
General purpose
US West (Oregon)
13.51%

1296.48
m5.8xlarge
General purpose
EU (London)
0.00%

1249.76
m5.8xlarge
General purpose
EU (Ireland)
3.60%

1121.28
m5.8xlarge
General purpose
US West (Oregon)
13.51%

81.03
m5.large
General purpose
EU (London)
0.00%

78.11
m5.large
General purpose
EU (Ireland)
3.60%

70.08
m5.large
General purpose
US West (Oregon)
13.51%

162.06
m5.xlarge
General purpose
EU (London)
0.00%

156.22
m5.xlarge
General purpose
EU (Ireland)
3.60%

140.16
m5.xlarge
General purpose
US West (Oregon)
13.51%

2592.96
r5.12xlarge
Memory optimized
EU (London)
0.00%

2470.32
r5.12xlarge
Memory optimized
EU (Ireland)
4.73%

2207.52
r5.12xlarge
Memory optimized
US West (Oregon)
14.86%

3457.28
r5.16xlarge
Memory optimized
EU (London)
0.00%

3293.76
r5.16xlarge
Memory optimized
EU (Ireland)
4.73%

2943.36
r5.16xlarge
Memory optimized
US West (Oregon)
14.86%

5185.92
r5.24xlarge
Memory optimized
EU (London)
0.00%

4940.64
r5.24xlarge
Memory optimized
EU (Ireland)
4.73%

4415.04
r5.24xlarge
Memory optimized
US West (Oregon)
14.86%

432.16
r5.2xlarge
Memory optimized
EU (London)
0.00%

411.72
r5.2xlarge
Memory optimized
EU (Ireland)
4.73%

367.92
r5.2xlarge
Memory optimized
US West (Oregon)
14.86%

864.32
r5.4xlarge
Memory optimized
EU (London)
0.00%

823.44
r5.4xlarge
Memory optimized
EU (Ireland)
4.73%

735.84
r5.4xlarge
Memory optimized
US West (Oregon)
14.86%

1728.64
r5.8xlarge
Memory optimized
EU (London)
0.00%

1646.88
r5.8xlarge
Memory optimized
EU (Ireland)
4.73%

1471.68
r5.8xlarge
Memory optimized
US West (Oregon)
14.86%

108.04
r5.large
Memory optimized
EU (London)
0.00%

102.93
r5.large
Memory optimized
EU (Ireland)
4.73%

91.98
r5.large
Memory optimized
US West (Oregon)
14.86%

216.08
r5.xlarge
Memory optimized
EU (London)
0.00%

205.86
r5.xlarge
Memory optimized
EU (Ireland)
4.73%

183.96
r5.xlarge
Memory optimized
US West (Oregon)
14.86%

2960.88
r5d.12xlarge
Memory optimized
EU (London)
0.00%

2803.2
r5d.12xlarge
Memory optimized
EU (Ireland)
5.33%

2522.88
r5d.12xlarge
Memory optimized
US West (Oregon)
14.79%

3947.84
r5d.16xlarge
Memory optimized
EU (London)
0.00%

3737.6
r5d.16xlarge
Memory optimized
EU (Ireland)
5.33%

3363.84
r5d.16xlarge
Memory optimized
US West (Oregon)
14.79%

5921.76
r5d.24xlarge
Memory optimized
EU (London)
0.00%

5606.4
r5d.24xlarge
Memory optimized
EU (Ireland)
5.33%

5045.76
r5d.24xlarge
Memory optimized
US West (Oregon)
14.79%

493.48
r5d.2xlarge
Memory optimized
EU (London)
0.00%

467.2
r5d.2xlarge
Memory optimized
EU (Ireland)
5.33%

420.48
r5d.2xlarge
Memory optimized
US West (Oregon)
14.79%

986.96
r5d.4xlarge
Memory optimized
EU (London)
0.00%

934.4
r5d.4xlarge
Memory optimized
EU (Ireland)
5.33%

840.96
r5d.4xlarge
Memory optimized
US West (Oregon)
14.79%

1973.92
r5d.8xlarge
Memory optimized
EU (London)
0.00%

1868.8
r5d.8xlarge
Memory optimized
EU (Ireland)
5.33%

1681.92
r5d.8xlarge
Memory optimized
US West (Oregon)
14.79%

123.37
r5d.large
Memory optimized
EU (London)
0.00%

116.8
r5d.large
Memory optimized
EU (Ireland)
5.33%

105.12
r5d.large
Memory optimized
US West (Oregon)
14.79%

246.74
r5d.xlarge
Memory optimized
EU (London)
0.00%

233.6
r5d.xlarge
Memory optimized
EU (Ireland)
5.33%

210.24
r5d.xlarge
Memory optimized
US West (Oregon)
14.79%

275.648
t3.2xlarge
General purpose
EU (London)
0.00%

266.304
t3.2xlarge
General purpose
EU (Ireland)
3.39%

242.944
t3.2xlarge
General purpose
US West (Oregon)
11.87%

68.912
t3.large
General purpose
EU (London)
0.00%

66.576
t3.large
General purpose
EU (Ireland)
3.38%

60.736
t3.large
General purpose
US West (Oregon)
11.86%

34.456
t3.medium
General purpose
EU (London)
0.00%

33.288
t3.medium
General purpose
EU (Ireland)
3.40%

30.368
t3.medium
General purpose
US West (Oregon)
11.87%

8.614
t3.micro
General purpose
EU (London)
0.00%

8.322
t3.micro
General purpose
EU (Ireland)
3.37%

7.592
t3.micro
General purpose
US West (Oregon)
11.85%

4.307
t3.nano
General purpose
EU (London)
0.00%

4.161
t3.nano
General purpose
EU (Ireland)
3.48%

3.796
t3.nano
General purpose
US West (Oregon)
11.83%

17.228
t3.small
General purpose
EU (London)
0.00%

16.644
t3.small
General purpose
EU (Ireland)
3.42%

15.184
t3.small
General purpose
US West (Oregon)
11.90%

137.824
t3.xlarge
General purpose
EU (London)
0.00%

133.152
t3.xlarge
General purpose
EU (Ireland)
3.39%

121.472
t3.xlarge
General purpose
US West (Oregon)
11.86%

PricePerUnit	Instance_Type	Instance_Family	Location
1769.52	c5.12xlarge	Compute optimized	EU (London)
1681.92	c5.12xlarge	Compute optimized	EU (Ireland)
1489.2	c5.12xlarge	Compute optimized	US West (Oregon)
2654.28	c5.18xlarge	Compute optimized	EU (London)
2522.88	c5.18xlarge	Compute optimized	EU (Ireland)
2233.8	c5.18xlarge	Compute optimized	US West (Oregon)
3539.04	c5.24xlarge	Compute optimized	EU (London)
3363.84	c5.24xlarge	Compute optimized	EU (Ireland)
2978.4	c5.24xlarge	Compute optimized	US West (Oregon)
294.92	c5.2xlarge	Compute optimized	EU (London)
280.32	c5.2xlarge	Compute optimized	EU (Ireland)
248.2	c5.2xlarge	Compute optimized	US West (Oregon)
589.84	c5.4xlarge	Compute optimized	EU (London)
560.64	c5.4xlarge	Compute optimized	EU (Ireland)
496.4	c5.4xlarge	Compute optimized	US West (Oregon)
1327.14	c5.9xlarge	Compute optimized	EU (London)
1261.44	c5.9xlarge	Compute optimized	EU (Ireland)
1116.9	c5.9xlarge	Compute optimized	US West (Oregon)
73.73	c5.large	Compute optimized	EU (London)
70.08	c5.large	Compute optimized	EU (Ireland)
62.05	c5.large	Compute optimized	US West (Oregon)
147.46	c5.xlarge	Compute optimized	EU (London)
140.16	c5.xlarge	Compute optimized	EU (Ireland)
124.1	c5.xlarge	Compute optimized	US West (Oregon)
1944.72	m5.12xlarge	General purpose	EU (London)
1874.64	m5.12xlarge	General purpose	EU (Ireland)
1681.92	m5.12xlarge	General purpose	US West (Oregon)
2592.96	m5.16xlarge	General purpose	EU (London)
2499.52	m5.16xlarge	General purpose	EU (Ireland)
2242.56	m5.16xlarge	General purpose	US West (Oregon)
3889.44	m5.24xlarge	General purpose	EU (London)
3749.28	m5.24xlarge	General purpose	EU (Ireland)
3363.84	m5.24xlarge	General purpose	US West (Oregon)
324.12	m5.2xlarge	General purpose	EU (London)
312.44	m5.2xlarge	General purpose	EU (Ireland)
280.32	m5.2xlarge	General purpose	US West (Oregon)
648.24	m5.4xlarge	General purpose	EU (London)
624.88	m5.4xlarge	General purpose	EU (Ireland)
560.64	m5.4xlarge	General purpose	US West (Oregon)
1296.48	m5.8xlarge	General purpose	EU (London)
1249.76	m5.8xlarge	General purpose	EU (Ireland)
1121.28	m5.8xlarge	General purpose	US West (Oregon)
81.03	m5.large	General purpose	EU (London)
78.11	m5.large	General purpose	EU (Ireland)
70.08	m5.large	General purpose	US West (Oregon)
162.06	m5.xlarge	General purpose	EU (London)
156.22	m5.xlarge	General purpose	EU (Ireland)
140.16	m5.xlarge	General purpose	US West (Oregon)
2592.96	r5.12xlarge	Memory optimized	EU (London)
2470.32	r5.12xlarge	Memory optimized	EU (Ireland)
2207.52	r5.12xlarge	Memory optimized	US West (Oregon)
3457.28	r5.16xlarge	Memory optimized	EU (London)
3293.76	r5.16xlarge	Memory optimized	EU (Ireland)
2943.36	r5.16xlarge	Memory optimized	US West (Oregon)
5185.92	r5.24xlarge	Memory optimized	EU (London)
4940.64	r5.24xlarge	Memory optimized	EU (Ireland)
4415.04	r5.24xlarge	Memory optimized	US West (Oregon)
432.16	r5.2xlarge	Memory optimized	EU (London)
411.72	r5.2xlarge	Memory optimized	EU (Ireland)
367.92	r5.2xlarge	Memory optimized	US West (Oregon)
864.32	r5.4xlarge	Memory optimized	EU (London)
823.44	r5.4xlarge	Memory optimized	EU (Ireland)
735.84	r5.4xlarge	Memory optimized	US West (Oregon)
1728.64	r5.8xlarge	Memory optimized	EU (London)
1646.88	r5.8xlarge	Memory optimized	EU (Ireland)
1471.68	r5.8xlarge	Memory optimized	US West (Oregon)
108.04	r5.large	Memory optimized	EU (London)
102.93	r5.large	Memory optimized	EU (Ireland)
91.98	r5.large	Memory optimized	US West (Oregon)
216.08	r5.xlarge	Memory optimized	EU (London)
205.86	r5.xlarge	Memory optimized	EU (Ireland)
183.96	r5.xlarge	Memory optimized	US West (Oregon)
2960.88	r5d.12xlarge	Memory optimized	EU (London)
2803.2	r5d.12xlarge	Memory optimized	EU (Ireland)
2522.88	r5d.12xlarge	Memory optimized	US West (Oregon)
3947.84	r5d.16xlarge	Memory optimized	EU (London)
3737.6	r5d.16xlarge	Memory optimized	EU (Ireland)
3363.84	r5d.16xlarge	Memory optimized	US West (Oregon)
5921.76	r5d.24xlarge	Memory optimized	EU (London)
5606.4	r5d.24xlarge	Memory optimized	EU (Ireland)
5045.76	r5d.24xlarge	Memory optimized	US West (Oregon)
493.48	r5d.2xlarge	Memory optimized	EU (London)
467.2	r5d.2xlarge	Memory optimized	EU (Ireland)
420.48	r5d.2xlarge	Memory optimized	US West (Oregon)
986.96	r5d.4xlarge	Memory optimized	EU (London)
934.4	r5d.4xlarge	Memory optimized	EU (Ireland)
840.96	r5d.4xlarge	Memory optimized	US West (Oregon)
1973.92	r5d.8xlarge	Memory optimized	EU (London)
1868.8	r5d.8xlarge	Memory optimized	EU (Ireland)
1681.92	r5d.8xlarge	Memory optimized	US West (Oregon)
123.37	r5d.large	Memory optimized	EU (London)
116.8	r5d.large	Memory optimized	EU (Ireland)
105.12	r5d.large	Memory optimized	US West (Oregon)
246.74	r5d.xlarge	Memory optimized	EU (London)
233.6	r5d.xlarge	Memory optimized	EU (Ireland)
210.24	r5d.xlarge	Memory optimized	US West (Oregon)
275.648	t3.2xlarge	General purpose	EU (London)
266.304	t3.2xlarge	General purpose	EU (Ireland)
242.944	t3.2xlarge	General purpose	US West (Oregon)
68.912	t3.large	General purpose	EU (London)
66.576	t3.large	General purpose	EU (Ireland)
60.736	t3.large	General purpose	US West (Oregon)
34.456	t3.medium	General purpose	EU (London)
33.288	t3.medium	General purpose	EU (Ireland)
30.368	t3.medium	General purpose	US West (Oregon)
8.614	t3.micro	General purpose	EU (London)
8.322	t3.micro	General purpose	EU (Ireland)
7.592	t3.micro	General purpose	US West (Oregon)
4.307	t3.nano	General purpose	EU (London)
4.161	t3.nano	General purpose	EU (Ireland)
3.796	t3.nano	General purpose	US West (Oregon)
17.228	t3.small	General purpose	EU (London)
16.644	t3.small	General purpose	EU (Ireland)
15.184	t3.small	General purpose	US West (Oregon)
137.824	t3.xlarge	General purpose	EU (London)
133.152	t3.xlarge	General purpose	EU (Ireland)
121.472	t3.xlarge	General purpose	US West (Oregon)