Average salary per employee
SQL query for FortNox
Calculate the average salary for each employee.
SELECT employees.name, AVG(salarytransactions.amount) AS average_salary FROM employees JOIN salarytransactions ON employees.id = salarytransactions.employee_id GROUP BY employees.name
FortNox data model
Financialyears
Absencetransactions
Attendancetransactions
Accounts
Articles
Article Details
Company Information
Contracts
Currencies
Customers
Customer Details
Costcenters
Employees
Expenses
Incominggoods
Invoices
Invoice Details
Invoiceaccruals
Invoicepayments
Locked Period
Labels
Modesofpayments
Offers
Orders
Pricelists
Prices
Productionorders
Projects
Purchaseorders
Salarytransactions
Stockbalance
Stockpoints
Stocktaking
Suppliers
Supplierinvoices
Supplierinvoiceaccruals
Supplierinvoicefileconnections
Wayofdeliveries
Vouchers
Voucher Rows
Voucherseries
Account Charts
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed