NiHQVWvc

11)
2create table if not exists TABLENAME (
3  id serial primary key,
4  //add additional columns
5
62)
7insert into TABLENAME (COLUMN1NAME, COLUMN2NAME)
8values ('VALUEFORCOLUMN1', 'VALUEFORCOLUMN2);
9
103)
11select(COLUMN1NAME, COLUMN2NAME)
12from TABLENAME
13where name='VALUE';
14
154)
16A primary key is a column or set of columns that uniquely identify a row in a table.
17A foreign key is a field or collection of fields in a table whose value is required to match the value of the primary key for a second table. 
18
195)
20Joins find rows with related columns in two tables and combine the rows together.