5.5 Consider the SQL statement:

SELECT id, forename, surname FROM authors WHERE forename = 'john' AND surname = 'smith'

a. What is this statement intended to do?

b. Assume the forename and surname fields are being gathered from user-supplied input, and suppose the user responds with:

Forename: jo'hn

Surname: smith

What will be the effect?

c. Now suppose the user responds with:

Forename: jo'; drop table authors--

Surname: smith

What will be the effect?