This week’s questions
1Weighted Catalog AverageAlibaba · AggregationEasy10 pts 2Department Pay LeadersFacebook · Window FunctionsMedium20 pts 3Riders Taking a Second Trip Within 7 DaysUber · AnalyticsHard40 pts 4Loan Delinquency BucketsJPMorgan · Date & TimeHard40 pts 5Peak Concurrent Meetings per OrgMicrosoft · AnalyticsHard40 ptsRules
- A new contest starts every Monday 00:00 IST and ends Sunday 23:59 IST.
- 5 SQL questions: 1 Easy (10 pts), 1 Medium (20 pts) and 3 Hard (40 pts each) — 150 points in total. No question repeats within 8 weeks.
- A question scores when you solve it for the first time during the contest week (Evaluate → Accepted). Questions you solved before the week started don’t score.
- Ties are broken by speed: the lower total time from the contest start to each of your first solves wins.
- Log in (free) to be ranked. The leaderboard shows first name and last initial and refreshes every 5 minutes.
Live leaderboard
{{ playersLine }}{{ lbMeLine }}
{{ lbMessage }}
- {{ u.rank }} {{ u.name }}{{ u.points }} pts · {{ u.solved }}/5 · {{ u.time }}
Log in to be ranked this week.
Past contests
The first contest is running now — winners of each week appear here after Sunday 23:59 IST.
TechTown 365 Challenge
Keep learning for a full year. Every weekly contest you join and every question you solve live after joining earns challenge points. Your own 365 days start the moment you join.
🏆 Grand prize: the latest iPhone or a cash prize, decided by Tech Town
🏅 Runners-up: Tech Town interview PDFs and certificates
This is a motivation programme run by Tech Town; prizes are awarded only under the 365 Challenge rules.
- 1Join once from your dashboard or here. Day 1 is today.
- 2Solve SQL, Python, DSA, DAX and PySpark questions: Easy 10, Medium 20, Hard 40 points. Questions solved after viewing the solution score 0.
- 3Join at least 90% of weekly contests and solve on 200+ days.
- 4On day 365 the top 10 eligible learners take a short live skill check; winners are chosen under the rules.
| # | Learner | Points | Day |
|---|---|---|---|
| No points yet — join and be the first on the board. | |||
Want more? Practise all company-wise SQL questions, or try Python, DSA, DAX and PySpark practice.