What are the average and minimum prices (in Euros) of all products?
select avg ( price_in_euros ), min ( price_in_euros ) from catalog_contents
How about just for Cola?
select avg ( price_in_euros ), min ( price_in_euros ) from catalog_contents where catalog_entry_name = 'Cola'
Yes please!
select avg ( price_in_dollars ), min ( price_in_dollars ) from catalog_contents where catalog_entry_name = 'Cola'
Yes please!
select avg ( price_in_dollars ), min ( price_in_dollars ) from catalog_contents where catalog_entry_name = 'Root beer'