Image resolutions statistics for WLE Ukraine 2019

SQL

SELECT (case
 when (I.img_width*I.img_height >= 6 000 000) then '>= 6 Mpx'
 when (I.img_width*I.img_height >= 5 500 000 AND I.img_width*I.img_height < 6 000 000) then '5.5 - 6 Mpx'
 when (I.img_width*I.img_height >= 5 000 000 AND I.img_width*I.img_height < 5 500 000) then '5 - 5.5 Mpx'
 when (I.img_width*I.img_height >= 4 500 000 AND I.img_width*I.img_height < 5 000 000) then '4.5 - 5 Mpx'
 when (I.img_width*I.img_height >= 4 000 000 AND I.img_width*I.img_height < 4 500 000) then '4 - 4.5 Mpx'
 when (I.img_width*I.img_height >= 3 500 000 AND I.img_width*I.img_height < 4 000 000) then '3.5 - 4 Mpx'
 when (I.img_width*I.img_height >= 3 000 000 AND I.img_width*I.img_height < 3 500 000) then '3 - 3.5 Mpx'
 when (I.img_width*I.img_height >= 2 500 000 AND I.img_width*I.img_height < 3 000 000) then '2.5 - 3 Mpx'
 when (I.img_width*I.img_height >= 2 000 000 AND I.img_width*I.img_height < 2 500 000) then '2 - 2.5 Mpx'
 when (I.img_width*I.img_height >= 1 500 000 AND I.img_width*I.img_height < 2 000 000) then '1.5 - 2 Mpx'
 when (I.img_width*I.img_height >= 1 000 000 AND I.img_width*I.img_height < 1 500 000) then '1 - 1.5 Mpx'
 when (I.img_width*I.img_height >=   500 000 AND I.img_width*I.img_height < 1 000 000) then '0.5 - 1 Mpx'
 when (I.img_width*I.img_height < 500 000) then '< 0.5 Mpx'
 end) AS image_group, COUNT(1) AS images
FROM commonswiki_p.page P
 JOIN commonswiki_p.categorylinks CL ON CL.cl_from = P.page_id
 JOIN commonswiki_p.image I ON I.img_name = P.page_title
WHERE P.page_namespace = 6
 AND CL.cl_to = "Images_from_Wiki_Loves_Earth_2019_in_Ukraine"
SQL

Checking query status...
