SNORQL | a ajaxy front-end for exploring triple stores | Data Manipulation library

I need to extract some data from DBpedia. I know that I can use http://dbpedia.org/snorql/ and write a query there and then see a result. But is there any tool/class to connect DBpedia endpoint from java, write query in a code and then get result in a file?

I think I found a bug with the BIND function of SPARQL in Virtuoso. I am running this in http://dbpedia.org/snorql/

Consider the following code:

I want to get all objects with seating capacity information on DBPedia. Optionally, I want to get their label, address, lat and lon information.

My issue is that I get a lot of duplicates even after filtering by language. How can I get distinct entries based on, say, 'address', or any other attribute?

Also, can you tell which part of this query can be improved so that my query doesn't time out when I use the public DBpedia endpoint? Thanks!

I want to get started using DBpedia. At the moment all I know is that DBpedia is a structured form of Wikipedia data and it can be queried using SPARQL. To me the basic idea of DBpedia (giving structure to wikipedia data) seems truly amazing, so please go easy if my question is basic.

My goal

Get simple data extracts from DBpedia. For example the countries of the world and their capitals and populations. Or get 100 random famous people, their dates and places of birth and a short description. Eventually I want to query the metadata to find what types of 'entity' are in DBpedia (eg mountains? Rivers? Cities?) and their 'properties'. But that is a separate question and I can experiment once I get the basics working.

What I found so far

In Google I found http://wiki.dbpedia.org/develop/getting-started but I think it's about installing all of DBpedia, and I only want to query it.

Also I found https://mickael.kerjean.me/2016/05/20/walkthrough-dbpedia-and-triplestore/ but it assumes you already have SPARQL or SNORQL set up, and I can't see how to do this.

Aso I found https://docs.data.world/tutorials/sparql/Your_First_Sparql_Query.html which is a guide to SPARQL but again it assumes you are using their own DataWorld environment.

On Stackoverflow I found List countries from DBpedia and List countries from DBpedia but again they assume you have set up the SPARQL environment.

Question(s)

1. What software do I use to write simple queries on DBpedia data - do I need SPARQL or SNORQL? Do I install them locally or can I use web-based tools? I use Windows 10 and I'm happy with SQL queries.
2. Once I have the software set up, what is the simplest query to get the list of countries of the world and capitals and populations?
3. Also how can I write a basic query to return (say) 100 random people and their basic details?

How do I count grouped entries in SPARQL, merging entries whose quantity is less than a specific factor?

Consider for example the Nobel Prize data. I could get a count of all family names with a query like

I'm wondering if Virtuoso has any built in features or packages that would let me expose a simple page where people can enter read-only SPARQL queries?

(sort of like this: http://dbpedia.org/snorql/)

I know if you log into conductor, there is a page to do this, but i'd like to provide a public access page that doesn't require logging in

I am trying to get the authors which have more than 3 books authored from DBPedia using this with the below:

I want to run a specific query at the LMDB SPARQL-Endpoint ( http://data.linkedmdb.org/snorql/ ). For some reason I can't get the link of movie that is returned.

My Query:

Here is the browse output of the following query to try to get singles that are in the billboard top 100: