Moonfrog Interview Questions | Queries

Consider the following database schema for an e-commerce website: Given the following schema of tables: Event table (no index/key) – contains event data recorded when an event occurs: event_name [VARCHAR], user_id [VARCHAR], time [TIMESTAMP]Transaction table (no index / key) – contains transaction data for item_id [VARCHAR], quantity [INTEGER], price [NUMERIC], user_id [VARCHAR], time [TIMESTAMP] Provide detailed … Continue reading Moonfrog Interview Questions | Queries