Derived Table, Virtual Table, DT, Derived Table vs Sub Query, Table Value Constructor, Nested DT

Derived Table, DT, Virtual Table, Derived Table vs SubQuery, Table Value Constructor, Nested DT Agenda: Q01. What is Derived Table and which version of SQL supports the Derived Table Q02. What is the difference between Derived Table and SubQuery Q03. Is Nested Derived Table and Recursive Derived Table allowed in SQL Q04. Can you use the Derived Table without the alias name Q05. Can you JOIN a table with the Derived Table Q06. Can you use a Derived Table in the WHERE clause Q07. Are duplicate column names allowed in the Derived Table Q08. Is an anonymous column name or column with no name is allowed in the Derived Table Q09. Can you use filter the record by applying the ORDER BY clause in the Derived Table Q10. Can you DELETE the records from the Derived Table Does it also affect the actual underlying base table Q11. Can you UPDATE the records from the Derived Table Does it also affect the actual underlying base table Q12. Can you INS