Форум пользователей MySQL

Create function sold_copies(@data DATETIME)
returns int
as
begin
declare @count int
set @count=(select SUM(dbo.sales.sold) from dbo.Sales
where dbo.sales.date_sale=@data)
return (@count)
end
 

create function topRatedProducts (@min_rating int, @max_rating int)
returns @rateTable table
(id int, Title varchar(100), Developer varchar(100), Publisher varchar(100), Rater varchar(100), Rating int)
as begin
insert into @rateTable
SELECT Main.id, Main.title, Developer.devname, Publisher.pubname, RateFirm.ratefirm, Rating.av_rating
FROM RateFirm INNER JOIN (Publisher INNER JOIN ((Developer INNER JOIN Main ON Developer.id = Main.developer) INNER JOIN Rating ON Main.id = Rating.id) ON Publisher.id = Main.publisher) ON RateFirm.id = Rating.firm_id
WHERE (((Rating.av_rating) Between @min_rating And @max_rating))
ORDER BY Rating.av_rating DESC
return
end
 

Create Proc checkID  @id int
AS
IF (SELECT id FROM Main WHERE id = @id) = '240'
    RETURN 1
ELSE
    RETURN -1;