Write a suitable query where you will collect the names of visitors in a conference who have less than 8 characters in their name. Also, separate the ones with a middle name. (Hint- You can take appropriate column_names)