INSERT INTO Transcriber1 VALUES ('billy bob', 'billy@hotmail.com');

Results:
1 row created.

Elapsed: 00:00:00.03


INSERT INTO RecordCompany1 VALUES ('Steveland Records', 'Terra 138', '539 Cowell Ln', 'Stanford', 'CA', '94305-0138', 'http://slingshot.stanford.edu', '(650) 497-6805');

Results:
1 row created.

Elapsed: 00:00:00.05


/* If there are musicians who do not appear in groups, make them a solo act */

INSERT INTO Artist1 (name)
       (SELECT name
              FROM Musician1
	             WHERE name NOT IN
		     	     (SELECT musicianName
			     	     FROM InGroup1));

Results:
3750 rows created.

Elapsed: 00:00:21.98


/* Make every musician influenced by his/her own group */

INSERT INTO Influences1
	(SELECT groupName, musicianName
		FROM InGroup1);

Results:
250 rows created.

Elapsed: 00:00:00.52


/* Insert values to reflect that freddy transcribed a large set of songs on 4/30/00 */

INSERT INTO Tablature1
	(SELECT 'http://' || songName, 'freddy', '30-APR-00' 
		FROM Song1
	           WHERE songName < 'la b');

Results:
1000 rows created.

Elapsed: 00:00:00.29


/* Have any NULL genres default to country */

UPDATE Artist 
SET genre = 'country' 
WHERE genre IS NULL;

Results:
3750 rows updated.

Elapsed: 00:00:05.37


/* If the url doesn't point to ftp://www.olga.net/* (it's relative), make it a hard link */

UPDATE Tablature1
SET url = 'ftp://www.olga.net/' || url
WHERE url NOT LIKE 'ftp://www.olga.net/%';

Results:
1680 rows updated.

Elapsed: 00:00:07.47


/* get rid of any country artists... */

DELETE FROM Artist1 WHERE genre='country';

Results:
3750 rows deleted.

Elapsed: 00:00:09.28


/* and now delete a fake entry created earlier */

DELETE FROM Transcriber1 WHERE transcriber LIKE 'billy%';

Results:
1 row deleted.

Elapsed: 00:00:00.01