Home /
Database /
DAT380 Advanced Database Architecture /
DAT/380 Week 3 LAB 3.16 - Select horses with logical operators

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

Availability: In stock

$5.00

Quick Overview

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.

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

Double click on above image to view full picture

More Views

This assignment includes MYSQL queries

Download DAT/380 3.16 LAB

$5.00

Qty:

Details

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.

Additional Information

Special Price	$3.00

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.

My Cart

You have no items in your shopping cart.