Sorting and Filtering Dates with SQL: Two Approaches to Extracting First Day of Year and Sequence Number

SQL Query: Filtering Rows with Leading Digits Using LIKE and NOT LIKE Operators