In this case, only records which have a year value greater than or equal to 1990 will appear in the result. As you can see, it is essential to have a copy of the current schema handy in order to know what fields are available for each table. The schema is expected to change from time to time in response to the needs of the user community, so be sure to use the current version. Currently you can only query one table at a time, but a future version of Genie will be able to deal with several tables simultaneously. It can be omitted if you don't want to impose any restrictions.
Genie is now case-insensitive in most situations.
This means that it does not matter whether you type your query using upper or lower case letters. A literal constant is any explicit mention of a specific value for a field. The quotes are needed so Genie can distinguish literal constants from field names. Simple types contain just a single value, which can be String, Integer, or Real. Again there is no distinction between upper and lower case, but this time all punctuation is ignored in addition to blanks and underscores.