It's quite common to use SQL like this, adding in fields or values from queries.
It's always worth trying some of these things in something like phpmyadmin to test out your ideas, but it's basically something like...