SQL for Expiring Provider Credentials | Dataford Interview Questions

How would you write a SQL query to identify all providers whose credentials expire within the next 30 days?

Use the providers table and evaluate the date range relative to the current date. Include credentials expiring today and on the 30th day from today, but exclude expired credentials and rows without an expiration date.

Output

One row per qualifying provider
Columns: provider_id, provider_name, and credential_expiration_date
Order by expiration date ascending, then provider name ascending

Schema

providers

Column	Type	Description
provider_idPK	INT	Unique provider identifier
provider_name	VARCHAR(100)	Provider's full name
credential_expiration_date	DATE	Date the provider credential expires

Your question is SQL for Expiring Provider Credentials. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

How would you write a SQL query to identify all providers whose credentials expire within the next 30 days?

Output

One row per qualifying provider
Columns: provider_id, provider_name, and credential_expiration_date
Order by expiration date ascending, then provider name ascending

Schema

providers

Column	Type	Description
provider_idPK	INT	Unique provider identifier
provider_name	VARCHAR(100)	Provider's full name
credential_expiration_date	DATE	Date the provider credential expires

Your question is SQL for Expiring Provider Credentials. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.