count the number of tenants whose one of the tenant is south carolina gamecocks ?
SELECT DISTINCT COUNT attr_open var_uri attr_close where brack_open var_x dbo_tenant dbr_South_Carolina_Gamecocks sep_dot var_x dbo_tenant var_uri brack_close