SQL(Stored Procedure)Mini-Project.sql

USE SalesDB
GO

ALTER PROCEDURE 
        Get_Customer_Summary @Country NVARCHAR(50) = 'USA' As 
BEGIN 
--==============================
---🤖 Step 1: Declare Variable
-- ==============================
DECLARE @TotalCustomer INT  , @AvgScore FLOAT;

  --- TASK 1.1: Preparing And Cleaning Up Data (NULLS)  ;
IF EXISTS (
SELECT 1 
FROM Sales.Customers 
WHERE Score = NULL AND Country = @Country )

BEGIN
        UPDATE Sales.Customers
        SET Score = 0
        WHERE Score IS NULL AND Country = @Country;
        PRINT('Updating NULL Scores to 0')
END
         ELSE
BEGIN
         PRINT('No NULL Scores Found')
END;
--==============================
---🤖 Step 2: Define Variable
-- ==============================
SELECT 
       @TotalCustomer = COUNT(*)
       ,@AvgScore = AVG(Score)
FROM Sales.Customers
WHERE Country = @Country ;

--==============================
---🤖 Step 3: Print Variable
--==============================
        PRINT 'Total Customers From '+@Country+' : '+ CAST(@TotalCustomer As NVARCHAR);
        PRINT 'Average Scores From '+@Country+' : '+ CAST(@AvgScore As NVARCHAR) ;
END
GO

--==============================
---🤖 Step 4: EXECUTING SP
--==============================
EXECUTE Get_Customer_Summary