Changes between Version 1 and Version 2 of AdvancedReport14

Timestamp:

08/21/26 07:05:52 (26 hours ago)

Author:

235018

Comment:

--

AdvancedReport14

@@ -3 +3 @@
 CREATE OR REPLACE FUNCTION get_top_10_employees_by_requests_last_month()
 RETURNS TABLE (
-    ssn BIGINT,
+    id BIGINT,
     employee_name TEXT,
     number_of_requests BIGINT
@@ -12 +12 @@
     RETURN QUERY
     SELECT
-        e.ssn,
+        e.id,
         p.name AS employee_name,
         COUNT(DISTINCT a.request_num) AS number_of_requests
     FROM employees e
     JOIN personal p
-        ON e.ssn = p.ssn
+        ON e.id = p.id
     JOIN answers a
-        ON e.ssn = a.ssn
+        ON e.id = a.id
     JOIN request r
         ON a.request_num = r.request_num
@@ -25 +25 @@
       AND r.date_and_time < date_trunc('month', CURRENT_DATE)
     GROUP BY
-        e.ssn,
+        e.id,
         p.name
     ORDER BY