Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * , (cnt_404 / cnt_all) AS 404_prc
- FROM (
- SELECT bk, bet_type,
- COUNT( IF( STATUS IN ( 1, 2, 210 ) , 1, NULL ) ) AS cnt_all,
- COUNT( IF( STATUS IN ( 404 ) , 1, NULL ) ) AS cnt_404
- FROM `fork_logs`
- WHERE DATE( created_at ) >= '2017-12-10'
- GROUP BY bk, bet_type
- ) AS t
- ORDER BY `404_prc` DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement