What the professor wants me to do: move test of count

Assignment Help Computer Engineering

Reference no: EM133240276

Question: Get the name and initials of each player who has incurred two or more penalties of more than $40.

What the professor wants me to do: move test of count and group by into a single select query for finding playerno. Should get one row as result

This is the code that has to be fixed:

select players.NAME,players.INITIALS
FROM PLAYERS,PENALTIES
WHERE PLAYERS.PLAYERNO = PENALTIES.PLAYERNO AND amount > 40
GROUP BY PLAYERS.PLAYERNO
HAVING COUNT(PENALTIES.PLAYERNO) > 2;

Reference no: EM133240276

Questions Cloud

Social media platforms : Based on everything we read and watch this week, what company can you think of that has had a public crisis lately (in the last year or two)? How did they respo

Develop a swot analysis : Develop a SWOT analysis with at least four points for each dimension with descriptions

Summarize a contribution made by noam chomsky : COM 339 New York University - Summarize a contribution made by Noam Chomsky to the field of psycholinguistics and potentially the development of language

Write a response to the book content and storyline : Write a response to the book (about 2 pages) - Include a short (1-2 paragraph) overview of the content and storyline

What the professor wants me to do: move test of count : What the professor wants me to do: move test of count and group by into a single select query for finding playerno. Should get one row as result

Case study-southwest airlines : Each Discussion Forum requires a main post, providing some analysis of the case and its relationship to one or more concepts presented in the chapter in which t

Explain how it works : CSCI 7645 Fairleigh Dickinson University coding problem that is in C where it asks for a program to check odd or even with a function that is this.

Discuss the meaning and implications of griswold penumbras : Discuss the meaning and implications of Griswold's penumbras and emanations. Describe the legal basis for an unenumerated right

What points from the power point slides off habits of mind : What points from the power point slides off habits of the mind; a thoughtful spirit, a requiring mind; and engaging the imagination captured your attention.

User Account

All Pages