@Alex SEDE queries one site at a time, normally.
This post talks about comparing sites and links to a template; maybe the SQL there will help you. I gather that cross-site queries in SEDE are kind of a hack and might time out if you're not careful. I've never written one.