SQL problem

USE [master] GO DROP DATABASE IF EXISTS [CustomersAndCars] GO CREATE DATABASE [CustomersAndCars] GO USE [CustomersAndCars] GO --========================================== Tables CREATE TABLE [Cars] ( carId INT PRIMARY KEY IDENTITY NOT NULL, carMake VARCHAR(50) NOT NULL, carModel VARCHAR(50) NOT NULL, carYear INT NOT NULL ); GO CREATE TABLE [Customers] ( custId INT PRIMARY KEY IDENTITY NOT NULL, custName VARCHAR(50) NOT NULL, custAge INT DEFAULT -1 NOT NULL ); GO CREATE TABLE [CustomerCars] ( custId INT REFERENCES Customers(custId) NOT NULL, carId INT REFERENCES Cars(carId) NOT NULL, PRIMARY KEY(custId, carId) ); GO --========================================== Insert Data BULK INSERT [Customers] FROM 'c:\temp\Customers.txt' WITH ( FIRSTROW = 2, FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n', TABLOCK, KEEPIDENTITY ); GO BULK INSERT [Cars] FROM 'c:\temp\Cars.txt' WITH ( FIRSTROW = 2, FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n', TABLOCK, KEEPIDENTITY ); GO BULK INSERT [CustomerCars] FROM 'c:\temp\CustomerCars.txt' WITH ( FIRSTROW = 2, FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n', TABLOCK, KEEPIDENTITY ); GO --========================================== Views CREATE VIEW [vwCustomerCars] AS SELECT cu.*, c.* FROM Customers cu JOIN CustomerCars cc ON cu.custId = cc.custId JOIN Cars c ON cc.carId = c.carId GO --========================================== Stored Procedures CREATE PROCEDURE [spGetCarsByCustId] @custId INT AS SET NOCOUNT ON SELECT carId, carMake, carModel, carYear FROM vwCustomerCars WHERE custId = @custId ORDER BY carYear, carMake, carModel GO --.................................... /* one more on Tuesday, 10-29-2019 */