Common Users Between Two Tables

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Common Users Between Two Tables. Start with the requirements and the two tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

Paytm wants to identify users who used both Paytm Wallet and Paytm UPI during January 2026. Write a PostgreSQL query that returns the common user_id values from the two activity tables.

Requirements

Consider only activity from 2026-01-01 through 2026-01-31, inclusive.
Return each user only once, even if the user has multiple activity records in either table.
Exclude rows where user_id is NULL.
Sort the result by user_id in ascending order.

Schema

wallet_activity

Column	Type	Description
event_idPK	INT	Unique Paytm Wallet activity event
user_id	INT	Paytm user identifier
activity_date	DATE	Date of Wallet activity

upi_activity

Column	Type	Description
event_idPK	INT	Unique Paytm UPI activity event
user_id	INT	Paytm user identifier
activity_date	DATE	Date of UPI activity

Tableswallet_activityupi_activity

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results