Skip to content
aggregate functions, group by, column alias
q-6 database development
2019 Computing Science Higher SQA paper
You can run and edit code on this page to explore the question and better understand the concepts
Here is a database table with information about a menu
Dishes
dishName
course
price
portions
Chicken wings
Starter
8.99
2
Baked Haddock
Main
15.99
1
Soup of the day
Starter
2.50
1
Pate
Starter
2.99
2
Brownies to share
Dessert
8.99
2
Panacotta
Dessert
6.00
1
Mushroom risotto
Main
9.99
1
Chicken curry
Main
12.99
1
Mixed platter
Starter
14.99
4
There are no rows in this table
What is the output from this SQL code ?
select course, min(price) as 'least expensive item'
from bistro
where portions >= 2
group by course
(you can copy and run the code in the repl block):
-- paste the output here
Additional question
How would you create this output, the most expensive dessert course and main course?
course most expensive item
---------- --------------------
Dessert 8.99
Main 15.99
(you can edit and run the code in the repl block: query.sql):
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.