SQL · Amazon · Medium
Given the following tables: users(user_id INT, signup_date DATE) orders(order_id INT, user_id INT, order_date DATE, amount DECIMAL(10,2)) Write an SQL query that lists users who registered from 2025-01-01 through 2025-01-31, inclusive, and made no purchases during that same date range. Return these columns: user_id signup_date Requirements: Restrict the result to users whose signup date falls within the specified period. Exclude any qualifying user who has at least one order…
Checking your access…