Which where clause would give the required result?

CORRECT TEXT
View the Exhibit and examine the structure of the promotions table.
You need to generate a report of all promos from the promotions table based on the
following conditions:
1. The promo name should not begin with ‘T’ or ‘N’.
2. The promo should cost more than $20000.
3. The promo should have ended after 1st January 2001.
Which where clause would give the required result?

CORRECT TEXT
View the Exhibit and examine the structure of the promotions table.
You need to generate a report of all promos from the promotions table based on the
following conditions:
1. The promo name should not begin with ‘T’ or ‘N’.
2. The promo should cost more than $20000.
3. The promo should have ended after 1st January 2001.
Which where clause would give the required result?

Answer: See the explanation

Explanation:
WHERE promo_name NOT LIKE ‘T%’ AND promo_name NOT LIKE ‘N%’ AND promo_cost
> 20000 AND promo_end_date > ‘1-JAN-01′

Show Hint

Leave a Reply 1

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

Surersh

Surersh

What about this?

select promo_name from promotions
where (promo_name like ‘T%’ or promo_name like ‘N%’)
and promo_cost > 20000
and promo_end_date > ’01-JANUARY-2001′

Reply