Which SQL statement would you use?

View the Exhibit and examine the data in the promotions table.

PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name, cost, and start date of all promos in the post
category that were launched before January 1, 2000.
Which SQL statement would you use?

View the Exhibit and examine the data in the promotions table.

PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name, cost, and start date of all promos in the post
category that were launched before January 1, 2000.
Which SQL statement would you use?

A.
Option A

B.
Option B

C.
Option C

D.
Option D

Explanation:

Show Hint

Leave a Reply 4

Your email address will not be published. Required fields are marked *

Brian

Brian

I immediately knew it wasn’t A or B because of the date formats. But in case anyone is stressing over why C wouldn’t work….that is an upper case P right there. I think because of my computer’s resolution I played with the code for five minutes before I noticed that.

Reply

Sayed

Sayed

exactly…’P%’ and ‘post’ is different.

Reply