Paper 2

Question 1

The data shown above is stored in a database table called conduct.

Write an sql statement to select the StudentName field for all records that have negative points

Answer 1

SELECT StudentName
FROM conduct
WHERE Points < 0

Question 2

state the wildcard that can be used in SQL to show all fields from a table

Answer 2

asterisk