Chapter 3 Questions

1. Explain what the following command does:

      % grep "Java" *.txt | grep -v "Scheme"

2. Explain what the following command does:

      % grep "\[0-9\]\{2,5\}" *.txt

        Or, alternatively,

      % egrep "[0-9]{2,5}" *.txt

3. Given the artist and song tables described in Chapter 3

   write down the result of the following queries (in SQL

   the percent character is a wildcard that behaves much

   like the asterisk character in specifying filenames):

   SELECT last FROM artist WHERE birthplace LIKE "%u%" ;

   SELECT artist.birthdate, song.title FROM artist, song

    WHERE song.album LIKE "%Down%" AND artist.id = song.artist ;