Question: what is the difference between inner query and subquery?
Answer: A subquery can define as one query embedded in another query. A normal SQL query divided into two parts one is inner query and another one is the outer query the inner query. The inner query is called subquery which is placed in the round parentheses after the WHERE clause, HAVING clause or FROM clause.