BaşlayınÜcretsiz Başlayın

JSONified

Semi-structured data can be challenging to query, so let's practice interacting with Yelpto's data once again.

Here, you will filter the contents of a VARIANT column.

Bu egzersiz

Introduction to Snowflake SQL

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

  • Filter where the DogsAllowed key in the attributes column is 'True' (note this is a string, not boolean).
  • Filter where the BusinessAcceptsCreditCards key in the attributes column is 'True' (note this is a string, not boolean).

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

SELECT business_id, name
FROM yelp_business_data
WHERE categories ILIKE '%Restaurant%'
	-- Filter where DogsAllowed is '%True%'
	AND ___ ___ '%True%'
    -- Filter where BusinessAcceptsCreditCards is '%True%'
    AND ___
    AND city ILIKE '%Philadelphia%'
    AND stars = 5
Kodu Düzenle ve Çalıştır