SQL Inner Join for Subscriptions

Write a SQL query utilizing an inner join to retrieve user account details alongside their subscription status from two separate tables.

Use the users and subscriptions tables. Return only accounts with a matching subscription record.

Output

1. One row per matching user account
2. Columns: user_id, full_name, email, and subscription_status
3. Sort by user_id in ascending order