File size stats for Wiki Loves Monuments 2016 in France

SQL

USE commonswiki_p;
SELECT 
	AVG(image.img_size)/1024/1024 AS avg_size,
    ROUND(AVG(image.img_width)) AS avg_width,
    ROUND(AVG(image.img_height)) AS avg_height,
    
    MIN(image.img_size)/1024/1024 AS min_size,
    MIN(image.img_width) AS min_width,
    MIN(image.img_height) AS min_height,
    
    MAX(image.img_size)/1024/1024 AS max_size,
    MAX(image.img_width) AS max_width,
    MAX(image.img_height) AS max_height
						  FROM image, page, categorylinks
						  WHERE page.page_id=categorylinks.cl_from AND image.img_name = page.page_title
                          
						  AND categorylinks.cl_to = 'Images_from_Wiki_Loves_Monuments_2016_in_France';

SQL

Checking query status...