what is the highest score for all shops?
select max(score) from shop
how about the average?
select avg(score) from shop
what are the id and addresses of the shops whose scores are below this?
select shop_id, address from shop where score < (select avg(score) from shop)