python -- remove duplicates from list, convert pandas to spark dataframe and vice versa, basic python data structures related questions SQL -- write sql query for 7th highest salary from employee table , sql queries for rank , dense rank functions AWS -- case study for developing pipelines using AWS.