Need MySQL Query Expert

We are looking to develop a mysql query to transfer some columns from one table to another. Specifically, there will 4 columns in destination table that need to be fetched from source table. The first one is just an ID. Second one is a text name. third one is a query that needs to run within the source table that will perform a count with a where condition. depending if the count is zero or not, it will write the value 1 / 0 in the third column of the destination table. last one, will just write a status code with a case conditional. we prefer if you use skype for text-chat and file transfer. Only bid if you know how to do this for sure. I will supply table data & structure. we expect a fast turn-around.