Find Valid Emails

Microsoft security protocols require a regular audit of user accounts to ensure only internal corporate emails are associated with administrative privileges.

Your task is to identify all users who have a valid internal email address. A valid internal email address must end with the specific domain suffix: @thequerylab.com.

Rules:

• The email must end exactly with @thequerylab.com.
• Emails with the domain appearing in the middle (e.g., [email protected]) are considered invalid.
• Output columns: user_id, name, email.
• Results must be sorted by user_id in ascending order.