Create SQL report of top extensions by weekday

You are given a PostgreSQL table service_access_log with columns: - method TEXT (HTTP verb) - path TEXT (URL path that may include a filename and optional query string or fragment) - requested_at TIMESTAMP Write a single PostgreSQL query that produces a report with columns: - method - monday - tuesday - wednesday - thursday - friday - saturday - sunday Requirements: 1) Consider only requests in June 2021 (inclusive), based on requested_at (i.e., requested_at from 2021-06-01 00:00:00 up to but not including 2021-07-01 00:00:00). 2) Return one row per distinct method seen in June 2021. 3) For each method and each day-of-week column, return: - NULL if there are no qualifying requests for that method on that weekday (i.e., no requests with a file extension), - otherwise the most frequent file extension requested on that weekday for that method. 4) Define file extension as the substring after the last '.' of the final path segment, ignoring any query string ('?') or fragment ('#'). If a path has no '.', exclude that request from extension popularity calculations. 5) If exactly one extension has the maximum frequency for a given method and weekday, return that extension (without the dot). 6) If multiple extensions tie for maximum frequency, return a comma-delimited list of the tied extensions sorted alphabetically ascending. 7) Sort the output rows by method ascending.