Freeform project


<Below this line, add a link to the EXACT exercise that you are stuck at.>

Freeform project task №8.

<Below this line, in what way does your code behave incorrectly? Include ALL error messages.>

There is no errors, but maybe poor wording. As you can see on screenshots below i need to return the maximum price for an app. If i use simple query (presented on 1 screenshot) i receive only 1 app, but i have checked database and ensured that there is more than 1 “app” that have similar price.

My question: how can i query all this items (name+price) without using clause “WHERE” ? To be honest i tried use it but it gain no results (script below screenshot). It’s look like i’m using incorrect logic of the query.

Update: It’s look like i should have use original formula without column “name” after clause “SELECT” to complete this task.

<In this course, it often helps to include a screenshot of your whole web browser – that lets everyone see what you see. If you wish to include a screenshot, add it below this line.>

<If you wish to copy/paste in your code, you can use this next section. This will allow others to copy/paste your code for testing – something that they won’t be able to do with just a screenshot.>

``` SELECT name, MAX (price) FROM fake_apps WHERE price>14;
<do not remove the three backticks above>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.