DAT/380 Week 3 LAB 3.16 – Select horses with logical operators

$ 5

DAT/380 Week 3 LAB 3.16 – Select horses with logical operators

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.

993 in stock

SKU: DAT380WK3L3P16 Category:

Description

DAT/380 Week 3 LAB 3.16 – Select horses with logical operators

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.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

You may also like…