A subquery is a query that is nested inside a SELECT , INSERT , UPDATE , or DELETE statement, or inside another subquery. ... A subquery can be used anywhere an expression is allowed. In this example ...

I got it. The INSERT INTO was missing the draft status id field and also the name in the new table was still DRAFT_STATUS_ID but labeled Draft Status Id.

Use SQL to store data and retrieve it later on. Use SQLite to build relational databases on your computer. Perform CRUD operations on relational databases using SQL. In this lesson, we'll cover ...