I need help creating procedures in SQL for the following:

-Checks if a member is inactive

-To returns Different Account Types (i.e. Savings, Checking, Loans, CDs respectively) Ideally, this might have a separate procedure for each account type

-To returns members affiliated to specific accounts (i.e. Joint and Single Type Accounts Respectively) Ideally, this might have a separate procedure for each account type

-To return the daily balance for a given account on a specific date and time.