How Showcase this Step by Step-2322779

Note you will have to have a software that can connect to the database On my end i used SQL management studio Please follow this video I want to connect to the database you sent me wait for SQL management studio to start (it usually takes some minutes) Server santha-database-teaching-4.ccw9zr8vvw2d.ap-southeast-2.rds.amazonaws.com User name s3901292 Password Essra01010@ Step by step video Task 1: Showing tables- Here ou need to go to our database which in this case is s3901292 (check this) Task 2: Sample SQL queries : Sample quer run Task 3: Provide justification for the partion technique (Here ou need to look at milestone 1, check the tables created also ou check the tables or structure Task 4: Stored Function In this case i created a simple SQL statement that calls the stored function (This one) Task 5: Bonus mark THANK OU AS SIMPLE AS THAT — Create the function CREATE FUNCTION dbo.get_total_preferences (@BallotPaperID INT) RETURNS INT AS BEGIN DECLARE @total INT; — Calculate total preferences SET @total = (SELECT SUM(Preferences) FROM BallotPaper WHERE BallotPaperID = @BallotPaperID); RETURN @total; END; GO — This separates the function creation from the next command — Call the function SELECT dbo.get_total_preferences(1) AS total_preferences;