This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- examples, replace with yours | |
set print_images to ¬ | |
{"/Users/jeffsternberg/Desktop/catalog/image_1.psd", ¬ | |
"/Users/jeffsternberg/Desktop/catalog/image_2.psd"} | |
-- main loop | |
repeat with print_image in print_images | |
process_image(print_image) | |
end repeat |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Which countries with the highest number of cases have the most per capita? | |
This query joins the Johns Hopkins dataset with the World Bank's global population data | |
to determine which countries among those with the highest total number of cases have the most cases per capita. | |
See https://console.cloud.google.com/marketplace/details/johnshopkins/covid19_jhu_global_cases | |
*/ | |
SELECT | |
cases.country_region AS country_region, | |
SUM(_3_30_20) AS total_cases, |