<SYSTEM_TASK:>
Solve the following problem using Python, implementing the functions described below, one line at a time
<END_TASK>
<USER_TASK:>
Description:

def status():
    '''Show version, available job types and name of service.

    **Results:**

    :rtype: A dictionary with the following keys
    :param version: Version of the service provider
    :type version: float
    :param job_types: Available job types
    :type job_types: list of strings
    :param name: Name of the service
    :type name: string
    :param stats: Shows stats for jobs in queue
    :type stats: dictionary
    '''
    job_types = async_types.keys() + sync_types.keys()

    counts = {}
    for job_status in job_statuses:
        counts[job_status] = db.ENGINE.execute(
            db.JOBS_TABLE.count()
            .where(db.JOBS_TABLE.c.status == job_status)
        ).first()[0]

    return flask.jsonify(
        version=0.1,
        job_types=job_types,
        name=app.config.get('NAME', 'example'),
        stats=counts
    )