Lesson 1: Designing a Simple Query Step 2


Step 2. Identify the Information You Need

Your next task is to analyze the question to determine exactly which sources in our database contain the data we need. First, we need to determine which group or entity in the Column Picker panel contains the column we need. Then, we need to determine the exact column that contains the information we are looking for.

 

Based on an analysis of the question posed in Step 1, we can determine the following:

        The group or entity in the Column Picker panel: Religious Education.

        Specific column in the Religious Education group: Class Leader Last Name.

        Query conditions: This question contains no restrictions or limiting details; therefore, the query requires no conditions.

To help you visualize the elements of your question and how they map to components in the query, look at the following diagram:

 

 

 

<- - - Previous   |   Next - - ->