PracHub
QuestionsCoachesLearningGuidesInterview Prep

Quick Overview

This question evaluates SQL data manipulation skills and relational querying competencies, including joins, aggregations, NULL handling, and identifying the most recent event per group, within the Data Manipulation (SQL/Python) domain for a Data Scientist role.

  • hard
  • Point72
  • Data Manipulation (SQL/Python)
  • Data Scientist

Build the auction status table

Company: Point72

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: hard

Interview Round: Take-home Project

Quick Answer: This question evaluates SQL data manipulation skills and relational querying competencies, including joins, aggregations, NULL handling, and identifying the most recent event per group, within the Data Manipulation (SQL/Python) domain for a Data Scientist role.

Last updated: May 7, 2026
Loading…
PracHub

Master your tech interviews with 8,500+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • AI Coding Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.

Related Coding Questions

  • Write SQL for top student per department - Point72 (medium)
  • Convert integer dates to quarters - Point72 (medium)
  • Write SQL for recent customer activity - Point72 (medium)
  • Convert Dates to Calendar Quarter Labels in SQL/Python - Point72 (medium)