QuerydrillCount paid orders
An SQL exercise from Querydrill. Solve it with a SQL editor in your browser, checked on the rows it returns and again on changed data, and it is checked the moment you submit.
The task
How many orders have the status paid? Return a single number.
What this exercise teaches
COUNT(*) counts the rows that survive the WHERE filter.
A hint if you get stuck
COUNT(*) counts rows. Text values need single quotes.
Try it now, no account needed
This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this exercise