Explain the difference between subquery,CTE and stored procedures

Stored Procedure A stored procedure is a precompiled collection of SQL statements (and sometimes...