Primary Key CTE code example

Example: what is primary key

PRIMARY KEY  -- unique identifier for the entire row of record in a table 
             -- can not be null and must be unique