Question: 2 8 SBLBCT 2 9 p . pfname II ' , II p . plname AS 'Player. Name', p . points, t . team _

28 SBLBCT
29 p.pfname II ', II p.plname AS 'Player. Name',
p.points,
t. team_name AS 'Team Name',
t.division
FROM
player Dl
JOIN
team t ON p.team_id = t.team_id
'WHERE .
t. division = 'Pacific'
AND p.points >60
ORDER BY
p.points DESC;
Script Output x[DQuery...x
SQL | Executing:SElECT p.pfname ||'|| p.plname AS 'Player Name', p.poir
ORA-00923: FROM keyword not found where expected 00923.00000- "FROM keyword not found where expected"
*Cause:
*Action:
Error at Line: 29 Column: 36
Query 7: 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 60 points.
2 8 SBLBCT 2 9 p . pfname II ' , II p . plname AS

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!