Using Discount In Your Query Using The Round Function

[Diana Magers]

Hello, Straight forward Yes, this is a homework question. It is a question that I missed on my homework but I know that it will be on my final next week.

Tables include:

SLIP

SLIP_ID

RINA_NUM

SLIP_NUM

LENGTH

RENTAL_FEE

BOAT_NAM

BOAT_TYPE

OWNER_NUM

OWNER

OWNER_NUM

LAST_NAME

FIRST_NAME

ADDRESS

CITY

STATE

ZIP

_____________________________________________________________________________

Question:

Offering a discount for owners who sign up early for slips for next year. The discount is 1.75 percent of the rental fee. For each slip, list the rina_num, slip_num, owner_num, owner_last, rental_fee and discount. The discount should be rounded to the nearest dollar.

This is what I have so far, not sure how to use the discount 1.75.

SELECT SLIP.RINA_NUM, SLIP.SLIP_NUM, SLIP.OWNER_NUM, OWNER.OWNER_LAST, SLIP.RENTAL_FEE, ROUND(RENTAL_FEE,2) AS DISCOUNT

FROM OWNER, SLIP;

[Author]

Posts