-- Database schema
| Country : CountryCode [ TEXT ] primary_key , ShortName [ TEXT ] , TableName [ TEXT ] , LongName [ TEXT ] , Alpha2Code [ TEXT ] , CurrencyUnit [ TEXT ] , SpecialNotes [ TEXT ] , Region [ TEXT ] , IncomeGroup [ TEXT ] , Wb2Code [ TEXT ] , NationalAccountsBaseYear [ TEXT ] , NationalAccountsReferenceYear [ TEXT ] , SnaPriceValuation [ TEXT ] , LendingCategory [ TEXT ] , OtherGroups [ TEXT ] , SystemOfNationalAccounts [ TEXT ] , AlternativeConversionFactor [ TEXT ] , PppSurveyYear [ TEXT ] , BalanceOfPaymentsManualInUse [ TEXT ] , ExternalDebtReportingStatus [ TEXT ] , SystemOfTrade [ TEXT ] , GovernmentAccountingConcept [ TEXT ] , ImfDataDisseminationStandard [ TEXT ] , LatestPopulationCensus [ TEXT ] , LatestHouseholdSurvey [ TEXT ] , SourceOfMostRecentIncomeAndExpenditureData [ TEXT ] , VitalRegistrationComplete [ TEXT ] , LatestAgriculturalCensus [ TEXT ] , LatestIndustrialData [ INTEGER ] , LatestTradeData [ INTEGER ] , LatestWaterWithdrawalData [ INTEGER ] | Series : SeriesCode [ TEXT ] primary_key , Topic [ TEXT ] , IndicatorName [ TEXT ] , ShortDefinition [ TEXT ] , LongDefinition [ TEXT ] , UnitOfMeasure [ TEXT ] , Periodicity [ TEXT ] , BasePeriod [ TEXT ] , OtherNotes [ INTEGER ] , AggregationMethod [ TEXT ] , LimitationsAndExceptions [ TEXT ] , NotesFromOriginalSource [ TEXT ] , GeneralComments [ TEXT ] , Source [ TEXT ] , StatisticalConceptAndMethodology [ TEXT ] , DevelopmentRelevance [ TEXT ] , RelatedSourceLinks [ TEXT ] , OtherWebLinks [ INTEGER ] , RelatedIndicators [ INTEGER ] , LicenseType [ TEXT ] | CountryNotes : Countrycode [ TEXT ] CountryNotes.Countrycode = Country.CountryCode , Seriescode [ TEXT ] CountryNotes.Seriescode = Series.SeriesCode , Description [ TEXT ] | Footnotes : Countrycode [ TEXT ] Footnotes.Countrycode = Country.CountryCode , Seriescode [ TEXT ] Footnotes.Seriescode = Series.SeriesCode , Year [ TEXT ] , Description [ TEXT ] | Indicators : CountryName [ TEXT ] , CountryCode [ TEXT ] Indicators.CountryCode = Country.CountryCode , IndicatorName [ TEXT ] , IndicatorCode [ TEXT ] , Year [ INTEGER ] , Value [ INTEGER ] | SeriesNotes : Seriescode [ TEXT ] SeriesNotes.Seriescode = Series.SeriesCode , Year [ TEXT ] , Description [ TEXT ] |
-- -- List down the top 3 Latin American & Caribbean countries with the highest average value in "CO2 emissions (kt)" indicator since 1965. Give their highest value and in what year.

SELECT DISTINCT T1.CountryCode, T1.Year, T1.Value FROM Indicators AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.CountryCode WHERE T2.Region = 'Latin America & Caribbean' AND T1.IndicatorName = 'CO2 emissions (kt)' AND T1.Year > 1965 AND T1.Year < 1980 ORDER BY T1.Value DESC LIMIT 3;