SQL Programming Beginner Quiz 2

INSERT INTO users VALUES (...); ADD ROW users (...); CREATE users (...);

DELETE FROM table; REMOVE table; DROP table;

UPDATE CHANGE SET

SELECT * FROM employees; GET employees; SHOW employees;

CREATE TABLE MAKE TABLE NEW TABLE

= == EQ

SELECT name FROM customers; GET name FROM customers; SHOW name FROM customers;

MAX() BIGGEST() TOP()

SELECT COUNT(DISTINCT city) FROM clients; SELECT COUNT(city) FROM clients; SELECT TOTAL(city) FROM clients;

UPDATE table SET ... WHERE ...; MODIFY table ...; CHANGE table ...;