Consider the following table that holds basic information about members of a club: Club Member(member Id, lastName, firstName, telephone) 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 member.

Синуэлла    2   09.11.2020 10:48    0