CS 61A

Time: Wed 11/15/17 3 pm

Stream

Introducing cons-stream, a special form that essentially delays the evaluation of the second half of the pair. You may want to consider using cons-stream instead of cons when constructing a infinitely long list--a stream.

Good practice: Code up functions for map-stream, filter-stream and reduce-stream.

SQL

Syntax

Refer to SQL As Understood By SQLite.

• Create table create-table-stmt

  Usage example:

  CREATE TABLE cities AS
    SELECT "Berkeley" as city, "California" as state UNION
    SELECT "San Francisco",    "California"          UNION
    SELECT "Houston",          "Texas";

  Diagram

  

• Select select-stmt

  Usage example:

  SELECT * FROM cities
    WHERE state="California"
    ORDER BY city ASC;

  A recursive with-clause will be introduced this Friday.

  Diagram