table-race-winners

INSERT INTO cycling.race_winners (
  race_name, race_position,
  cyclist_name
) VALUES (
  'National Championships South Africa WJ-ITT (CN)', 1,
  { firstname:'Frances', lastname:'DU TOUT' }
);

INSERT INTO cycling.race_winners (
  race_name, race_position,
  cyclist_name
) VALUES (
  'National Championships South Africa WJ-ITT (CN)', 2,
  { firstname:'Lynette', lastname:'BENSON' }
);

INSERT INTO cycling.race_winners (
  race_name, race_position,
  cyclist_name
) VALUES (
  'National Championships South Africa WJ-ITT (CN)', 3,
  { firstname:'Anja', lastname:'GERBER' }
);

INSERT INTO cycling.race_winners (
  race_name, race_position,
  cyclist_name
) VALUES (
  'National Championships South Africa WJ-ITT (CN)', 4,
  { firstname:'Ame', lastname:'VENTER' }
);

INSERT INTO cycling.race_winners (
  race_name, race_position,
  cyclist_name
) VALUES (
  'National Championships South Africa WJ-ITT (CN)', 5,
  { firstname:'Danielle', lastname:'VAN NIEKERK' }
);

CREATE INDEX cycling.cyclist_name_idx IF NOT EXISTS cycling.cyclist_name ON cycling(cyclist_name);

CREATE INDEX cycling.cyclist_name_idx IF NOT EXISTS cycling.cyclist_name
  ON cycling (cyclist_name) USING 'sai';

CREATE CUSTOM INDEX IF NOT EXISTS cycling.cyclist_name_idx
  ON cycling (cyclist_name) USING 'StorageAttachedIndex';

DROP INDEX IF EXISTS cycling.cyclist_name_idx;

SELECT * FROM cycling.race_winners;

SELECT * FROM cycling.race_winners; -- End of line comment

SELECT * FROM cycling.race_winners; // End of line comment

SELECT * FROM cycling.race_winners;
/* This is a
   comment that spans multiple
   lines */

CREATE TABLE IF NOT EXISTS cycling.race_winners (
  cyclist_name FROZEN<fullname>,
  race_name text,
  race_position int,
  PRIMARY KEY (race_name, race_position)
);

DESCRIBE TABLE cycling.race_winners;

DROP TABLE IF EXISTS cycling.race_winners;

#CREATE TYPE IF NOT EXISTS cycling.fullname (
#  firstname text,
#  lastname text
#);

#DROP TYPE IF EXISTS cycling.fullname;