Question: 2 8 SBLBCT 2 9 p . pfname II ' , II p . plname AS 'Player. Name', p . points, t . team _
SBLBCT
ppfname II II pplname AS 'Player. Name',
ppoints,
t teamname AS 'Team Name',
tdivision
FROM
player
JOIN
team ON pteamid tteamid
'WHERE
t division 'Pacific'
AND ppoints
ORDER BY
ppoints DESC;
Script Output DQuery
SQL Executing:SElECT ppfname pplname AS 'Player Name', ppoir
ORA: FROM keyword not found where expected "FROM keyword not found where expected"
Cause:
Action:
Error at Line: Column:
Query : ist the best players in the pacific division defined by points Include the team name and division along with player data. Sort the data in descending sequnce by points. Only include players with more than points.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
