can you write me general SQL queries for the questions below. You can use placeholders for the table, row and column names.

1. Members who registered after 2017 Jan 1. Columns and format:

Name (Last, first)

email

Date Joined (i.e., registered date)

phone # (areacode-xxx-xxxx)

Home City

2. Student who has signed up to join AITP (have a valid registered date) but have not paid member fees (no payment exists)

Name (Last, first)

email

Date Joined (i.e., registered date)

phone # (areacode-xxx-xxxx)

Home City

3. Members whose membership will expire within 30 days from today

Member ID

Name (Last, first)

email

phone # (areacode-xxx-xxxx)

Last time payment (i.e., Latest payment date)

Number of days to expire

Is last time payment a renew?

4. Members whose membership will expire within 3 months from today

Member ID

Name (Last, first)

email

phone # (areacode-xxx-xxxx)

Last time payment (i.e., Latest payment date)

Number of days to expire

Is last time payment a renew?

5. Members whose membership have already expired

Name (Last, first)

email

Date Joined (i.e., registered date)

phone # (areacode-xxx-xxxx)

Home City

6. Members who have ordered polo shirt but have not received it

Member ID

Name (Last, first)

email

phone # (areacode-xxx-xxxx)

Shirt order date

Shirt order payment date

Shirt order payment amount

Shirt received? (show a N in resulting records)

7. All current members
   1. Exclude the expired members
   2. Columns and format:

Member ID

Name (Last, first)

email

phone # (areacode-xxx-xxxx)

Latest payment date

Earliest payment date

Number of payments

Average payment amount

2. Design SQLs to answer managerial questions:
   1. Has the number of members increasing or decreasing year by year?
   2. How many members has renewed their membership in each year?
   3. How many members paid their fee by cash, card, check or other types in each year?
   4. List new members of year 2017 and total number of polo shirts each member have ordere