can you do a query in a subquery code example

Example: why we use subquery in sql

We use subquery in order to get aggregate value in column without grouping data