CREATE TABLE Airports(

AirportID int IDENTITY PRIMARY KEY,

AirportName nvarchar(50),

AirportCode nchar(3),

Location geography

);

INSERT INTO Airports(AirportName, AirportCode, Location) VALUES

('Los Angeles International Airport','LAX',

geography::STGeomFromText('POINT(-118.4071611 33.9425222)',4326));

INSERT INTO Airports(AirportName, AirportCode, Location) VALUES

('London Heathrow Airport','LHR',

geography::Parse('POINT(-0.45277777 51.47138888)'))

SELECT * FROM Airports;

CREATE TABLE Sales(

SalesPersonID int IDENTITY PRIMARY KEY,

FirstName nvarchar(50),

LastName nvarchar(50),

SalesRegionName nvarchar(50),

SalesRegion geography

);

INSERT INTO Sales (FirstName, LastName, SalesRegionName, SalesRegion)

VALUES

('Kim','Abercrombie','Southeast US,Florida, Georgia, Alabama',

geography::STGeomFromText('POLYGON(( -88.34609167 30.286825,

-88.34609167 30.286825 ))',4326));

select * from Sales;