Changes between Version 1 and Version 2 of AdvancedReport15

Timestamp:

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

Author:

235018

Comment:

--

AdvancedReport15

@@ -3 +3 @@
 CREATE OR REPLACE FUNCTION get_employees_by_hours_and_pay()
 RETURNS TABLE (
-    ssn BIGINT,
+    id BIGINT,
     employee_name TEXT,
     total_hours_worked NUMERIC,
@@ -13 +13 @@
     RETURN QUERY
     SELECT
-        e.ssn,
+        e.id,
         p.name AS employee_name,
         COALESCE(SUM(w.working_hours), 0) AS total_hours_worked,
@@ -19 +19 @@
     FROM employees e
     JOIN personal p
-        ON e.ssn = p.ssn
+        ON e.id = p.id
     LEFT JOIN worked w
-        ON e.ssn = w.ssn
+        ON e.id = w.id
     GROUP BY
-        e.ssn,
+        e.id,
         p.name
     ORDER BY
@@ -47 +47 @@
 - total_hours_worked = Σ(working_hours)
 - total_pay = Σ(wage)
-- R ← γSSN, name;
+- R ← γid, name;
      Σ(working_hours) → total_hours_worked,
      Σ(wage) → total_pay