SQL query for functioning

CREATE PROCEDURE GetJobReceivedBeyondPC
(
@JobReceivedBeyondPC float output,
)

AS
BEGIN

declare @countJobsDateDiff float
declare @countProdcutivityCapacity float
declare @SumFootage float
	
select @countJobsDateDiff=  query
select @countProdcutivityCapacity = count() from 
select @SumFootage = sum(footage) from 
@JobReceivedBeyondPC = (JobDate*@countProdcutivityCapacity)<@SumFootage

END