This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Here’s an alternative solution (Standard SQL):
DATE_DIFF(resolved_date,created_date,DAY) - DATE_DIFF(resolved_date,
created_date,WEEK(SATURDAY)) - DATE_DIFF(resolved_date,
created_date,WEEK(SUNDAY)) Although I find that this results in N+1 to
the Goo...