'How to use placeholder in sql to another column in select

i want to make a report and i already calculate it in one column then i want to use the result to another column, something like this

select addtime (timediff(a,b), c) as 'total_lead', case when
total_lead <= then 'yes' else 'no' end as 'check data'  from d

so i want to use the result and use it in another column anyone can help?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source