We use a string constant (also known as a literal ) in the above select, namely
’Brookline’. String constant must begin and end with a single quote.
SQL is not case-sensitive. This means that you may or may not use capital
letters in any place in an SQL construction (except for string comparisons)
without any effect on the value returned by the query.
As we mentioned above, the where part of a select (also known as the where
clause) is optional. This allows us to compute table projections in SQL as we
show next.