Skip to main content

SkillsFree Assessments My progress

Home
Skills
SQL for Data Analysis (Beginner)
Set Operations and Subqueries
Practice

Chapter 11 of 13Chapter overview

Set 1: Quick CheckActivity 3 of 3 in this set

Free practice · single-choice · medium

Practice

Use a scalar subquery

Which predicate finds orders above the overall average amount?

Choose one answer

WHERE order_amount > (SELECT AVG(order_amount) FROM orders)WHERE order_amount > GROUP BY AVG(order_amount)WHERE order_amount IN AVG(order_amount)

Free, practical skill-building for everyone—no account or subscription required.

Start free practice →

Learn

Free skills
Assessments
My progress

Your data

Backup & restore
Settings
Privacy

Platform

About
Contact
Editorial standards
Terms
Disclaimer

Follow SocialMediaSir

Official profile on every channel: SocialMediaSir

100% free educational practice. Progress stays on this device.