select 'hat'.*, COUNT(*) as'pants' from hats 'hat'