Comparison of Dataframe Rows and Creation of New Column Based on Column B Values

Understanding SQL Queries for Inserting Data into Tables with Values from Another Table