Subqueries in Select Clause

When we run a select statement in the SELECT clause, we generate one of the values that the query returns
The result of the subquery should be only one value per row as the subquery in the SELECT clause fills one column of the output table