About the query

The query you create retrieves financial data. When you have finished, the query returns data from the database that is similar to this.

Shown is a Sequel Preview view of a query that returns data for the columns Year, Quarter, Type, and Description.

The financial data is stored in two tables: the fin_data and fin_code tables.

The following illustration shows the two tables with some data. The code value in the fin_data table gets its meaning from the fin_code table.

Shown are two tables that store financial data. The  fin _ data table at left has a column labeled Code with two entries of r 1 that are circled and point to the fin _ code table shown at right. In the fin _ code table the row for code r 1 is circled. It has three rows, with r 1 as the code, revenue as the type, and Fees as the description.

For example, the r1 circled in the fin_data table means the row reports a revenue amount for fees.