Advertisement
simonradev

Smallest Deposit Group per Magic Wand Size

Sep 12th, 2017
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.42 KB | None | 0 0
  1. SELECT DepositGroup
  2.  FROM WizzardDeposits
  3.  GROUP BY DepositGroup
  4.  HAVING AVG(MagicWandSize) IN (SELECT MIN(DepositGroupsWithAverageWandSizes.[Average magic wand size]) AS [Min average wand size]
  5.                                FROM (SELECT DepositGroup,
  6.                                             AVG(MagicWandSize) AS [Average magic wand size]
  7.                                       FROM WizzardDeposits
  8.                                       GROUP BY DepositGroup) AS DepositGroupsWithAverageWandSizes)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement