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.