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 or will happen in the specific year.

Each horoscope has an id, refers to a specific year and a specific zodiac sign. The column content contains the magical sentence.

Exercise

Select all columns from horoscopes for Pisces and Aquarius from the years 2010 to 2014.

Stuck? Here's a hint!

Use the following template to help you build your query:

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