# How elasticsearch query should be written for the following SQL statement?

**URL:** <https://discuss.elastic.co/t/how-elasticsearch-query-should-be-written-for-the-following-sql-statement/196288>\
**Category:** Elasticsearch\
**Created:** [August 22, 2019, 9:44am UTC](https://discuss.elastic.co/t/how-elasticsearch-query-should-be-written-for-the-following-sql-statement/196288 "2019-08-22T09:44:59Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![wangqinghuan](https://avatars.discourse-cdn.com/v4/letter/w/d26b3c/32.png) [@wangqinghuan](https://discuss.elastic.co/u/wangqinghuan)\
**Post date:** [August 23, 2019, 2:59am UTC](https://discuss.elastic.co/t/how-elasticsearch-query-should-be-written-for-the-following-sql-statement/196288/10 "2019-08-23T02:59:37Z")

</div>

I am using Kibana 6.1.3.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/0/90b66868cbda60e2c09247963be6c13ba25a755e.png)

---

_[View the full topic](https://discuss.elastic.co/t/how-elasticsearch-query-should-be-written-for-the-following-sql-statement/196288)._