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 MS SQL Server

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