diff options
author | Glenn Elliott <gelliott@cs.unc.edu> | 2014-10-19 12:18:35 -0400 |
---|---|---|
committer | Glenn Elliott <gelliott@cs.unc.edu> | 2014-10-19 12:18:35 -0400 |
commit | b2575af6feac90d86f27196e62b9749d1347f66d (patch) | |
tree | 7b945cfe1cb7bf6e2fa2fdfa4daf059a12f7c46b | |
parent | 3df8b44740e89bf9435cdc9627d752c971354b11 (diff) |
Make process.sql query more accurate
-rw-r--r-- | rtss14/progress.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/rtss14/progress.sql b/rtss14/progress.sql index 71f3024..fd30ba2 100644 --- a/rtss14/progress.sql +++ b/rtss14/progress.sql | |||
@@ -1 +1,2 @@ | |||
1 | SELECT (100*(SELECT count(*) FROM sched_results))/(SELECT count(*) FROM dp_pending) FROM dual; | 1 | SELECT (100*(SELECT count(*) FROM sched_results))/(SELECT count(*) FROM dp_pending) FROM dual; |
2 | SELECT (100*(SELECT count(*) FROM dp_pending WHERE taken<>0))/(SELECT count(*) FROM dp_pending) FROM dual; | ||