4 lines
348 B
SQL
4 lines
348 B
SQL
-- write a SQL query to count how many prints by Hiroshige have English titles that refer to the “Eastern Capital”.
|
||
-- Hiroshige’s prints were created in Japan’s “Edo period,” referencing the eastern capital city of Edo, now Tokyo.
|
||
SELECT COUNT(*) FROM "views" WHERE "artist" = "Hiroshige" AND "english_title" LIKE "%Eastern%Capital%";
|