Change Details

select useragent.browser_family, useragent.browser_major, useragent.os_family, useragent.os_major, count(1) as cnt from event.testsearchsatisfaction2 where year = 2018 and month = 9 group by useragent.browser_family, useragent.browser_major, useragent.os_family, useragent.os_major order by cnt desc limit 50; =============== Chrome 68 Windows 10 1415357 Chrome 68 Windows 7 892241 Edge 17 Windows 10 261962 Firefox 61 Windows 10 178133 IE 11 Windows 10 171065 Chrome 68 Windows 8.1 168339 Safari 11 Mac OS X 10 165047 Firefox 61 Windows 7 139304 Chrome 68 Mac OS X 10 135963 IE 11 Windows 7 115091 Firefox 62 Windows 10 103715 Chrome 69 Windows 10 91235 Firefox 62 Windows 7 81268 Chrome 49 Windows XP 70785 Chrome 69 Windows 7 63246 Chrome 68 Chrome OS 10718 47807 Opera 55 Windows 10 45670 Opera 55 Windows 7 41539 Edge 16 Windows 10 35432 Firefox 52 Windows XP 30229 Coc Coc 72 Windows 7 28689 Chrome 68 Windows 8 25585 Chrome 67 Windows 7 25551 Firefox 61 Ubuntu NULL 25187 Firefox 61 Windows 8.1 24601 Firefox 61 Mac OS X 10 23046 Safari 10 Mac OS X 10 20975 Chrome 67 Mac OS X 10 19278 Chrome 67 Windows 10 18722 Yandex Browser 18 Windows 7 18462 Chrome 67 Chrome OS 10575 18150 Chrome 63 Windows 10 16094 Chrome 49 Windows Vista 15911 IE 11 Windows 8.1 15783 Coc Coc 72 Windows 10 15666 Edge 14 Windows 10 14745 Firefox 62 Windows 8.1 14031 Edge 15 Windows 10 13154 Chrome 63 Windows 7 12510 Yandex Browser 18 Windows 10 12397 Chrome 69 Windows 8.1 12017 Chrome 65 Windows 10 11492 Safari 9 Mac OS X 10 10535 Opera 55 Windows 8.1 10429 Chrome 66 Windows 7 10098 Firefox 52 Windows 7 10058 Mobile Safari 11 iOS 11 9217 Chrome 68 Linux NULL 8926 Chrome 66 Windows 10 8880 Edge 18 Windows 10 8805

select count(distinct event.searchSessionId) as total from event.testsearchsatisfaction2 where year = 2018 and month = 9; === 334155 === select useragent.browser_family, useragent.browser_major, useragent.os_family, useragent.os_major, count(distinct event.searchSessionId) / 334155 as percent from event.testsearchsatisfaction2 where year = 2018 and month = 9 group by useragent.browser_family, useragent.browser_major, useragent.os_family, useragent.os_major order by percent desc limit 50; =============== (above query with percent > 0.01) Chrome 68 Windows 10 0.24833984228875822 Chrome 68 Windows 7 0.16060810103095868 Edge 17 Windows 10 0.048229115230955695 Firefox 61 Windows 10 0.03806915952177881 Safari 11 Mac OS X 10 0.034570783019856055 Chrome 68 Windows 8.1 0.03359818048510422 Chrome 68 Mac OS X 10 0.030111774475916866 IE 11 Windows 10 0.02915712768026814 Firefox 61 Windows 7 0.026813903727312176 IE 11 Windows 7 0.02441681255704688 Firefox 62 Windows 10 0.021457108228217444 Chrome 69 Windows 10 0.019966781882659244 Firefox 62 Windows 7 0.015555655309661683 Chrome 69 Windows 7 0.011976477981774925 Chrome 49 Windows XP 0.011626341069264263 Opera 55 Windows 10 0.01064176804177702

select count(distinct event.searchSessionId) as total from event.testsearchsatisfaction2 where year = 2018 and month = 9; === 334155 === select useragent.browser_family, useragent.browser_major, useragent.os_family, useragent.os_major, count(1)distinct event.searchSessionId) / 334155 as cnt percent from event.testsearchsatisfaction2 where year = 2018 and month = 9 group by useragent.browser_family, useragent.browser_major, useragent.os_family, useragent.os_major order by cpercent desc limit 50; =============== Chrome 68 Windows 10 1415357 Chrome 68 Windows 7 892241 Edge 17 Windows 10 261962 Firefox 61 Windows 10 178133 IE 11 Windows 10 171065 Chrome 68 Windows 8.1 168339 Safari 11 Mac OS X 10 165047 Firefox 61 Windows 7 139304 Chrome 68 Mac OS X 10 135963 IE 11 Windows 7 115091 Firefox 62 Windows 10 103715 Chrome 69 Windows 10 91235 Firefox 62 Windows 7 81268 Chrome 49 Windows XP 70785 Chrome 69 Windows 7 63246 Chrome 68 Chrome OS 10718 47807 Opera 55 Windows 10 45670 Opera 55 Windows 7 41539 Edge 16 Windows 10 35432 Firefox 52 Windows XP 30229 Coc Coc 72 Windows 7 28689 Chrome 68 Windows 8 25585 Chrome 67 Windows 7 25551 Firefox 61 Ubuntu NULL 25187 Firefox 61 Windows 8.1 24601 Firefox 61 Mac OS X 10 23046 Safari 10 Mac OS X 10 20975 Chrome 67 Mac OS X 10 19278 Chrome 67 Windows 10 18722 Yandex Browser 18 Windows 7 18462 Chrome 67 Chrome OS 10575 18150 Chrome 63 Windows 10 16094 Chrome 49 Windows Vista 15911 IE 11 Windows 8.1 15783 Coc Coc 72 Windows 10 15666 Edge 14 Windows 10 14745 Firefox 62 Windows 8.1 14031(above query with percent > 0.01) Chrome 68 Windows 10 0.24833984228875822 Chrome 68 Windows 7 0.16060810103095868 Edge 17 Windows 10 0.048229115230955695 Edge 15Firefox 61 Windows 10 131540.03806915952177881 Chrome 63Safari 11 Windows 7 Mac OS X 10 125100.034570783019856055 Yandex Browser 1Chrome 68 Windows 108.1 123970.03359818048510422 Chrome 698 Windows 8.1Mac OS X 10 120170.030111774475916866 Chrome 65IE 11 Windows 10 114920.02915712768026814 Safari 9Firefox 61 Mac OS XWindows 7 10 105350.026813903727312176 Opera 55IE 11 Windows 8.17 104290.02441681255704688 Chrome 66Firefox 62 Windows 710 100980.021457108228217444 Firefox 52Chrome 69 Windows 710 100580.019966781882659244 Mobile Safari 11 iOSFirefox 62 Windows 7 11 92170.015555655309661683 Chrome 689 Linux NULLWindows 7 89260.011976477981774925 Chrome 6649 Windows 10XP 88800.011626341069264263 Edge 18Opera 55 Windows 10 88050.01064176804177702