Untitled query #85895

This query is marked as a draft This query has been published by CptViraj.

SQL

SELECT
    value_entity_id AS country_id,
    COUNT(*) AS usage_count
FROM
    wb_statement
JOIN
    wb_claim ON wb_claim.statement_id = wb_statement.statement_id
WHERE
    wb_claim.property_id = 17
GROUP BY
    value_entity_id
ORDER BY
    usage_count DESC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...