New
ML System Design & SQL tracks just landed
See what's new
×
Question Bank
Pricing
Blog
Forum
HOT
JobRadar
NEW
Referral
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
SQL Question
AI Insights
Quick Summary
Compute Return on Ad Spend (ROAS) by dividing revenue by spend for each campaign.
Round the calculated ratio to two decimal places.
Output campaign ID and ROAS, sorted by campaign ID ascending.
What This Tests
Arithmetic operations on table columns.
Rounding numeric results to specified precision.
Column selection and aliasing.
Sorting query results.
Common Patterns
Transform
Sort
Collapse
Hint
What Interviewers May Ask Next
Ask AI Assistant
Ask AI Assistant
Ask me anything about this coding question!
Qwen
Qwen3.6-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
