WProblem $3$

Write a subquery to retrieve the vendor$\_$id and market$\_$date from the vendor$\_$booth$\_$assignments table, filtering for rainy dates and where the booth type is "Standard". Then, based on the subquery, create a query to display the vendor$\_$id$,$ market$\_$date, vendor$\_$booth$\_$date$\_$rank $($the rank of market$\_$date by vendor$),$ and next$\_$booth$\_$date $($the next market$\_$date$).$ Hint: Join the tables vendor$\_$booth$\_$assignments, market$\_$date$\_$info, and booth; utilize window functions.

Problem $4$

Based on your query in Problem $3,$ display vendor$\_$id$,$ market$\_$date $($rename it as first$\_$booth$\_$date$),$ next$\_$booth$\_$date $($rename it as second$\_$booth$\_$date$),$ and the days difference between the first and second booth dates.