The question "in which fields is data useful for my query?"

Question

I need to make a query in a database but I don't know what fields I should use for this query, so I have asked a specialist what fields are useful for my query and he has explained me the fields but I am still confused and I want to ask him about the data in the fields he has explained me. So how can I ask him, can it be "in which fields is data useful for my query?", is it a correct pattern and question?

Anonymous · Accepted Answer

Imagine that the houses in the city where I live have different designs according to the regions of the city, so can I ask my friend this question "in what region of the city do you like houses most?", is it a correct pattern and question?

AlpheccaStars · Answer

anonymousSo how can I ask him, can it be "in which fields is data useful for my query?", is it a correct pattern and question?

I don't understand what you are asking.

Suppose there is a database containing information about people. You want to find all the people who live in the city of Ankara and have more than three children. There is one table in the database (named "people") that has this information. The fields in the table are: first_name, last_name, address, city, postal_code, country, mobile_number, email, age, gender, number_of_children and marital_status.

Your query would be something like this:

Select first_name, last_name, address, number_of_children from people where city = "Ankara" and number_of_children > 3;

The output from that query would be a tabular list with 4 columns and one person's information in each row.

So you must know what particular data you want to find, the table name and the field names. You also have to have access rights to the database and software for writing queries and displaying the results of the query.

Anonymous · Answer

The questions "in which fields is data useful for my query?" and "in what region of the city do you like houses most?" make a sense but don't sound ok. Yes they should be asked as "what fields are useful for my query as to their data?" and "what region of the city do you like best for its architecture and beautiful homes?". On the other hand, I think the questions "in what rooms are telephones usually found" and "in which cookbook can I find the recipe for Risotto Rice and Mushrooms?" sound ok (and make a sence, of course) and they can also be asked as "what rooms have usually telephones" and "which cookbook has that recipe for Risotto Rice and Mushrooms?".

The question "in which fields is data useful for my query?"

Top answer

Get the Weekly English Kit 📬

Related Questions