-- Database schema
| Method : Id [ INTEGER ] primary_key , Name [ TEXT ] , FullComment [ TEXT ] , Summary [ TEXT ] , ApiCalls [ TEXT ] , CommentIsXml [ INTEGER ] , SampledAt [ INTEGER ] , SolutionId [ INTEGER ] , Lang [ TEXT ] , NameTokenized [ TEXT ] | MethodParameter : Id [ INTEGER ] primary_key , MethodId [ TEXT ] , Type [ TEXT ] , Name [ TEXT ] | Repo : Id [ INTEGER ] primary_key , Url [ TEXT ] , Stars [ INTEGER ] , Forks [ INTEGER ] , Watchers [ INTEGER ] , ProcessedTime [ INTEGER ] | Solution : Id [ INTEGER ] primary_key , RepoId [ INTEGER ] , Path [ TEXT ] , ProcessedTime [ INTEGER ] , WasCompiled [ INTEGER ] |
-- -- What format does the method number 8's comment have?

SELECT CASE WHEN CommentIsXml = 0 THEN 'isNotXMLFormat' WHEN CommentIsXml = 1 THEN 'isXMLFormat' END format FROM Method WHERE Id = 8;