SQL problem

USE [master] GO DROP DATABASE IF EXISTS [team_users] GO CREATE DATABASE [team_users] GO USE [team_users] GO --========================================== Tables CREATE TABLE [Teams] ( teamsId INT PRIMARY KEY IDENTITY NOT NULL, universityTeamName VARCHAR(50) NOT NULL, ownerUserId VARCHAR(50) NOT NULL, isActive BIT ); GO CREATE TABLE [Users] ( userId INT PRIMARY KEY IDENTITY NOT NULL, firstName VARCHAR(50) NOT NULL, lastName VARCHAR(50) NOT NULL, userName VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL ); GO CREATE TABLE [team_users] ( teamId INT REFERENCES Teams(teamId) NOT NULL, userId INT REFERENCES Users(userId) NOT NULL, isAssistantCoach BIT, hasBeenHonored BIT, PRIMARY KEY(teamId, userId) ); GO --========================================== Insert Data BULK INSERT [Teams] FROM 'c:\temp\teams.txt' WITH ( FIRSTROW = 2, FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n', TABLOCK, KEEPIDENTITY ); GO BULK INSERT [Users] FROM 'c:\temp\users.txt' WITH ( FIRSTROW = 2, FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n', TABLOCK, KEEPIDENTITY ); GO BULK INSERT [team_users] FROM 'c:\temp\team_users.txt' WITH ( FIRSTROW = 2, FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n', TABLOCK, KEEPIDENTITY ); GO --========================================== Views CREATE VIEW [vwTeamsAndUsers] AS SELECT t.*, u.* FROM Teams t JOIN team_users tu ON t.teamId = tu.teamId JOIN Users u ON tu.userId = u.userId GO --========================================== Stored Procedures CREATE PROCEDURE [spGetTeamUsersByTeamId] @teamId INT AS SET NOCOUNT ON SELECT universityTeamName, userId, (firstName +" "+ lastName) AS fullName FROM vwTeamsAndUsers WHERE teamId = @teamId GO CREATE PROCEDURE [spGetUserTeamsByUserId] @userId INT AS SET NOCOUNT ON SELECT (firstName +" "+ lastName) AS fullName, universityTeamName, teamId FROM vwTeamsAndUsers WHERE userId = @userId GO CREATE PROCEDURE [spGetTeamsWithNoUsers] GO CREATE PROCEDURE [spGetUsersNotOnATeam] GO CREATE PROCEDURE [spNeverHonoredUsers] GO CREATE PROCEDURE [spGetTeamOwnersByTeamCount] GO CREATE PROCEDURE [spGetTeamsWithMoreThanAssistantCoaches] GO CREATE PROCEDURE [spGetTeamsWithNoAssistantCoaches] GO CREATE PROCEDURE [spGetHigestHonoredUsers] GO CREATE PROCEDURE [spGetUsersThatAreOnlyAssistantCoaches] GO