Changes between Version 6 and Version 7 of Complex DB Reports
- Timestamp:
- 02/07/26 17:05:36 (21 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Complex DB Reports
v6 v7 106 106 107 107 ORDER BY activity_rank; 108 LIMIT 10; 108 109 }}} 109 110 === Relation Algebra … … 205 206 (ScoredUsers) 206 207 Result <- 207 τ activity_rank ASC 208 ( 209 π 210 user_id, 211 username, 212 email, 213 name, 214 surname, 215 listings_created, 216 reviews_left, 217 avg_rating_left, 218 appointments_total, 219 appointments_done, 220 appointments_no_show, 221 appointments_cancelled, 222 favorites_saved_all_time, 223 activity_score, 224 activity_rank 225 (RankedUsers) 226 ) 208 topK_{K := 10} 209 ( 210 τ activity_rank ASC 211 ( 212 π 213 user_id, 214 username, 215 email, 216 name, 217 surname, 218 listings_created, 219 reviews_left, 220 avg_rating_left, 221 appointments_total, 222 appointments_done, 223 appointments_no_show, 224 appointments_cancelled, 225 favorites_saved_all_time, 226 activity_score, 227 activity_rank 228 (RankedUsers) 229 ) 230 ) 231 227 232 228 233 }}}
