How do I create a subquery in postgresql?

Related questions

1. What is left join in PostgreSQL?
2. What is temporary table in hive?
3. What is a cross join?
4. Is inner join faster than LEFT JOIN?
5. What is view and types of views in SQL?
6. How many concussions are you allowed to have?
7. What is CTAS in hive?
8. Do While loop in MySQL procedure?
9. What is difference between full outer join and cross join?
10. Can we use two CTE in a single select query?

Tags

1. #another
2. #delete
3. #postgresql
4. #comparison
5. #usually
6. #inside
7. #nested
8. #update
9. #operators
10. #select
11. #clause
12. #statement
13. #added
14. #within
15. #insert
16. #where
17. #subquery