I want to give columns name as current_date-1
below is the code.....
SELECT
user_id
,SUM(CASE WHEN DATE(log_date)=DATE(CURRENT_DATE-1)
THEN working_hrs END) AS DATE(CURRENT_DATE-1)
FROM
log_times
GROUP BY user_id
I want to give columns name as current_date-1
below is the code.....
SELECT
user_id
,SUM(CASE WHEN DATE(log_date)=DATE(CURRENT_DATE-1)
THEN working_hrs END) AS DATE(CURRENT_DATE-1)
FROM
log_times
GROUP BY user_id