Skip to main content
DevForge Academy
Tutorials
References
Exercises
Quizzes
More
Search
⌘K
Headmaster's Portfolio
Online Compiler
Html
Css
Javascript
Typescript
Python
Java
C
Cpp
Csharp
Php
Sql
Go
Kotlin
Rust
Bash
Swift
R
Mongodb
Redis
Postgresql
Cassandra
Dynamodb
Couchdb
Couchbase
Ferretdb
Examples
Reset
Run Code
// Couchbase N1QL (SQL for JSON) // Run locally: https://www.couchbase.com/downloads SELECT name, city, country FROM `travel-sample`.`_default`.`_default` WHERE type = "hotel" AND country = "United States" LIMIT 5; SELECT country, COUNT(*) AS hotel_count FROM `travel-sample`.`_default`.`_default` WHERE type = "hotel" GROUP BY country ORDER BY hotel_count DESC;
Output
Click "Run Code" to see output...