# Data Explorer Query - Staff coverage

**URL:** <https://meta.discourse.org/t/data-explorer-query-staff-coverage/234241>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [July 28, 2022, 7:26am UTC](https://meta.discourse.org/t/data-explorer-query-staff-coverage/234241 "2022-07-28T07:26:18Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![michebs](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/michebs/32/190102_2.png) [@michebs](https://meta.discourse.org/u/michebs)\
**Post date:** [July 29, 2022, 9:09am UTC](https://meta.discourse.org/t/data-explorer-query-staff-coverage/234241/6 "2022-07-29T09:09:19Z")

</div>

This error seems to be linked to the absence of the last SELECT, line 27.

```sql
SELECT 
    total_posts, 
    staff_posts,
    ROUND((staff_posts/total_posts::decimal)*100,2) "staff_posts %"
FROM posts_data

```

Does this make sense?

---

_[View the full topic](https://meta.discourse.org/t/data-explorer-query-staff-coverage/234241)._