Coding task · SQL and MySQL course · Module 6: Aggregation and grouping

Four numbers at once

Ask the Library for four summaries in one query: the number of books, the average, the lowest and the highest price.

Task

Write a query that returns COUNT(*), AVG(cena), MIN(cena) and MAX(cena) at once from the ksiazki table.