Freeform project


#1

Freeform project task №8.

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.




SELECT name, MAX (price) FROM fake_apps WHERE price>14;


#2

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