-- Database schema
| City : ID [ INTEGER ] primary_key , Name [ TEXT ] , CountryCode [ TEXT ] City.CountryCode = Country.Code , District [ TEXT ] , Population [ INTEGER ] | Country : Code [ TEXT ] primary_key , Name [ TEXT ] , Continent [ TEXT ] , Region [ TEXT ] , SurfaceArea [ REAL ] , IndepYear [ INTEGER ] , Population [ INTEGER ] , LifeExpectancy [ REAL ] , GNP [ REAL ] , GNPOld [ REAL ] , LocalName [ TEXT ] , GovernmentForm [ TEXT ] , HeadOfState [ TEXT ] , Capital [ INTEGER ] , Code2 [ TEXT ] | CountryLanguage : CountryCode [ TEXT ] CountryLanguage.CountryCode = Country.Code , Language [ TEXT ] , IsOfficial [ TEXT ] , Percentage [ REAL ] |
-- -- List all the official and unofficial languages used by the country that declared its independence in 1830.

SELECT T2.Language, T2.IsOfficial FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.IndepYear = 1830 GROUP BY T2.Language, T2.IsOfficial;