SQL

Question 1

How do you select all the rows from a table called ‘table’?

Answer 1

SELECT * FROM table

Question 2

How do you order ‘table’ by the column called ‘column’?

Answer 2

SELECT * FROM table ORDER by column

Question 3

How do you sort a table based on a column called ‘numbers’ in descending order?

Answer 3

SELECT * FORM table ORDER by numbers DESC

Question 4

How do you select all the rows in ‘table’ where the type is ‘red’?

Answer 4

SELECT * FROM table WHERE type = “red”

Question 5

How do you select all the rows in ‘table’ where the type is blue or pink?

Answer 5

SELECT * FROM table WHERE type = “blue” OR type = “pink”

Question 6

How do you select all the rows in ‘table’ where the type is green or the number is less than 7?

Answer 6

SELECT * FROM table WHERE type = “green” OR number < 7

Question 7

How do you select all the rows in ‘table’ where the type is not purple?

Answer 7

SELECT * FROM table WHERE type != purple

Question 8

What are the four things you need to be able to do with SQL?

Answer 8

Create, Read, Update and Delete