Jay Fisher

rearrange columns and use aliases

Not evidence, just included these statements as they are required to bring my tables from where they were in Module 1 to current setup.

  • October 26, 2017 at 7:03 PM
  • Visible to public
/*Need to add Scrim back into Materials*/
INSERT INTO Materials VALUES(3, "Scrim", 0.76);
/*Need to add None as an option in Finishes table*/
INSERT INTO Finishes VALUES(4, "None", 0.00); 

/*need to populate values in Signs table*/
INSERT INTO Signs VALUES (1,2,3,1,3,2,12.00);
INSERT INTO Signs VALUES (2,3,2,2,2,1,5.72);
INSERT INTO Signs VALUES (3,6,3,1,1,1,10.80);
INSERT INTO Signs VALUES (4,9,3,2,2,2,38.74);
INSERT INTO Signs VALUES (7,4,4,5,4,4,98.56);
INSERT INTO Signs VALUES (8,6,4,5,4,1,36.96);
INSERT INTO Signs VALUES (9,3.25,4,5,4,1,20.02);
INSERT INTO Signs VALUES (10,3,4,5,4,1,18.48);
INSERT INTO Signs VALUES (11,3,4.5,5,4,1,20.79);
INSERT INTO Signs VALUES (12,2.25,3.25,4,4,1,5.56);
INSERT INTO Signs VALUES (13,4.5,3,1,1,1,8.46);
INSERT INTO Signs VALUES (14,9,3,1,2,1,15.86);
INSERT INTO Signs VALUES (15,9,3,2,2,2,38.74);
INSERT INTO Signs VALUES (16,1.33,2,1,4,2,2.77);
INSERT INTO Signs VALUES (17,3,1,1,4,1,1.56);
INSERT INTO Signs VALUES (18,2,3,2,4,1,3.90);
INSERT INTO Signs VALUES (19,3,2,1,4,1,3.12);