Putting It All Together

Apply the knowledge to complete the project.

We'll cover the following

Now is the time to apply the gained knowledge to generate the final two reports for the project.

Among the various concepts learned, leveraging the three questions to construct the query is the most crucial. Here, as a reminder, are these three questions to guide us through the process.

  1. What are the fields/attributes we want to show in our result set? 

  2. What are the data sources? 

  3. What criteria/conditions are to be met for those results? 

We also need to remember the sequence in which different SQL clauses are utilized within an SQL statement. This specific order is presented as depicted here:

Create a free account to access the full course.

By signing up, you agree to Educative's Terms of Service and Privacy Policy