Challenge: Surface Area Selection
Task
Swipe to start coding
Write an SQL query to get the average surfacearea
from the country
table, where the surfacearea
is greater than 1000000.
Solution
9
1
2
3
SELECT AVG(surfacearea)
FROM country
WHERE surfacearea > 1000000;
Everything was clear?
Thanks for your feedback!
Section 5. Chapter 2
single
9
1
No query executed yet... |
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat