I have the following query:
Select price, col2, col3*7.5 AS desconto, (price*desconto) AS finalprice From tab1.
When I run I get the following message:
Column 'desconto' cannot be resolved .
How do I resolve this error?
Note: I'm running AWS Athena that follows the same SQL standard .