Quiz
2. Task 1: Selecting rows from one table

Instruction

Great. How superstitious are you? We're going to deal with... horoscopes! Check out the table:

Horoscope (Id, Year, Sign, Content)

Let's describe the table a little bit. In the table, we have horoscopes for given years – they are sentences that describe what may happen in a specific year.

Each horoscope has an Id, refers to a specific Year, and has a specific zodiac Sign. The Content column contains the prediction.

Exercise

Select all columns for the Zodiac signs Pisces and Aquarius between the years 2010 and 2014.

Stuck? Here's a hint!

Use the following template to help you build your query:

SELECT
  ...
FROM ...
WHERE ...
  AND ...;