SQL statements formats n shit

Question 1

create table statement

Answer 1

CREATE TABLE TableName (
Column1 Datatype1 PRIMARY KEY,
Column2 Datatype2,
Column3 Datatype3
);

Question 2

create views statement

Answer 2

CREATE VIEW ViewName AS
SELECT Column1, Column2
FROM TableName
WHERE Condition;

Question 3

joins statement

Answer 3

SELECT Table1.Column1, Table2.Column2
FROM Table1
INNER JOIN Table2 ON Table1.ID = Table2.ID;

Question 4

insert… into statement

Answer 4

INSERT INTO TableName (Column1, Column2) VALUES (Value1, Value2);

Question 5

update… set statement

Answer 5

UPDATE TableName SET Column1 = NewValue WHERE Condition;

Question 6

alter table to add column statement

Answer 6

ALTER TABLE TableName ADD ColumnName Datatype;

Question 7

make a foreign key

Answer 7

FOREIGN KEY (ForeignColumn) REFERENCES OtherTable(PrimaryKeyColumn)

Question 8

select statement

Answer 8

SELECT Column1, Column2 FROM TableName WHERE Condition;

Question 9

adding keys into table statement

Answer 9

ALTER TABLE TableName ADD CONSTRAINT[regular syntax]