SQL

Question 1

To set up a table

Answer 1

CREATE TABLE table name (column 1, column 2, …)

Question 2

To delete table

Answer 2

DROP TABLE table name

Question 3

add a column

Answer 3

ALTER TABLE table name ADD COLUMN column name

Question 4

Drop a column

Answer 4

ALTER TABLE table name DROP COLUMN column name

Question 5

create a primary key

Answer 5

CREATE TABLE table name (column 1 data type PRIMARY KEY)

Question 6

add a row

Answer 6

INSERT INTO table name VALUES (value column 1, value column 2)

Question 7

add a specific value to a column

Answer 7

INSERT INTO table name (column name1, ..) VALUES (column value1, ..)

Question 8

Delete contents of a column

Answer 8

DELETE FROM table name WHERE column name

Question 9

changes values in a table

Answer 9

UPDATE table name SET column name = new value WHERE column name = old value

Question 10

find specific rows

Answer 10

SELECT*FROM table name WHERE column name = value

Question 11

to find all distinct (combinations of) column values

Answer 11

SELECT DISTINCT column name FROM table name

Question 12

avg or max etc

Answer 12

SELECT AVG (column name) FROM table name

Question 13

Order certain values

Answer 13

SELECT *FROM table name ORDER BY column name