Writing the SQL Query

Create a standard SQL query to return the wanted information.

Step 1

SQL Query =

"SELECT top 25 UserId rcp_guid, DateCreated, DateRegistered, Email rcp_email,

 FirstName, LastName, TelephoneNumber, UserTitle, UserType

FROM RegisteredUser

WHERE (DateRegistered >= '03/01/2000' AND DateRegistered <=

 '03/30/2000') AND UserType = 1 AND Email is not Null

ORDER BY rcp_email ASC"

All rights reserved.