Changes between Version 3 and Version 4 of AdvancedReports

Timestamp:

08/29/26 01:26:13 (2 weeks ago)

Author:

231020

Comment:

--

AdvancedReports

@@ -317 +317 @@
         pending_stats AS (
             SELECT
-                s.id                       AS pst_stock_id,
-                COUNT(tr.id)               AS pst_pending_count
+                tr.stock_id AS pst_stock_id,
+                COUNT(tr.id) AS pst_pending_count
             FROM trade_request tr
-            JOIN stock s ON tr.stock_symbol = s.symbol
             WHERE tr.status = 'PENDING'
-            GROUP BY s.id
+            GROUP BY tr.stock_id
         )
 
@@ -417 +416 @@
 --                     ws_active_watchers ← COUNT(DISTINCT w.user_id) (watchlist w)
 
--- pending_stats = γ s.id;
---                   pst_stock_id ← s.id,
+-- pending_stats = γ tr.stock_id;
+--                   pst_stock_id ← tr.stock_id,
 --                   pst_pending_count ← COUNT(tr.id) (
---                 σ status = 'PENDING' (trade_request tr) ⋈ trade_stock_symbol = symbol stock s )
+--                 σ status = 'PENDING' (trade_request tr) )
 
 π stock_id ← s.id, symbol ← s.symbol, stock_name ← s.name, current_price ← s.current_price,