00:00

1005. Admins and Owners With MFA Enabled

MediumSQLITE6 / 1584

Relevant companies

Salesforce

Microsoft

Databricks

Snowflake

Atlassian

HubSpot

ServiceNow

Workday

Zendesk

Palantir

Datadog

Twilio

Okta

Veeva

Qualtrics

Zuora

Mixpanel

Amplitude

Dropbox

Monday.com

1005. Admins and Owners With MFA Enabled

Medium6 / 1584

Relevant companies

Salesforce

Microsoft

Databricks

Snowflake

Atlassian

HubSpot

ServiceNow

Workday

Zendesk

Palantir

Datadog

Twilio

Okta

Veeva

Qualtrics

Zuora

Mixpanel

Amplitude

Dropbox

Monday.com

Sign in to Practice

Write SQL and Python, run instantly in your browser, and track your progress.

Runs live in your browser — no setup
Save progress across all 1,500+ problems
Submit and validate your answer instantly

Business Problem

You are a security engineer at Okta, a leading identity and access management provider. As part of a quarterly security audit, you need to generate a report of all high-privilege user accounts (admins and owners) that have Multi-Factor Authentication (MFA) enabled. This report is critical for ensuring that the most powerful accounts are properly secured.

Your task is to query the users table to find all active users who have a role of either 'admin' or 'owner' and have mfa_enabled set to 1.

The final report should include the user's ID, email, role, seat type, organization ID, and the account creation time, sorted with the newest accounts first.

Schema: users

Column Name	Type

Business Problem

Your task is to query the users table to find all active users who have a role of either 'admin' or 'owner' and have mfa_enabled set to 1.

The final report should include the user's ID, email, role, seat type, organization ID, and the account creation time, sorted with the newest accounts first.

Schema: users

Column Name	Type

Admins and Owners With MFA Enabled — SQL Medium | Let's Data Science | Let's Data Science

user_id	INTEGER
org_id	INTEGER
email	TEXT
full_name	TEXT
role	TEXT
seat_type	TEXT
status	TEXT
mfa_enabled	INTEGER
created_at	TEXT

user_id	INTEGER
org_id	INTEGER
email	TEXT
full_name	TEXT
role	TEXT
seat_type	TEXT
status	TEXT
mfa_enabled	INTEGER
created_at	TEXT

user_id	email	role	seat_type	org_id	created_at
205	hye-jin.murphy@pearllogic.co	admin	full	46	2025-08-15
147	ehuang@tideventures.co	owner	full	34	2025-08-11
25	sota.rossi@icloud.com

user_id	email	role	seat_type	org_id	created_at
205	hye-jin.murphy@pearllogic.co	admin	full	46	2025-08-15
147	ehuang@tideventures.co	owner	full	34	2025-08-11
25	sota.rossi@icloud.com

1005. Admins and Owners With MFA Enabled

Relevant companies

Tags

1005. Admins and Owners With MFA Enabled

Relevant companies

Tags

Sign in to Practice