Meta Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
Analyze Conversation Engagement and Reaction Usage Effectively
messages +-----------+--------+----------+--------------+---------------------+ | messageid | sender | receiver | has_reaction | timestamp |...
Calculate Response Rate and Compare User Survey Ratings
USERS user_id | signup_date 10 | 2024-03-20 11 | 2024-04-01 12 | 2024-04-05 SURVEYS survey_id | user_id | sent_at 1 | 10 ...
Analyze Group Call Adoption Using SQL Queries
CALL_LOGS | call_id | user_id | call_start | call_end | is_group_call | participant_cnt | | 101 | 12 | 2023-08-01 10:00...
Identify Top Three Active Users by Event Date
event_log +------------+---------+-----------+---------------------+ | event_date | user_id | event_type| event_timestamp | +------------+--------...
Calculate Total Revenue in USD Using SQL Query
ads_revenue +---------+------------+---------+----------+ | ad_id | country | revenue | currency | +---------+------------+---------+----------+ ...
Calculate Average Session Length and Compare App Performance
user_sessions +---------+------------+------------+---------------------+---------------------+ | user_id | session_id | app | session_start ...
Improve YoY Revenue Analysis with Complementary Metrics
ads_revenue +------------+-----------+ | date | revenue | +------------+-----------+ | 2023-01-01 | 120000 | | 2023-02-01 | 125500 | | 2...
Calculate Engagement Metrics for Info-Stream Content Analysis
info_stream_views +----------+-----------+--------------+----------+------------+ | post_id | viewer_id | relationship | duration | ds | +---...
Calculate Video Call Usage Metrics by Country and Date
video_calls +---------+-----------+------------+---------+----------+ | caller | recipient | ds | call_id | duration | +---------+-----------...
Identify Users Interested in Group Video Calls
video_calls caller | recipient | ds | call_id | duration u1 | u2 | 2023-09-01| c100 | 320 u3 | u4 | 2023-09-01| c101 ...
Identify Unique Callers and French Customer Call Percentage
video_calls +---------+-----------+--------------+---------------------+---------------+ | call_id | caller_id | recipient_id | start_ts | ...
Analyze Ad CTR and Convert Transactions to USD
AdsImpressions +-----------+---------+------------+--------+-----------+ | user_id | ad_id | impressions| clicks | event_dt | +-----------+------...
Calculate Recent Post Views and Reactions for Social Media
info_stream_views +---------+-----------+--------------+----------+------------+ | post_id | viewer_id | relationship | duration | ds | +-----...
Retrieve Top Five Ads by Conversions in 30 Days
ads ad_id | advertiser_id | created_at 1 | 101 | 2024-06-01 2 | 102 | 2024-06-03 3 | 101 | 2024-06-10 ad_i...
Calculate Weekly Thread Engagement with Reactions in SQL
messages +------------+--------+----------+--------------+---------------------+ | message_id | sender | receiver | has_reaction | timestamp ...
Determine Top Advertisers by Conversion Rate and CTR Analysis
ads +-------+---------------+------------+ | ad_id | advertiser_id | created_at | +-------+---------------+------------+ | 1 | 101 | 202...
Determine Old vs. New Users' Shop Visibility Changes
SHOP_VISIBILITY_HISTORY +----------+----------------+---------------------+-------------------+---------+ | user_id | user_signup_dt | action_timesta...
Calculate Survey Response Rate and Quality Metric in SQL
survey_responses +---------+----------+---------------------+---------------------+-------+ | user_id | survey_id| impression_ts | click_ts ...
Design SQL Query for Shop Visibility and User Activity Metrics
SHOP_VISIBILITY +----------+---------+------------+------------+-------------+--------------+ | user_id | shop_id | event_date | is_visible | signup_...
Calculate French User Engagement and U.S. Call Duration
call_logs +---------+-----------+------------+---------+----------+ | caller | recipient | ds | call_id | duration | +---------+-----------+-...