Dataford
Popular roles
Software EngineerData AnalystData ScientistData EngineerBusiness AnalystAI EngineerMachine Learning EngineerProduct Manager
Browse
Browse All RolesEvery role hub, from analyst to MLBrowse All CompaniesCompany-specific interview loopsAll Interview GuidesThe full guide library
Top questions by role
Software EngineerData AnalystData ScientistData EngineerBusiness AnalystAI EngineerMachine Learning EngineerProduct Manager
Top questions by skill
SQLPythonStatisticsMachine LearningA/B TestingSystem DesignGenerative AIProduct SenseMetricsBehavioral
Browse all questions →Try a mock interview
ExperiencesCoaching
New
Practice
Mock InterviewsTimed interview simulations with feedbackSuccess PathYour 6-week structured planModulesCurated lessons by topicWebinarsTalks from ex-Big Tech data leadsPlaygroundA free-form scratch editor
Learn
BlogInterview strategy and career adviceTech Job Market ReportHiring trends across data and AI rolesFor UniversitiesDataford for career centersAbout DatafordWho we are and how we build
Pricing
Get started
SQL: Min and Max Per User
00:00
5 left

SQL: Min and Max Per User

EasySQL · PostgreSQL

Problem

Robinhood monitors access to resources in the Robinhood app, such as account statements and tax documents. Write a PostgreSQL query that reports each user’s earliest and latest recorded access time.

Requirements

  1. Return every user, including users with no access-log records.
  2. Calculate the earliest access as first_access_at and latest access as last_access_at using timestamp aggregation.
  3. Return the user ID and username, ordered by user_id ascending.
  4. Preserve NULL values for users whose access history is unavailable.

Schema

users
ColumnTypeDescription
user_idPKBIGINTUnique Robinhood user identifier
usernameVARCHAR(100)User display name
account_statusVARCHAR(20)Current account status
access_logs
ColumnTypeDescription
access_idPKBIGINTUnique access event identifier
user_idBIGINTUser associated with the access event
resource_nameVARCHAR(100)Robinhood resource accessed
accessed_atTIMESTAMPTZTimestamp when the resource was accessed
event_typeVARCHAR(30)Access event type
Tablesusersaccess_logs
Interviewer

Whenever you're ready, walk me through your approach or go straight to the code. The requirements and the two tables are in the Question tab.

You need to log in / sign up to run or submit.
CodePostgreSQL
Sign up free to run your codeLog inLn 1
Run your query to see results here.