Clients with non-expired applications
Точка'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.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| name |
|---|
| Aleksey Petrov |
| Andrey Morozov |
| Dmitry Sokolov |
Tochka
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid