Task
You are given a table of Chegg Study user activity. Write a SQL query to return each user_id and email for users whose status is 'active' and who have completed more than 3 study sessions. Sort the results by study_sessions_completed in descending order, and then by user_id in ascending order.
Schema
chegg_study_users
| column | type | description |
|---|
| user_id | INT | Unique user identifier |
| email | VARCHAR(255) | User email address |
| status | VARCHAR(20) | Account status such as active or inactive |
| study_sessions_completed | INT | Number of completed study sessions |
| signup_date | DATE | Date the user signed up |
Sample data
Expected output
