Company: Revature
Difficulty: medium
You are given product data from a grocery store. Write an SQL query to select category names where the sum of all product prices is greater than 240. The query should print only 1 column "categoryName" . The result should be ordered by the sum of prices of the category names in descending order . This is on "SQLite Question." Only SQLite syntax AND only Select * from where... Queries will work with this question. Do not use UPDATE , DELETE and so on. Note The category name is referred to as category.categoryName . Table Schema Category categoryId categoryName Product productId categoryId (foreign key references Category)