Openai Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Design Schema for Accurate Subscription State Tracking
subscription_events +----------+---------------------+-----------+-----------+ | user_id | event_ts | event_type| plan_type | +----------+...
Design Schema and Logic for Subscription Event Tracking
user_subscription_events +----------+-------------+---------------------+-----------+---------+ | user_id | event_type | event_time | plan_...
Debug and harden trial-assignment Python code
You are given the following simplified Python snippet used to assign users and trigger a 1‑month free trial: """ import random, datetime, requests def...
Write SQL for post-trial conversion cohorts
Using the schema below, write SQL to compute, for users first exposed between 2025‑06‑01 and 2025‑06‑30 (inclusive), the intent‑to‑treat paid conversi...
Parse and build binary data in Python
Using provided interfaces ByteReader(read(n), read_uint32_le, read_string) and ByteWriter(write(b), write_uint32_le, write_string), implement function...
Implement vectorized NumPy ops and explain broadcasting
Implement vectorized NumPy code for: (a) computing pairwise cosine similarity between two real-valued matrices X (shape n×d) and Y (shape m×d) without...
Train and analyze a classifier
Given a labeled dataset for binary classification, implement an end-to-end Python solution to train and analyze a classifier. Tasks: ( 1) perform EDA ...