Question: You have two tables: rc _ users and rc _ calls. The rc _ users table contains information about users, including their user ID and

You have two tables: rc_users and rc_calls. The rc_users table contains information about users, including their user ID and subscription status (e.g., "free" or "premium") and company id. The rc_calls table contains information about phone calls made by users, including the user_id, the call date, and the call status. You need to write an SQL query to return a list of users with a "free" subscription status who did not make any phone calls in April 2020. Order the results by user_id in Ascending order.
Tables Schema as Below:
rc_calls
columnName dataType
user_id int64
date datetime64[ns]
call_id int64
rc_users
columnName dataType
user_id int64
status object
company_id int64

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!