Module # 5.2.4

Use sorting and searching techniques to solve a specific problem

Getting there

Lets start with some basics:

SORT does HIGHEST and LOWEST really well.
QUERY does "has" really well.

Now look at the graphic:
If the RED circle represents the whole database, the blue circle are the records that meet a criteria (second graders for example).  The purple lines are the individual records.  Notice that some are longer than others. 

FIND THE SHORTEST SECOND GRADER.

You would do that by querying for second graders and then sorting by height.

Exercise #1

Design the way to find the widest blue square below.