This is a very specific technical question, in which the interviewer is asking you how to structure a piece of code. As a web developer, you may be asked actually to write code during the interview. This rarely occurs during a live interview, but you may be given a sign and liked this either before after or as a separate element of the interview process. You should be prepared for this and may want to bring some materials to the interview that will help you comply with this request.
"To write the code for the query that you have just described, I would need to know the names of the tables, the fields, and other details of the information you are seeking. I would then structure an SQL quarry using a Select, From, and Where statements."
"SQL queries are relatively easy to write. However, to do so, the developer needs to be familiar with several elements of the data tables with which they are working. These include the name of the table, the name of the field containing the data, and the data elements involved in the query. You then use statements such as Select, From, and Where to structure the SQL query."