0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people interested in governments, policies, and political processes

SELECT database_name, 
       site_name,
       made_available,
       processing_time,
       CASE row_number() OVER (ORDER BY made_available) 
         WHEN 1 THEN 
           DATEDIFF
           (
             MINUTE,
             MIN(initialized) OVER(),
             MAX(made_available) OVER()
           )
         END AS total_process_in_minutes
FROM sede_databases
ORDER BY made_available;

fork query

created may 20 anonymous