How do you return multiple columns from sub-query?

To return multiple columns from a sub-query, you can include the sub-query in the SELECT statement of your main query. For example, you can use the sub-query in the FROM clause or as a derived table, specifying the columns you want to select. Ensure that the sub-query is properly formatted to return the desired columns, and you can alias it if necessary to improve readability. Here's a basic example:

<code class="language-sql">SELECT a.column1, a.column2
FROM (SELECT column1, column2 FROM table_name WHERE condition) AS a;
</code>