New
The Learning module is now live
See what's new
×
Question Bank
Learning
NEW
Pricing
Blog
Forum
HOT
JobRadar
Description
Solution
Discussion
Submissions
Ask AI
Question Bank
Microsoft
SQL Question
AI Insights
Quick Summary
Join demand forecasts to datacenter profiles using the shared identifier.
Subtract forecasted demand from monthly capacity to determine available resources.
Project the required columns and sort the output by datacenter and month.
What This Tests
Table joining on a shared key
Column-level arithmetic expressions
Result ordering and column projection
One-to-many record alignment
Common Patterns
Inner Join
Transform
Sort
Collapse
Hint
What Interviewers May Ask Next
Ask AI Assistant
Ask AI Assistant
Ask me anything about this coding question!
Qwen
Qwen3.7-Flash
0/2000
Run
Submit
Test Cases
SQL Schema
Pandas Schema
Input
-
Output
-
Expected
-
