SELECT

member.member$\_$ID$,$

CONCAT$($member$.$Last$\_$Name, $\text{'},\text{'},$ member.First$\_$Name$)$ AS Name,

member.Email,

CONCAT$($member$.$Phone$\_$Area$\_$Code, $\text{'}-\text{'},$ member.Phone$\_$Number$)$ AS Phone,

MAX$($member$\_$fee$\_$payment.Date$\_$Paid$)$ AS Latest$\_$Payment$\_$Date,

DATEDIFF$(\text{'}2018-02-07\text{'},$ MAX$($member$\_$fee$\_$payment.Date$\_$Paid$))$ AS Days$\_$to$\_$Expiration

FROM

member

JOIN

member$\_$fee$\_$payment ON member.member$\_$ID $=$ member$\_$fee$\_$payment.member$\_$ID

WHERE

DATEDIFF$(\text{'}2018-02-07\text{'},$ MAX$($member$\_$fee$\_$payment.Date$\_$Paid

GROUP BY

member.member$\_$ID$,$

member.Last$\_$Name,

member.First$\_$Name,

member.Email,

member.Phone$\_$Area$\_$Code,

member.Phone$\_$Number;

this code is wrong incorrect feild list help me use a proper feild list to test the sql code

Members whose membership will expire within $30$ days from Feb $7,2018$

Explanation:$-$ To find the already expired members we have to check the date of the last paid membership fees and if it is less than $7$th February $2018$ and it has not been renewed then the membership has expired. So we have to select both the member and member$\_$fee$\_$payment table and check the corresponding membership with their unique member id$.$

$->$ The SQL query to show members whose membership will expire within $30$ days of February $7$th$,2018$ is as followings:$-$

SELECT $*$ FROM member,member$\_$fee$\_$payment where member.member$\_$ID $==$ member$\_$fee$\_$payment.id and DATEDIFF$($day$,$Date$\_$Paid,

use columns membe ID Name last, First Name $-$ email $-$ phone # $-$ latest payment date $-$ number of days to expiration