Question

How would you create this table using SQL(psql) ??

Create a table for the test scores data below and populate your table with the data.   

Name​​​ Midterm Score​

William Smith​​​67

Natalie Lopez​​​85

Brenda Harper​​​94

Adam Petrie​​​85

Jennifer Warnes   ​​56

Joni Mitchell   ​​​89

William Ackerman ​​96

Bing Crosby   ​​​74

Jose Carreras   ​​​78

Answer 1

Ans) CREATE TABLE TEST_SCORES ( id INTEGER PRIMARY KEY ,Name TEXT,Midterm score INTEGER);

INSERT INTO TEST_SCORES VALUES (1,"William Smith",67);

INSERT INTO TEST_SCORES VALUES (2,"Natalie Lopez",85);

INSERT INTO TEST_SCORES VALUES (3,"Brenda Harper",94);

  INSERT INTO TEST_SCORES VALUES (4,"Adam Petrie",85);

  INSERT INTO TEST_SCORES VALUES (5,"Jennifer Warnes ",56);

  INSERT INTO TEST_SCORES VALUES (6,"Joni Mitchell",89);

  INSERT INTO TEST_SCORES VALUES (7,"William Ackerman ",96);

  INSERT INTO TEST_SCORES VALUES (8,"Bing Crosby",74);

INSERT INTO TEST_SCORES VALUES (9,"Jose Carreras",78);

SELECT * FROM TEST_SCORES;