-- 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 ] |
-- -- How many methods does solution 1 have? And please tell me if solution 1 needs to be compiled.

SELECT COUNT(T2.SolutionId) , CASE WHEN T1.WasCompiled = 0 THEN 'Needs' ELSE 'NoNeeds' END needToCompile FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.SolutionId = 1;