Google: Fusion Tables - Orders

Import the Orders data file

Download the file (DB 2 Order Import File - Data.csv) attached to this page.

The file looks like:

Customer,City,Date,Product,Sales,Payment Method

Allied Textiles,Halifax,2014-01-13,Nylon,498.00,Credit

Allied Textiles,Halifax,2014-01-20,Nylon ,498.00,Credit

Create a new Fusion Table by importing the .csv file from your computer.

Add a Summary

A summary can hold more than one for these queries.

Queries created by a summary tab can be more complex.

Rename your Summary tabs to describe the information it contains

Note:

Add Multiple Filters

Add a row layout -- click on the red plus sign.

This will create a second copy of all the records

Once a field is selected to be filtered, you can choose to include or exclude values 

Multiple filters can be added to perform more complex queries.

NOTE:

Once a filter has been added to a row layout and a new Summary Layout is added, the filter is also applied to the Summary Layout. This filter can be remove without remove it from  the original Summary Layout. 

Once a filter has been added to a row layout, it can be exported as a .csv file for further processing.

This type of query is harder to keep as each require its own layout to remain active.

Notice when you create a filter, text similar to the following appears beside the filter tab:

            'Payment Method' = 'Cash' AND Sales >= 400 AND Product NOT EQUAL TO 'Cotton'

This text is part of a general database language called SQL. It is used in many database programs to manipulate the data contained in a database

More Difficult Queries

this type of query is difficult to do: