Oracle NextGen

SQL Challenge

Challenge #4 – Find Specific Customer

Challenge Overview

Retrieve customer information for customers whose email ends with '@gmail.com'.

Requirements

•Return columns: customer_id, customer_name, email.
•Filter for emails ending with '@gmail.com'.
•Order by customer_name alphabetically.

Sample Dataset

Preview the schema and seeded rows you can query against.

customers

Contains customer contact information.

Columns

Name	Type	Notes
customer_id	INT	Primary key
customer_name	VARCHAR	Full name
email	VARCHAR	Email address

Sample Rows

customer_id	customer_name	email
1	Alice Johnson	alice@gmail.com
2	Bob Smith	bob@yahoo.com
3	Carol White	carol@gmail.com
4	David Brown	david@outlook.com
5	Eve Davis	eve@gmail.com

SQL Playground

Loading editor…

Result Preview

Awaiting Run

Run your query to see the dataset preview.