Capgemini Interview Question

Asked me to write pyspark code to get result with all columns from datafrmse and 1 column from dataframe2 and SQL query for inner and full join