Home /
Expert Answers /
Computer Science /
please-help-trying-to-do-question-8-and-keep-getting-divisor-is-equal-to-zero-error-query-8-display-pa681
(Solved): Please help trying to do question 8 and keep getting divisor is equal to zero error Query 8: Display ...
Please help trying to do question 8 and keep getting divisor is equal to zero error
Query 8: Display all players with a Shot percentage (goals/shots) greater than or equal to 25\%. Include the player's position description and team name. (NOTE: A divide by zero occurs if the player took no shots, so exicude players with 0 shots.) Format the percentage column to display as \#n\#.\# Orade will not display the % symbol. Format the column to display 1 digit of precision after the decimal: FORMAT 999.9 Don't worry about the \% symbol.
White shots is Not wolL; from lowitiati Segptoutret x. Locuer Remit x 1476.00000 . "drvioser is equal ta zero"
Connections E W PLAYER 1B PID ? PFNAME ? PLNAME ? TEAM ID III POSLNON ID HIH GP TEAMIID ? GOALS A II ASSISTS di POINTS II PIUSMINUS III PENALTIES HI GAMEWIN EIES UII OTGOALS \#IH SHOTS NI SHIFIS IIB FACEOFFWINPCT II SALARY POSITION - IIPOSIION ID Reports All Reports Data Dictionary Reports Data Modeler Reports OLAP Reports TimesTen Reports User Defined Reports
POSITION ? POSTION_ID ?POSITON_DESC
TEAM ? TEAM_ID ? TEAM_NAME ? TEAM_CONFERENCE ??TEAM_DIVISION