Please post your solutions to the Nov 28 In-Class Exercise to this thread.

Best,

Chris

CREATE TABLE R(A INT, B INT DEFAULT 1);

INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);

INSERT INTO R(A, B) SELECT A, A * A AS B FROM R;

DELETE FROM R WHERE B < 25;

UPDATE R SET B = 26 WHERE B = 25;

CREATE TABLE R( A INT, B INT DEFAULT 1 )

INSERT INTO R(A) VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);

UPDATE R SET B = A*A;

DELETE FROM A WHERE B < 25;

UPDATE R SET B = 26 WHERE B = 25;

Amits-MacBook-Pro:~ amitranganathan$ sqlite3 foo

SQLite version 3.23.1 2018-04-10 17:39:29

Enter ".help" for usage hints.

sqlite> create table R(A INT, B INT DEFAULT 1);

sqlite> insert into R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);

sqlite> UPDATE R SET B = A * A;

sqlite> DELETE FROM R WHERE B < 25;

sqlite> UPDATE R SET B = 26 WHERE B = 25;

CREATE TABLE R(A INT, B INT, DEFAULT) INSERT INTO R(A) VALUES (1) (2) (3) (4) (5) (6) (7) (8) (9) (10); UPDATE R SET B = A * A; DELETE FROM R where B < 25 UPDATE R SET B = 26 WHERE B = 25

sqlite> create table R (A int, B int DEFAULT 1);

sqlite> INSERT into R(A) VALUES ...> (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);

sqlite> INSERT INTO R SELECT A, A*A AS B FROM R;

sqlite> DELETE FROM R WHERE B <25;

sqlite> UPDATE R SET B = 26 WHERE B =25;

Hongbin Zheng

CREATE TABLE R(A INT, B INT DEAFULT 1);

INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);

INSERT INTO R(A, B) SELECT A, A*A FROM R;

DELETE FROM R WHERE B < 25;

UPDATE R SET B = 26 WHERE B = 25;

Ryan Moore CREATE TABLE R( A INT, B INT DEFAULT 1); <br> INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10); <br> INSERT INTO R(A,B) SELECT A,A*A FROM R;<br> DELETE FROM R WHERE B < 25; <br> UPDATE R SET B = 26 WHERE B = 25;<br>

Student Name: Alexander Duong <nowiki> CREATE TABLE R( A INT, B INT DEFAULT 1);

INSERT INTO R(A) VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);

INSERT INTO R(A, B) SELECT A, A * A AS B FROM R;

DELETE FROM R WHERE B < 25;

UPDATE R SET B = 26 WHERE B = 25; </nowiki>

CREATE TABLE R( A INT, B INT DEFAULT 1);<br /> <br /><br /> INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);<br /> <br /><br /> INSERT INTO R(A,B)<br /> SELECT A, A*A AS B<br /> FROM R<br /> <br /> DELETE FROM R WHERE B<25; <br /> UPDATE R SET B=26<br /> WHERE B=25;