select count(answeridfk) as total from #application.settings.tableprefix#results where answeridfk = select count(other) as totalother from #application.settings.tableprefix#results where questionidfk = and answeridfk is null select other from #application.settings.tableprefix#results where questionidfk = and answeridfk is null