Here is a more detailed explanation of the process to extract two tables and two columns from an SQL query.

How to Resolve SELECT INTO Errors in Dynamic SQL: Best Practices and Workarounds for Microsoft SQL Server 2016

Optimizing SQL INSERT Queries: Best Practices and Examples

Working with JSON Data in PostgreSQL: A Step-by-Step Guide