Clients with non-expired applications
Clients with non-expired applications
Tochka's CRM has two tables: Contact (clients) and Application (their product applications).
Return the names of clients who have at least one non-expired application — one whose ExpiredOn is either NULL or strictly later than today.
Names alphabetical, no duplicates.
Row order matters
Tochka
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid