Mine

table advertisement: [media id] [cost]
table media: [id] [name] [type]
check media.type in 'tv', 'radio', 'internet', 'newspaper'

make an sql statement that finds the name of the media with the max cost of advertisement for each type of media