Coding task · SQL and MySQL course · Module 8: Subqueries

Cheap book by a Greek author

Combine two subqueries: a scalar one with the average price and one with IN for the author's country.

Task

Write a query that retrieves from the ksiazki table the tytul column of those books whose price is lower than the average price of all books AND whose autor_id is on the list of author ids from the country 'Grecja'. Use a scalar subquery with AVG and the IN operator with a subquery.