WordPress MySQL Query

Job ID: 32642519

Budget: $10 – $30 USD

Looking for someone to develop the below query:

Table(s) to be used: `bmw_postmeta` and `bmw_usermeta`

- `bmw_postmeta` : includes details about all WooCommerce Orders [Trashed, Completed, Pending, Cancelled] as well as Customer ID.

- `bmw_usermeta` : includes data about Wordpress users, such as name, and other custom fields.

Query: I want to a query created to pull ONLY completed orders and Customer ID from `bmw_postmeta` and have a JOIN with bmw_usermeta to pull their full name.

Work must be done through teamviewer only.

Needed ASAP