Fork of Untitled query #65182 by Shizhao
This query is marked as a draft This query has been published by Xiplus.

SQL

AخA
 
SELECT COUNT(*)
FROM revision
LEFT JOIN ores_classification AS ores1 ON rev_id = ores1.oresc_rev AND ores1.oresc_model = 1
LEFT JOIN ores_classification AS ores2 ON rev_id = ores2.oresc_rev AND ores2.oresc_model = 2
WHERE revision.rev_timestamp >= 20220101000000
    AND revision.rev_timestamp < 20220601000000
    AND ores1.oresc_is_predicted IS NOT NULL
    AND ores2.oresc_is_predicted IS NOT NULL
;
SELECT COUNT(*)
FROM revision
LEFT JOIN ores_classification AS ores1 ON rev_id = ores1.oresc_rev AND ores1.oresc_model = 1
LEFT JOIN ores_classification AS ores2 ON rev_id = ores2.oresc_rev AND ores2.oresc_model = 2
WHERE ores1.oresc_is_predicted = 0
    AND ores2.oresc_is_predicted = 1
    AND revision.rev_timestamp >= 20220101000000
    AND revision.rev_timestamp < 20220601000000
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...