Question: Can you write me a SQL query for the following: Note for questions a to c Membership starts on the day when membership fee payment

Can you write me a SQL query for the following:

Note for questions a to c

  • Membership starts on the day when membership fee payment is received and is good for one year.
  • Your SQL must not use any hardcode date except the one provided in the question, Feb 7 2018.

Member ID

Name (Last, first)

email

phone # (areacode-xxx-xxxx)

Latest payment date

Number of days to expiration

  1. Show currently active members (exclude the expired members)
  2. Members whose membership were expired since Feb 7, 2018
  3. Members whose membership will expire within 30 days from Feb 7, 2018

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Customers customer id PK address id FK first_name last_name phone note Addresses address_id PK city state country note Factors Factor_id PK customer id FK payment method_id FK date Payment...

Q:

Background: AITP is a student organization of MSU. AITP uses a MySQL database to manage its membership. A student becomes a member by registering to AITP. The database records the member and...

Q:

Practice Section You may want to download and open the Practice Database in Lesson 4 in Microsoft Access (Admissions Student Database.mdb; Please note that this database is graciously provided...

Q:

Need ONLY an answer to Part C, step 1, questions 1 and 3. Term Project Part A: Understanding Financial Statements Locate and use an annual report STEP 1: The Company Assigned to you Find the most...

Q:

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Q:

1)Financial Reporting - The Procter & Gamble The financial statements of P&G are presented in Appendix B. The companys complete annual report, including the notes to the financial statements, can be...

Q:

Foothills Athletics is an athletic facility offering services in the greater Highlands Ranch, Colorado, area. All property owners living in Highlands Ranch are members of the Recreation Function of...

Q:

Please provide the answers for the following multiple choice questions base on the best of your knowledge. Thank you! To properly identify your signer named in documents as "James Carl Braden", his...

Q:

Question Please provide the answers for the following multiple choice questions base on the best of your knowledge. Thank you! To properly identify your signer named in documents as "James Carl...

Q:

provide the answers for the following multiple choice questions base on the best of your knowledge. Thank you! To properly identify your signer named in documents as "James Carl Braden", his...

Q:

Customer profitability, customer-cost hierarchy Ramish Electronics has only two retail and two wholesale customers. Information relating to each customer for 2009 follows (in thousands): Ramishs...

Q:

List some factors that can affect productivity and an example of each improving productivity.

Q:

Which of the following statements about mutual fund performance is correct? Mutual funds managed by superstar managers tend to produce superior results year after year The one takeaway from the...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

2 As a competitor to Everglo, what would be your options in response to Everglos latest moves? Everglo Battery, the premier battery manufacturer and service provider in South Africa, looked back on...

Q:

2 How will Globals own customer service priorities change as a result of this? This case study contains information on how Globals expectations of quality of service from its suppliers evolved over a...

Q:

1 What actions do you think Global could take to respond to the needs of its customers? This case study contains information on how Globals expectations of quality of service from its suppliers...