X-raying Active Galaxies Found and Missed by the Sloan Digital Sky Survey