How do I create these SQL Statements?

Here is a breakdown of the first question :

1. Write a SQL statement that creates a stored procedure with one int input parameter.
    
2. The stored procedure selects the supplierId field and the total of all Count field values for each group of supplierId's from the Part table.
    
3. Only rows with their Count total, or sum, greater than the value specified in the input parameter should be returned.  
    

as a side note: you should repost your question into 4 new questions, and delete this one, as you have 4 topics to cover.

anyhow, for the first part, let's start reading the first sentence:
1- Write a SQL statement that creates a stored procedure with one int input parameter.

where, in your suggested code, is the parameter?
did you read up on the syntax specifications of a sql server stored procedure?

note: you cannot have a table and a stored procedure with the same name.
anyhow, you should name a stored procedure according to it's function..

This is what I came up with:
CREATE PROCEDURE spSupplier
AS
SELECT Supplierid,SUM(Count)
FROM Part
WHERE Count>5
GROUP BY Supplierid

where is your input parameter?
msdn.microsoft.com/en-us/library/aa258259(SQL.80).aspx

Okay, you are still not passing a parameter, but before you get to that let's look at what they want you to do with it.

SELECT Supplierid,SUM(Count)
FROM Part
WHERE Count>5
GROUP BY Supplierid

This would eliminate supplier records with count <= 5 from being counted.  
"Only rows with their Count total, or sum, greater than the value specified in the input parameter should be returned."

This statement says to SUM(Count) should be > 5, so you have to apply the filter after the grouping occurs.

Research HAVING clauses:
http://technet.microsoft.com/en-us/library/ms180199.aspx

Research Stored Procedure:
http://msdn.microsoft.com/en-us/library/ms187926.aspx


Kevin

This is what I came up with.  

CREATE PROCEDURE spSuppliers
@Partid int
AS
SELECT Supplierid, SUM(Count)AS TOTALCOUNT
FROM Part
GROUP BY Supplierid

I have created this:
CREATE PROCEDURE spSuppliers
@Partid int
AS
SELECT Supplierid, SUM(Count) AS TOTALCOUNT
FROM Part
WHERE Partid=@partid
GROUP BY Supplierid

Now I have to add a condition for the totalcount which is in the GROUP BY. This is what I have tried but when I try to execute it in MS Server 2008 it comes up with errors:

GROUP BY Supplierid  = TOTALCOUNT>5
GROUP BY Supplierid, TOTALCOUNT>5
GROUP BY Supplierid>5

they correct keyword is HAVING:

CREATE PROCEDURE spSuppliers
@Partid int
AS
SELECT Supplierid, SUM(Count) AS TOTALCOUNT
FROM Part
WHERE Partid=@partid
GROUP BY Supplierid
HAVING SUM(Count) > 5

                                              

1:
2:
3:
4:
5:
6:
7:
8:

Thanks for all your help.