سوال 3- کوئری که تمام مخاطبان یک فرد را که با یک حرف مشخص شروع می شوند را نمایش دهد.

DECLARE @IUserName NVARCHAR(50)

DECLARE @StartWith NCHAR(1)

SET @IUserName = N'ali'

SET @StartWith = N's'

SELECT     TOP (100) PERCENT tblMembers.IUserName AS MemnrUserName, tblMembers.IUserPhone AS MemberPhone FROM         dbo.tblUsers AS Usr INNER JOIN                       dbo.tblGroups AS Gp ON Usr.IUserID = Gp.GroupCreatorID INNER JOIN

                      dbo.tblGroupMembers AS Mgp ON Gp.GroupID = Mgp.GroupID INNER JOIN dbo.tblUsers AS tblMembers ON Mgp.UserID = tblMembers.IUserID WHERE     (Usr.IUserName = @IUserName)

GROUP BY tblMembers.IUserName, tblMembers.IUserPhone

HAVING      (tblMembers.IUserName <> @IUserName) AND (tblMembers.IUserName LIKE @StartWith + '%') ORDER BY MemnrUserName