Average payment amount by currency

SQL query for Mews

Get the average payment amount for each currency used.

SELECT c.code, AVG(p.amount) AS average_payment_amount FROM currencies c JOIN payments p ON c.id = p.currencyid GROUP BY c.code

Mews data model

Table Accountingcategories

Table Accountingitems

Table Accountnotes

Table Addresses

Table Agecategories

Table Availabilityblocks

Table Availabilityadjustments

Table Bills

Table Businesssegments

Table Cashiers

Table Cashiertransactions

Table Commands

Table Companies

Table Companionships

Table Companycontracts

Table Configuration

Table Counters

Table Countries

Table Creditcards

Table Currencies

Table Customers

Table Departments

Table Devices

Table Exchangerates

Table Languages

Table Loyaltymemberships

Table Loyaltyprograms

Table Loyaltytiers

Table Messagethreads

Table Orderitems

Table Outletitems

Table Outlets

Table Payments

Table Paymentrequests

Table Products

Table Productcategories

Table Productserviceorders

Table Rates

Table Rategroups

Table Reservations

Table Reservationgroups

Table Resourceaccesstokens

Table Resourceblocks

Table Resources

Table Resourcecategories

Table Resourcefeatures

Table Restrictions

Table Rules

Table Routing Rules

Table Services

Table Sources

Table Sourceassignments

Table Serviceoverbookinglimits

Table Tasks

Table Taxenvironments

Table Taxation

Table Vouchers

Table Vouchercodes

Magical SQL for Mews 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 payment amount by currency

SQL query for Mews

Mews data model

Magical SQL for Mews 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 ?