SQL

Question 1

What is a table?

Answer 1

a collection of data organized into rows and columns.

Question 2

What is a statement?

Answer 2

Words that database understands as commands

Question 3

What are the most 6 most common commands?

Answer 3

CREATE TABLE, INSERT INTO

Question 4

How do you create a new table?

Answer 4

CREATE TABLE

Question 5

How do you add a new row to table?

Answer 5

INSERT TO

Question 6

How do you query data from a table?

Answer 6

SELECT

Question 7

How do you edit a row in a table?

Answer 7

UPDATE

Question 8

How do you delete rows from a table?

Answer 8

DELETE FROM

Question 9

How do you filter/list results?

Answer 9

SELECT DINSTINCT “table”

Question 10

What does WHERE do?

Answer 10

the conditions that rows or cells must meet to be returned

Question 11

What clause must LIKE follow?

Answer 11

WHERE

Question 12

Name 3 wildcard characters?

Answer 12

• and _ and %

Question 13

What does A% do?

Answer 13

Matches any string that begins with “A”

Question 14

What does %a do?

Answer 14

Matches any string that ends in “a”

Question 15

How can you order data you want to display?

Answer 15

ORDER BY

Question 16

How can you set a minimum rows displayed?

Answer 16

LIMIT

Question 17

How can we combine similar rows from different tables?

Answer 17

JOIN

Question 18

How can I combine columns from similar tables?

Answer 18

UNION

Question 19

What’s an example of an IN subquery?

Answer 19

SELECT title FROM songs WHERE title IN (SELECT name FROM artists WHERE genre = “Pop”);