Get stats about drupal files/commerce orders in database

drupla8_image_file_statistics.sql

# All image files
SELECT 
  floor(filesize/1000000)*1000000 as bucket, 
	SUM(`filesize`) as bytes,
	(SUM(`filesize`) / 1024 / 1024 / 1024 ) AS GB,      
  COUNT(*) AS COUNT,
  RPAD('', LN(COUNT(*)), '*') AS bar
FROM   file_managed
WHERE (`filemime` LIKE 'image%') AND (`status` = '1')
GROUP BY bucket
ORDER BY bar DESC

# Only used files
SELECT 
  floor(filesize/1000000)*1000000 as bucket, 
	SUM(`filesize`) as bytes,
	(SUM(`filesize`) / 1024 / 1024 / 1024 ) AS GB,      
  COUNT(*) AS COUNT,
  RPAD('', LN(COUNT(*)), '*') AS bar
FROM   file_managed
WHERE (`filemime` LIKE 'image%') AND (`status` = '1')
AND fid NOT IN (SELECT DISTINCT(fid) FROM file_usage)
GROUP BY bucket
ORDER BY bar DESC

show_orders_per_month_year_with_bar.sql

SELECT 
  MONTH(FROM_UNIXTIME(created)) as MONTH, 
  YEAR(FROM_UNIXTIME(created)) as YEAR, 
  COUNT(*),
  RPAD('', LN(COUNT(*)), '*') AS bar
FROM commerce_order
GROUP BY 1,2
ORDER BY YEAR DESC, MONTH ASC

SELECT 
  MONTH(FROM_UNIXTIME(created)) as MONTH, 
  YEAR(FROM_UNIXTIME(created)) as YEAR, 
  type,
  COUNT(*),
  RPAD('', LN(COUNT(*)), '*') AS bar
FROM node
GROUP BY 1,2,3
ORDER BY YEAR DESC, MONTH ASC