DATABASE ХЕЛПНИТЕ

a. Assume you need to store the date the member joined the club and the date the

membership ended. Create and/or modify the table to store these dates.

b. Insert five records indicating that five members joined the club within the past year,

all on different dates.

c. Write and execute an SQL query to find all the members who belong to the club as

of today.

d. Modify the table to show that one member dropped his or her membership three

months ago.

e. Repeat the query in part (c) to demonstrate that the person who dropped

membership is no longer an active membe

АсияТулемисовна    1   09.11.2020 08:50    0