generate sample sql in evidence
makeInitTable, makeInitView filter duplicated spcids