The Structured Query Language (SQL) has a rich set of commands (SQL DML and DDL commands) that can be used to create tables/indexes and insert/update/delete/read data in the database, yet this language is not considered a general-purpose programming language to carry out certain data preprocessing and preparation tasks.

Illustrate by an example how SQL can be used for data collection yet a general-purpose programming like Python would be needed for further data preprocessing.