Thank you all, Steve Collins, Eirikur Eiriksson, and Jeff Moden for helping out

I've tagged the weekends and weekdays as follow

SELECT 
listing_id, 
CASE 
WHEN DATEPART(WEEKDAY,date) IN (1,7) THEN...