A paramedic is a healthcare professional, predominantly in the pre-hospital and out-of-hospital environment, and working mainly as part of emergency medical services (EMS), such as on an ambulance. The scope of practice of a paramedic will vary between countries, but generally includes autonomous decision making around the emergency care of patients. In some countries 'Paramedic' is a protected title and accountable to a professional regulatory body.
The scope of the role varies widely across the world, the paramedic role has developed into an autonomous health profession, with individual licence to practice, the paramedic remains an agent working on behalf of a doctor. There are different models of care for EMS providers which significantly influence the scope of practice of paramedics in an area.
The development of the profession has been a gradual move from simply transporting patients to hospital, to more advanced treatments in the field. In some countries, the paramedic may take on the role as part of a system to prevent hospital admission entirely and, through practitioners, are able to prescribe certain medications, or undertaking 'see and refer' visits, where the paramedic directly refers a patient to specialist services without taking them to hospital.
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'spsrgrou_a.courses_offered.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by