Mysql or Pyspark SQL query- The placement of subqueries

Let’s list all possible places where subqueries in MySQL or Hive QL or Pyspark SQL Query can be used: 1. In the SELECT Clause Subqueries can compute a value for each row. SELECT employee_id, (SELECT COUNT(*) FROM project_assignments pa WHERE pa.employee_id =...