Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Basics in PostgreSQL

Quiz

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 refers to 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 ...;