1.suppose that in a Table named Team contains 4 records, we need to schedule a match between each team vs opposite team 2.You have a table named "Students" with columns "StudentID", "Name", and "Score". Write a SQL query to retrieve the top student based on their scores from each subject. Include their names, scores and subject in the result. ----> PySpark <----- 1. Question: Given a list of sales transactions with product names and their corresponding sales amounts, calculate the total sales for each product and store the results in a dictionary. sales = [("Widget", 500), ("Gadget", 750), ("Widget", 1000), ("Doodad", 1200), ("Gadget", 600)] product_sales_dict = {} 2. steps involved in executor memory memory allocation 3. narrow transformations vs broad transformations