SQL

Question 1

SELECT

Answer 1

SELECT <field></field>

Question 2

FROM

Answer 2

FROM <table>

Question 3

WHERE

Answer 3

WHERE <field> = <condition></condition></field>

Question 4

LIKE

Answer 4

WHERE <field> LIKE "(Letter)%"</field>

Question 5

AND

Answer 5

AND <field> = <condition></condition></field>

Question 6

ORDER BY

Answer 6

ORDER BY <field> ASC/DESC</field>

Question 7

OR

Answer 7

OR <field> = <condition></condition></field>

Question 8

Nested Selection

Answer 8

SELECT <field>
FROM <table>
WHERE <field> <comparison>
(SELECT <field>
FROM <table>
WHERE <field> = <condition>)</condition></field></field></comparison></field></field>

Question 9

INSERT

Answer 9

INSERT INTO <table> (<field1>,<field2>,etc)
VALUES(<value1>,<value2>,etc)</value2></value1></field2></field1>

Question 10

DELETE

Answer 10

DELETE FROM <table>
WHERE <field> = <condition></condition></field>

Question 11

UPDATE

Answer 11

UPDATE <table>
SET <field1> = <value1>, <field2> = <value2>,
WHERE <field> = <condition></condition></field></value2></field2></value1></field1>

Question 12

JOIN

Answer 12

SELECT <table>.<field>, <...>.<...>
FROM <table1>
JOIN <table2>
ON <table1>.<field> = <table2>.<field>
WHERE <table>.<field> = <condition></condition></field></field></table2></field></table1></table2></table1></field>

Question 13

DROP TABLE

Answer 13

DROP TABLE <table>