{"id":525,"date":"2026-07-06T03:14:55","date_gmt":"2026-07-06T03:14:55","guid":{"rendered":"http:\/\/77interactive.com\/?p=525"},"modified":"2026-07-09T23:38:42","modified_gmt":"2026-07-09T23:38:42","slug":"dvdrental-sample-database-query","status":"publish","type":"post","link":"http:\/\/77interactive.com\/?p=525","title":{"rendered":"DVDRental Sample Database Query"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">Query for larger DVDRental<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Revenue By Month<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>\nSET final = 1;\n\nSELECT\n    toStartOfMonth(payment_date) AS month,\n    count() AS payments,\n    round(sum(amount), 2) AS revenue,\n    round(avg(amount), 2) AS avg_payment\nFROM helloworld.public_payment\nWHERE _peerdb_is_deleted = 0\nGROUP BY month\nORDER BY month;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Top Customer by Lifetime Value<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    c.customer_id,\n    concat(c.first_name, ' ', c.last_name) AS customer_name,\n    c.email,\n    count(p.payment_id) AS payments,\n    round(sum(p.amount), 2) AS lifetime_value,\n    max(p.payment_date) AS last_payment_at\nFROM helloworld.public_customer c\nJOIN helloworld.public_payment p\n    ON p.customer_id = c.customer_id\nWHERE\n    c._peerdb_is_deleted = 0\n    AND p._peerdb_is_deleted = 0\nGROUP BY\n    c.customer_id,\n    customer_name,\n    c.email\nORDER BY lifetime_value DESC\nLIMIT 25;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Most Rented Film<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    f.film_id,\n    f.title,\n    c.name AS category,\n    count(r.rental_id) AS rental_count\nFROM helloworld.public_rental r\nJOIN helloworld.public_inventory i\n    ON i.inventory_id = r.inventory_id\nJOIN helloworld.public_film f\n    ON f.film_id = i.film_id\nJOIN helloworld.public_film_category fc\n    ON fc.film_id = f.film_id\nJOIN helloworld.public_category c\n    ON c.category_id = fc.category_id\nWHERE\n    r._peerdb_is_deleted = 0\n    AND i._peerdb_is_deleted = 0\n    AND f._peerdb_is_deleted = 0\n    AND fc._peerdb_is_deleted = 0\n    AND c._peerdb_is_deleted = 0\nGROUP BY\n    f.film_id,\n    f.title,\n    c.name\nORDER BY rental_count DESC\nLIMIT 20;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Rental Duration Distribution<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    quantile(0.5)(dateDiff('hour', rental_date, return_date)) AS p50_hours,\n    quantile(0.9)(dateDiff('hour', rental_date, return_date)) AS p90_hours,\n    quantile(0.99)(dateDiff('hour', rental_date, return_date)) AS p99_hours,\n    avg(dateDiff('hour', rental_date, return_date)) AS avg_hours\nFROM helloworld.public_rental\nWHERE\n    _peerdb_is_deleted = 0\n    AND return_date IS NOT NULL;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Customer with overdue or long rentals<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    c.customer_id,\n    concat(c.first_name, ' ', c.last_name) AS customer_name,\n    f.title,\n    r.rental_date,\n    r.return_date,\n    dateDiff('day', r.rental_date, coalesce(r.return_date, now())) AS rental_days\nFROM helloworld.public_rental r\nJOIN helloworld.public_customer c\n    ON c.customer_id = r.customer_id\nJOIN helloworld.public_inventory i\n    ON i.inventory_id = r.inventory_id\nJOIN helloworld.public_film f\n    ON f.film_id = i.film_id\nWHERE\n    r._peerdb_is_deleted = 0\n    AND c._peerdb_is_deleted = 0\n    AND i._peerdb_is_deleted = 0\n    AND f._peerdb_is_deleted = 0\n    AND dateDiff('day', r.rental_date, coalesce(r.return_date, now())) > 7\nORDER BY rental_days DESC\nLIMIT 50;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Revenue by Store and Month<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    s.store_id,\n    toStartOfMonth(p.payment_date) AS month,\n    count() AS payment_count,\n    round(sum(p.amount), 2) AS revenue\nFROM helloworld.public_payment p\nJOIN helloworld.public_staff st\n    ON st.staff_id = p.staff_id\nJOIN helloworld.public_store s\n    ON s.store_id = st.store_id\nWHERE\n    p._peerdb_is_deleted = 0\n    AND st._peerdb_is_deleted = 0\n    AND s._peerdb_is_deleted = 0\nGROUP BY\n    s.store_id,\n    month\nORDER BY\n    month,\n    s.store_id;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Category Mix by Revenue<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    cat.name AS category,\n    countDistinct(r.rental_id) AS rentals,\n    round(sum(p.amount), 2) AS revenue,\n    round(revenue \/ rentals, 2) AS revenue_per_rental\nFROM helloworld.public_payment p\nJOIN helloworld.public_rental r\n    ON r.rental_id = p.rental_id\nJOIN helloworld.public_inventory i\n    ON i.inventory_id = r.inventory_id\nJOIN helloworld.public_film_category fc\n    ON fc.film_id = i.film_id\nJOIN helloworld.public_category cat\n    ON cat.category_id = fc.category_id\nWHERE\n    p._peerdb_is_deleted = 0\n    AND r._peerdb_is_deleted = 0\n    AND i._peerdb_is_deleted = 0\n    AND fc._peerdb_is_deleted = 0\n    AND cat._peerdb_is_deleted = 0\nGROUP BY cat.name\nORDER BY revenue DESC;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Actor by Popularity by Rental<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    a.actor_id,\n    concat(a.first_name, ' ', a.last_name) AS actor_name,\n    countDistinct(f.film_id) AS film_count,\n    count(r.rental_id) AS rental_count\nFROM helloworld.public_actor a\nJOIN helloworld.public_film_actor fa\n    ON fa.actor_id = a.actor_id\nJOIN helloworld.public_film f\n    ON f.film_id = fa.film_id\nJOIN helloworld.public_inventory i\n    ON i.film_id = f.film_id\nJOIN helloworld.public_rental r\n    ON r.inventory_id = i.inventory_id\nWHERE\n    a._peerdb_is_deleted = 0\n    AND fa._peerdb_is_deleted = 0\n    AND f._peerdb_is_deleted = 0\n    AND i._peerdb_is_deleted = 0\n    AND r._peerdb_is_deleted = 0\nGROUP BY\n    a.actor_id,\n    actor_name\nORDER BY rental_count DESC\nLIMIT 25;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Customer Cohort by first rental month<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>WITH first_rental AS\n(\n    SELECT\n        customer_id,\n        toStartOfMonth(min(rental_date)) AS cohort_month\n    FROM helloworld.public_rental\n    WHERE _peerdb_is_deleted = 0\n    GROUP BY customer_id\n)\nSELECT\n    fr.cohort_month,\n    toStartOfMonth(r.rental_date) AS activity_month,\n    dateDiff('month', fr.cohort_month, toStartOfMonth(r.rental_date)) AS cohort_age_months,\n    countDistinct(r.customer_id) AS active_customers,\n    count() AS rentals\nFROM helloworld.public_rental r\nJOIN first_rental fr\n    ON fr.customer_id = r.customer_id\nWHERE r._peerdb_is_deleted = 0\nGROUP BY\n    fr.cohort_month,\n    activity_month,\n    cohort_age_months\nORDER BY\n    fr.cohort_month,\n    cohort_age_months;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">CDC Sanity Check<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    table,\n    sum(rows) AS rows_on_disk\nFROM system.parts\nWHERE\n    database = 'helloworld'\n    AND active\n    AND table LIKE 'public_%'\nGROUP BY table\nORDER BY rows_on_disk DESC;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">a kawaii DVD box holding some popcorn and wearing 3d glasses<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Query for larger DVDRental Revenue By Month Top Customer by Lifetime Value Most Rented Film Rental Duration Distribution Customer with overdue or long rentals Revenue by Store and Month Category Mix by Revenue Actor by Popularity by Rental Customer Cohort by first rental month CDC Sanity Check a kawaii DVD box holding some popcorn and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":526,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-525","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DVDRental Sample Database Query - 77 Interactive<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/77interactive.com\/?p=525\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DVDRental Sample Database Query - 77 Interactive\" \/>\n<meta property=\"og:description\" content=\"Query for larger DVDRental Revenue By Month Top Customer by Lifetime Value Most Rented Film Rental Duration Distribution Customer with overdue or long rentals Revenue by Store and Month Category Mix by Revenue Actor by Popularity by Rental Customer Cohort by first rental month CDC Sanity Check a kawaii DVD box holding some popcorn and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/77interactive.com\/?p=525\" \/>\n<meta property=\"og:site_name\" content=\"77 Interactive\" \/>\n<meta property=\"article:published_time\" content=\"2026-07-06T03:14:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-09T23:38:42+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/77interactive.com\/wp-content\/uploads\/2026\/07\/dvds-819x1024.png\" \/>\n\t<meta property=\"og:image:width\" content=\"819\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Rudy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rudy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/77interactive.com\\\/?p=525#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/77interactive.com\\\/?p=525\"},\"author\":{\"name\":\"Rudy\",\"@id\":\"http:\\\/\\\/77interactive.com\\\/#\\\/schema\\\/person\\\/daeb24287ed39e2ad4438b5e3469341f\"},\"headline\":\"DVDRental Sample Database Query\",\"datePublished\":\"2026-07-06T03:14:55+00:00\",\"dateModified\":\"2026-07-09T23:38:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/77interactive.com\\\/?p=525\"},\"wordCount\":62,\"image\":{\"@id\":\"http:\\\/\\\/77interactive.com\\\/?p=525#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/77interactive.com\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/dvds.png\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/77interactive.com\\\/?p=525\",\"url\":\"http:\\\/\\\/77interactive.com\\\/?p=525\",\"name\":\"DVDRental Sample Database Query - 77 Interactive\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/77interactive.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/77interactive.com\\\/?p=525#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/77interactive.com\\\/?p=525#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/77interactive.com\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/dvds.png\",\"datePublished\":\"2026-07-06T03:14:55+00:00\",\"dateModified\":\"2026-07-09T23:38:42+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/77interactive.com\\\/#\\\/schema\\\/person\\\/daeb24287ed39e2ad4438b5e3469341f\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/77interactive.com\\\/?p=525#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/77interactive.com\\\/?p=525\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/77interactive.com\\\/?p=525#primaryimage\",\"url\":\"http:\\\/\\\/77interactive.com\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/dvds.png\",\"contentUrl\":\"http:\\\/\\\/77interactive.com\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/dvds.png\",\"width\":1122,\"height\":1402,\"caption\":\"DVDS\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/77interactive.com\\\/?p=525#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/77interactive.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DVDRental Sample Database Query\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/77interactive.com\\\/#website\",\"url\":\"http:\\\/\\\/77interactive.com\\\/\",\"name\":\"77 Interactive\",\"description\":\"Rudy&#039;s Code snippets\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/77interactive.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/77interactive.com\\\/#\\\/schema\\\/person\\\/daeb24287ed39e2ad4438b5e3469341f\",\"name\":\"Rudy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e336b9aecd39b40691ff8ccfcd68506415072dbe8caffc0485b94a1bc22b774d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e336b9aecd39b40691ff8ccfcd68506415072dbe8caffc0485b94a1bc22b774d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e336b9aecd39b40691ff8ccfcd68506415072dbe8caffc0485b94a1bc22b774d?s=96&d=mm&r=g\",\"caption\":\"Rudy\"},\"url\":\"http:\\\/\\\/77interactive.com\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DVDRental Sample Database Query - 77 Interactive","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/77interactive.com\/?p=525","og_locale":"en_US","og_type":"article","og_title":"DVDRental Sample Database Query - 77 Interactive","og_description":"Query for larger DVDRental Revenue By Month Top Customer by Lifetime Value Most Rented Film Rental Duration Distribution Customer with overdue or long rentals Revenue by Store and Month Category Mix by Revenue Actor by Popularity by Rental Customer Cohort by first rental month CDC Sanity Check a kawaii DVD box holding some popcorn and [&hellip;]","og_url":"http:\/\/77interactive.com\/?p=525","og_site_name":"77 Interactive","article_published_time":"2026-07-06T03:14:55+00:00","article_modified_time":"2026-07-09T23:38:42+00:00","og_image":[{"width":819,"height":1024,"url":"http:\/\/77interactive.com\/wp-content\/uploads\/2026\/07\/dvds-819x1024.png","type":"image\/png"}],"author":"Rudy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rudy","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/77interactive.com\/?p=525#article","isPartOf":{"@id":"http:\/\/77interactive.com\/?p=525"},"author":{"name":"Rudy","@id":"http:\/\/77interactive.com\/#\/schema\/person\/daeb24287ed39e2ad4438b5e3469341f"},"headline":"DVDRental Sample Database Query","datePublished":"2026-07-06T03:14:55+00:00","dateModified":"2026-07-09T23:38:42+00:00","mainEntityOfPage":{"@id":"http:\/\/77interactive.com\/?p=525"},"wordCount":62,"image":{"@id":"http:\/\/77interactive.com\/?p=525#primaryimage"},"thumbnailUrl":"http:\/\/77interactive.com\/wp-content\/uploads\/2026\/07\/dvds.png","inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/77interactive.com\/?p=525","url":"http:\/\/77interactive.com\/?p=525","name":"DVDRental Sample Database Query - 77 Interactive","isPartOf":{"@id":"http:\/\/77interactive.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/77interactive.com\/?p=525#primaryimage"},"image":{"@id":"http:\/\/77interactive.com\/?p=525#primaryimage"},"thumbnailUrl":"http:\/\/77interactive.com\/wp-content\/uploads\/2026\/07\/dvds.png","datePublished":"2026-07-06T03:14:55+00:00","dateModified":"2026-07-09T23:38:42+00:00","author":{"@id":"http:\/\/77interactive.com\/#\/schema\/person\/daeb24287ed39e2ad4438b5e3469341f"},"breadcrumb":{"@id":"http:\/\/77interactive.com\/?p=525#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/77interactive.com\/?p=525"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/77interactive.com\/?p=525#primaryimage","url":"http:\/\/77interactive.com\/wp-content\/uploads\/2026\/07\/dvds.png","contentUrl":"http:\/\/77interactive.com\/wp-content\/uploads\/2026\/07\/dvds.png","width":1122,"height":1402,"caption":"DVDS"},{"@type":"BreadcrumbList","@id":"http:\/\/77interactive.com\/?p=525#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/77interactive.com\/"},{"@type":"ListItem","position":2,"name":"DVDRental Sample Database Query"}]},{"@type":"WebSite","@id":"http:\/\/77interactive.com\/#website","url":"http:\/\/77interactive.com\/","name":"77 Interactive","description":"Rudy&#039;s Code snippets","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/77interactive.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/77interactive.com\/#\/schema\/person\/daeb24287ed39e2ad4438b5e3469341f","name":"Rudy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e336b9aecd39b40691ff8ccfcd68506415072dbe8caffc0485b94a1bc22b774d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e336b9aecd39b40691ff8ccfcd68506415072dbe8caffc0485b94a1bc22b774d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e336b9aecd39b40691ff8ccfcd68506415072dbe8caffc0485b94a1bc22b774d?s=96&d=mm&r=g","caption":"Rudy"},"url":"http:\/\/77interactive.com\/?author=1"}]}},"_links":{"self":[{"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/posts\/525","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/77interactive.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=525"}],"version-history":[{"count":1,"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/posts\/525\/revisions"}],"predecessor-version":[{"id":527,"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/posts\/525\/revisions\/527"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/77interactive.com\/index.php?rest_route=\/wp\/v2\/media\/526"}],"wp:attachment":[{"href":"http:\/\/77interactive.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/77interactive.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=525"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/77interactive.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}