USE gokhan
GO
CREATE PROCEDURE klm
AS

DECLARE @Id int,@Adsoyad nvarchar(MAX)
DECLARE ki CURSOR  FOR
SELECT id,adsoyad
FROM Ogrenci
WHERE id IN 	(SELECT id
             	FROM alma,yayin
		WHERE Ogrenci.id=alma.id
		Group BY yayinevi,id
		HAVING COUNT(id)>4
		)
OPEN ki
FETCH NEXT FROM ki INTO @Id,@Adsoyad
WHILE @@FETCH_STATUS=0
BEGIN
print CAST(@ID AS CHAR)+@Adsoyad
FETCH NEXT FROM ki INTO @Id,@Adsoyad
END
CLOSE ki
DEALLOCATE ki