Skip to content

Predict Subquery Result

Predict Output Medium
workbench

Question

Order totals are: 10, 20, 30, 40. How many rows have total > AVG(total)?

Code

                  SELECT COUNT(*) FROM orders WHERE total > (SELECT AVG(total) FROM orders);
                

Related Resources

Related Lessons

Look up unfamiliar terms

A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.

View glossary

Decode error messages

Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.

View errors

Build real projects

Apply what you learned by building guided projects with starter code and solutions.

View projects

← Back to topic