Question

The Horse table has the following columns:

• ID - integer, primary key
• RegisteredName - variable-length string
• Breed - variable-length string
• Height - decimal number
• BirthDate - date

Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.

Answer 1

The query is:

SELECT RegisteredName, Height, BirthDate FROM Horse WHERE Height>=15.0 AND Height<=16.0 AND BirthDate >='2020-01-01'

Explanation:

Here is the query which selects and displays the RegisteredName, Height, BirthDate of only those rows in the Horse table, which are having Height between 15.0 and 16.0 inclusive as mentioned in the where condition of the query written and after that Date condition is also there that birthdate should be after 2020-01-01.

PLEASE UPVOTE IF YOU FOUND THIS HELPFUL!