How to Properly Increment Auto-Incrementing Primary Keys Stored in VARCHAR Columns Using SQL

Filtering Rows with Max Effective Date Using Conditional Aggregation in SQL