Showing image if specific criteria is met in Laravel

I am completely new at Laravel and I am making a dashboard. On this dashboard I want to show an image of a tick if the lastdatasync(timestamp data type) records are within the last 24hrs. if it is more than 24hrs(say last week) then the image of an X will show. I have done the sql command for this but I am not sure where to place it in the project.

sql:

select count(*) as failed from stores where isactive=1 and date_add(currentdatasync, INTERVAL 1 DAY) < Now() 

via Chebli Mohamed