Our rookie had a simple task on the SQL lab of the university he attends. Take a column in table A and copy it to table B, while adding a column id to B from a sequence C.
This seems like a matter of a single relatively simple SQL statement, and so thought their teacher. The solution we all thought…