Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DepositGroup
- FROM WizzardDeposits
- GROUP BY DepositGroup
- HAVING AVG(MagicWandSize) IN (SELECT MIN(DepositGroupsWithAverageWandSizes.[Average magic wand size]) AS [Min average wand size]
- FROM (SELECT DepositGroup,
- AVG(MagicWandSize) AS [Average magic wand size]
- FROM WizzardDeposits
- GROUP BY DepositGroup) AS DepositGroupsWithAverageWandSizes)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement