What steps should you take to construct a detailed query in a step-by-step fashion?

1 . List in the SELECT clause all the columns that you want to display. If the name of a column appears in more than one table, precede the column name with the table name.
2 . List in the FROM clause all the tables involved in the query. Usually you include the tables that contain the columns listed in the SELECT clause. Occasionally, however, there might be a table that does not contain any columns used in the SELECT clause but that does contain columns used in the WHERE clause. In this case, you must also list the table in the FROM clause.
3 . Take one pair of related tables at a time and indicate in the WHERE clause the condition that relates the tables. Join these conditions with the AND operator. If there are any other conditions, include them in the WHERE clause and connect them to the other conditions with the AND operator.