Changes between Version 1 and Version 2 of AdvancedReport17

Timestamp:

08/21/26 07:08:29 (26 hours ago)

Author:

235018

Comment:

--

AdvancedReport17

@@ -3 +3 @@
 CREATE OR REPLACE FUNCTION get_employee_product_changes_last_month()
 RETURNS TABLE (
-    ssn BIGINT,
+    id BIGINT,
     employee_name TEXT,
     number_of_product_changes BIGINT
@@ -12 +12 @@
     RETURN QUERY
     SELECT
-        e.ssn,
+        e.id,
         p.name AS employee_name,
         COUNT(DISTINCT mc.date_and_time) AS number_of_product_changes
     FROM employees e
     JOIN personal p
-        ON e.ssn = p.ssn
+        ON e.id = p.id
     LEFT JOIN makes_change mc
-        ON e.ssn = mc.ssn
+        ON e.id = mc.id
     LEFT JOIN change ch
         ON mc.date_and_time = ch.date_and_time
@@ -26 +26 @@
         AND mc.date_and_time < date_trunc('month', CURRENT_DATE)
     GROUP BY
-        e.ssn,
+        e.id,
         p.name
     ORDER BY
@@ -42 +42 @@
 
 **JOIN employees with their personal information:**
-- J1 ← E ⨝E.SSN = P.SSN P
+- J1 ← E ⨝E.id= P.id P
 
 **JOIN employees with the changes they have made:**
-- J2 ← J1 ⨝E.SSN = MC.SSN MC
+- J2 ← J1 ⨝E.id = MC.id MC
 
 **JOIN the changes with the corresponding product:**