# Generate a report of users with a positive bounce score

**URL:** https://meta.discourse.org/t/generate-a-report-of-users-with-a-positive-bounce-score/190441
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [May 14, 2021, 7:34pm UTC](https://meta.discourse.org/t/generate-a-report-of-users-with-a-positive-bounce-score/190441 "2021-05-14T19:34:19Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![supermathie](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/supermathie/32/507518_2.png) [@supermathie](https://meta.discourse.org/u/supermathie)
#### Post date: [May 14, 2021, 7:34pm UTC](https://meta.discourse.org/t/generate-a-report-of-users-with-a-positive-bounce-score/190441/1 "2021-05-14T19:34:19Z")

</div>

The following query shows the username, email address, and bounce score for users with a bounce score greater than 1:

```sql
SELECT users.username, user_emails.email, user_stats.bounce_score
FROM users
INNER JOIN user_stats ON users.id = user_stats.user_id
INNER JOIN user_emails ON users.id = user_emails.user_id
WHERE user_stats.bounce_score > 1
ORDER BY user_stats.bounce_score DESC

```