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

-- Nov 28 In-Class Exercise

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;

-- Nov 28 In-Class Exercise

   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;

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;

-- Nov 28 In-Class Exercise

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;

-- Nov 28 In-Class Exercise

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

-- Nov 28 In-Class Exercise

   ...> (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);

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

-- Nov 28 In-Class Exercise

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;

-- Nov 28 In-Class Exercise

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>

-- Nov 28 In-Class Exercise

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>

-- Nov 28 In-Class Exercise

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;