Requirement:
Refer the PDF file and build logic for the columns specified. Use the attached txt file for Sample data and its schema.