Definition: In this task you will break down a question into the basic steps required to answer it.
 A question decomposition is a numbered list of operations that must be performed to answer the original question. Imagine explaining your question to a friendly droid by listing each action it should take in order for the question to be answered. Each step in our decomposition should refer to either an entity (known or unknown), a propery of an entity or a query operation (count, group, union, etc.)
 Here are the list of step templates and their description:
 Select: A select step is used to return a set of objects. There are no references to previous steps in a select step. template: Return [attributes]
 Filter: A filter step is used to return results from a previous step to which a certain condition applies. template: Return [#step] [condition]
 Project: A project step should return certain attributes of the results of a previous step. template: Return [attributes] of [#step]
 Aggregate: An aggregate step returns an aggregator function applied on a step's result. template: Return the [aggregator] of [#step].
 Group: A group step is an aggregator applied on attributes. template: Return the [aggregator] of [#step] for each [attribute]
 Superlative: A superlative step is used to return the result with a highest/lowest attribute among other results. template: Return [#step1] [where] [#step2] [is] [highest / lowest]
 Comparative: A comparative step is used when we need to compare an attribute with a number to filter results. template: Return [#step1] [where] [#step2] [comparator] [number] 
 Union: A union step is used to return results of two steps together. template: Return [#step1] [or / ,] [#step2]
 Intersection: An intersection step returns the result that two steps have in common. template: Return [attribute] of both [#step1] and [#step2]
 Discard: A discard step returns result of a step and excludes result of another step from it. template: Return [#step1] besides [#step2]
 Sort: A sort returns result of another step in a specific order. template: Return [#step1] [ordered / sorted by] [#step2]
 Is true: An is true step checks a condition on another result and returns a true or false. template: Return [is / if] [condition]
 Arithmetic: An arithmatic step operates an arithmatic operation on one or more steps. template: Return the [arithmetic op.] of [#step1] [and] [#step2].

Positive Example 1 -
Input: question: What are the distinct creation years of the departments managed by a secretary born in state 'Alabama'?
Output: #1 return secretaries 
#2 return #1 born in state 'Alabama 
#3 return departments managed by #2 
#4 return distinct creation years of  #3

Positive Example 2 -
Input: question: i'd like to see flights from baltimore to atlanta that arrive before noon and i'd like to see flights from denver to atlanta that arrive before noon
Output: #1 return flights  
#2 return #1 from baltimore 
#3 return #2 to  atlanta 
#4 return #3 that  arrive  before noon  
#5 return #1 from denver 
#6 return #5 to  atlanta 
#7 return #6 that  arrive  before noon  
#8 return #4 ,  #7

Negative Example 1 -
Input: question: show the name of all bridges that was designed by american archtect, and sort the result by the bridge feet length.
Output: #1 return american archtects 
#2 return bridges 
#3 return sorted by feet length

Negative Example 2 -
Input: question: What is the average price for a lesson taught by Janessa Sawayn?
Output: #1 return price for lessons taught by Janessa Sawayn
#2 return the average of #1

Now complete the following example -
Input: question: Which customers have both "On Road" and "Shipped" as order status? List the customer ids.
Output: 


#1 return customers 
#2 return orders of #1 
#3 return statuses of #2 
#4 return #1 where #3 is On Road 
#5 return #1 where #3 is Shipped 
#6 return #1 in  both #4 and  #5 
#7 return customer ids of #6