Coding task · SQL and MySQL course · Module 3: Filtering (WHERE)

Cheap and available novelties

Combine a range and a comparison with the AND operator.

Task

Write a query that retrieves all columns from the ksiazki table for books published in the years from 1990 to 2020 (BETWEEN) AND at the same time available (dostepna equal to 1).