use sql to answer the following question Write a PL/SQL Function that accepts 4 integers, 2 representing the homeTeamID and visitorTeamID , and the other 2 representing the score for each team during...


use sql to answer the following question


Write a PL/SQL Function that accepts 4 integers, 2 representing the
homeTeamID
and
visitorTeamID, and the other 2 representing the score for each team during a game :
htscore
and
vtscore
The function will determine which team won the match and return the teamID of the winning team. You can achive this by comparing htscore > or < then="" vtscore..="" if="" htscore="" is="" bigger="" then="" return="" hteamid="" or="" else="" return="">


If the game was a tie (the 2 scores are the same value) return a 0.



Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here