user: Question: What is the maximum number of miles reached in a Texas landfall when the Saffir-Simpson category is smaller than 3.0?
Columns: ['Name', 'Year', 'Landfall', 'NHC Advisory Number', 'V(mph)', 'R(miles)', 'Saffir-Simpson Category', 'CHI']
Types: ['text', 'real', 'text', 'text', 'real', 'real', 'real', 'text']
Sample row: ['Bonnie', 1998.0, 'North Carolina', '31B', 115.0, 115.0, 3.0, '10.7']
SQL:

assistant: SELECT MAX("R(miles)") FROM "Table" WHERE "Landfall" = 'Texas' AND "Saffir-Simpson Category" < 3.0;