Welcome to Entrance! This note will help you get started.
It helps to have some data to play with. Click this link to import the Consumer Price Index data for the years 1913-2009: Import CPI Data (When the import dialog appears, click "OK" and the new table will appear. Click the "Welcome" tab when you are ready to come back to this screen)
Run a Query
To run a query: click the New button, type in the SQL you want to run, and click the "Run" button. For example, try copying and pasting this query:
SELECT Jan FROM cpi_orig;Make a Chart
To make a chart: add a PLOT keyword, like this:
PLOT AXISLABELS, RED LINE SELECT Year, Jan FROM cpi_orig;
There are many more examples in the Entrance blog and on our home page. Complete PLOT syntax is in the Help menu.