I have a few problems I am not getting and I have tried many times Ex2C-2: List

Question

I have a few problems I am not getting and I have tried many times

Ex2C-2: List the MEMBERSHIP_ID, CUSTOMER_ID and the dates on which the club membership expire.

Note in the membership table we have date and duration, duration is in months and date is date i tried this code but it gives me the wrong answer

SELECT MEMBERSHIP_ID, CUSTOMER_ID,

(membership_date +duration) AS ExpireDate

FROM club_membership;?

2nd problem

Show all constraints in the order_details table of the outdoor clubs& product database

Explanation / Answer

When the above code is compiled and executed, it produces the following result:

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.