SQL is an industry standard for storing and recovering information, and provides a complete specification defining how data within relational database should be managed, searched, and updated. Relational database systems include IBM's DB2, Oracle, Watcom SQL, etc.

A Simple SQL Query

The following SQL query finds titles and title lengths of Shakespearian plays written in a given year from a relation called collection:

    SELECT from_date,to_date, title, kind
      FROM catalog1.texts.collection
      WHERE from_date <= year AND year <= to_date
      ORDER BY from_date;
    

Please provide a value for YEAR between 1590 and 1613: