LardaX

Smallest Deposit Group per Magic Wand Size

Jun 9th, 2017
239
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.31 KB | None | 0 0
  1. SELECT w.`deposit_group` FROM `avg_sizes_by_groups` AS w,
  2.     (SELECT MIN(avg_sizes_by_groups.`avg_size`) AS minimum FROM
  3.         (SELECT `deposit_group`, AVG(`magic_wand_size`) AS `avg_size`
  4.         FROM `wizzard_deposits`
  5.         GROUP BY `deposit_group`) AS avg_sizes_by_groups) AS `min_wand`
  6. WHERE w.`avg_size` = min_wand.minimum;
Advertisement
Add Comment
Please, Sign In to add comment