select distinct if(t1.name<t2.name,concat(t1.name,t2.name), concat(t2.name,t1.name)) as NAME
from team t1 left join team t2 on t1.name !=t2.name;
select distinct if(t1.name<t2.name,concat(t1.name,t2.name), concat(t2.name,t1.name)) as NAME
from team t1 left join team t2 on t1.name !=t2.name;