title: Converting scientific notation to decimal in SQL Presto
body: <p>I'm working with Amazon Athena and there are several columns that come out as scientific notation and I need it to come out as either an integer or a decimal. I've tried doing the answer from this: <a href="https://stackoverflow.com/questions/29149910/convert-exponential-to-number-in-sql">Convert exponential to number in sql</a></p>
  <p>However, that doesn't work with SQL Presto, and this one doesn't work because I need it for multiple numbers, not just one: <a href="https://stackoverflow.com/questions/36914381/query-to-convert-exponential-number-to-float-in-sql-server">Query to convert exponential number to float in SQL Server</a></p>