column doctype format a50; SELECT doctype, count(*) cnt FROM xml_documents WHERE doctype IN ( 'eml://ecoinformatics.org/eml-2.0.1', '-//ecoinformatics.org//eml-dataset-2.0.0beta4//EN', '-//ecoinformatics.org//eml-dataset-2.0.0beta6//EN', 'eml://ecoinformatics.org/eml-2.0.0' ) GROUP BY doctype ORDER BY cnt DESC /