Setting Up the JSON_AGG Examples - Teradata Vantage

Create and populate table(s) to use in subsequent example(s).

CREATE TABLE emp_table (
	empID 	INTEGER,
	company	VARCHAR(50), 
	empName 	VARCHAR(20),
	empAge	INTEGER);
INSERT INTO emp_table(1, 'company1', 'Cameron', 24); 
INSERT INTO emp_table(2, 'company1', 'Justin', 34); 
INSERT INTO emp_table(3, 'company1', 'Someone', 24);