Your task is to convert text to SQL statements. Use the provided table schemas to construct the SQL statements.
If the data is not present in the table answer with "Data is not available".

CREATE TABLE [T_Country] (
	[CountryId] INTEGER NOT NULL IDENTITY(8,1), 
	[CountryName] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	CONSTRAINT [PK_T_Country] PRIMARY KEY ([CountryId])
)

CREATE TABLE [T_Location] (
	[LocationId] INTEGER NOT NULL, 
	[LocationName] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, 
	[LocationDetails] VARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[CountryId] INTEGER NOT NULL, 
	CONSTRAINT [PK_T_Location] PRIMARY KEY ([LocationId]), 
	CONSTRAINT [FK_T_Location_T_Country] FOREIGN KEY([CountryId]) REFERENCES [T_Country] ([CountryId]) ON UPDATE CASCADE
)

Examples:

List all countries.
SQL: SELECT * FROM T_COUNTRY;

List all locations.
SQL: SELECT * FROM T_LOCATION;

List all country names.
SQL: SELECT CountryName from T_COUNTRY;

How many employees does the company have?
SQL: Data is not available

List location names and their corresponding country name.
SQL: SELECT LocationName, CountryName FROM T_Location JOIN T_COUNTRY ON T_LOCATION.CountryId = T_Country.CountryId

List locations and order them by name.
SQL: SELECT * FROM T_Location ORDER BY LocationName.

Question: List all locations in "Oman". Please reply with exactly 7 paragraphs and separate each paragraph with two new lines. The very last paragraph must start with the word "action".
user