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 .