Average number of clockings per person

SQL query for GeoDynamics

Calculate the average number of clockings per person in the clockings table.

SELECT person_id, AVG(clocking_count) FROM (SELECT person_id, COUNT(*) AS clocking_count FROM clockings GROUP BY person_id) AS subquery GROUP BY person_id

GeoDynamics data model

Table Resource Types

Name: String
Resource_Type: Number

Table Resourcegroups

Table Resources

Table Vehicles

Table Timeclocks

Table Point Of Interests

Table Poigroup

Table Poitype

Table Rfidtags

Table Mobile Rfid Scanners

Table Smartphones

Table Users

Table Overtimeconfigs

Table Clockings

Table Costcenters

Table Costcenter Validators

Table Day Programs

Table Assets

Table Asset Locations

Table Asset Inspection Types

Table Asset Identifications

Table Absencetypes

Table Access Schedules

Table Access Schedules Exceptions

Table Accessgroups

Table Access Locations

Table Maintenance

Table Vehicle Maintenance Tasks

Table Maintenance Types

Table Badges

Table Btw Numbers

Table Persons

Table Persons Limosa

Table Workplaces

Table Project Leads

Table Registrations

Table Mobileclocking Optionlist

Table Mobileclocking Multijoblist

Table Fleet Fuelsensors

Magical SQL for GeoDynamics with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Average number of clockings per person

SQL query for GeoDynamics

GeoDynamics data model

Magical SQL for GeoDynamics with Peliqan.io

Let AI do the work for you

Ready to get instant access to all your company data ?

Ready to get instant access to
all your company data ?