2.2.3 SQL

Question 1

List the three SQL commands we need [3]

Answer 1

SELECT [1] FROM [1] WHERE [1]

Question 2

What symbol means ‘All’ in SQL? [1]

Answer 2

*

Question 3

What is the command to see all fields from the table ‘users’?

Answer 3

SELECT * from users

Question 4

What is the command to select the firstname and secondname fields from customers where the first name is ‘Dave’?

Answer 4

SELECT firstname, secondname FROM customers WHERE firstname = ‘Dave’

Question 5

What is the command to select the username from users where age is greater than 13?

Answer 5

SELECT username FROM users WHERE age > 13