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.