Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Quantas vezes o U.S. Rank 102, o ano anterior a 2006 e o total de toneladas são menores que 2.983.137?
 ###Tabelas: CREATE TABLE arkansas_militia_act_of_1843 (arkansas_militia_act_of_1843_id AUTO_INCREMENT PRIMARY KEY, Division VARCHAR, Brigade VARCHAR, Regiment VARCHAR, Colonel VARCHAR, County VARCHAR) CREATE TABLE sun-like_stars_with_hot_dust (sun-like_stars_with_hot_dust_id AUTO_INCREMENT PRIMARY KEY, Star VARCHAR, Stellar classification VARCHAR, Distance from Earth ( ly ) VARCHAR, Constellation VARCHAR, Dust (or Debris; Temperature (K) VARCHAR, System VARCHAR, Dust (or Debris) Location (AU) VARCHAR, Cool Dust > 10 AU VARCHAR, Stellar Age (Myr) VARCHAR) CREATE TABLE free___open_source_floss (free___open_source_floss_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Platform VARCHAR, Supported databases VARCHAR, Tracking Method VARCHAR, Latest stable release VARCHAR, License VARCHAR) CREATE TABLE election (election_id AUTO_INCREMENT PRIMARY KEY, Event VARCHAR, Date VARCHAR, DP / DA INT, NP / NNP VARCHAR, COPE VARCHAR, ACDP INT, Others INT) CREATE TABLE annual_tonnage (annual_tonnage_id AUTO_INCREMENT PRIMARY KEY, Year INT, U.S. Rank INT, Total s Ton INT, Domestic s Ton INT, Foreign Total s Ton INT, Foreign Imports s Ton INT, Foreign Exports s Ton INT)  
SELECT COUNT Foreign Total s Ton FROM annual_tonnage WHERE U.S. Rank = 102 AND Year < 2006 AND Total s Ton < 2,983,137