add hand crafted test query for normalized scheme