{ "text":"Write SQL statements to satisfy the following information requests",
"connection":"sql_book_connection",
"diagram":"canvas",
"schema":"canvas",
"owner":"atlas-query",
"scoreVisibility":["student","professor"],
"tasks":[{
"text":"Which museums are located in Russia? Show the museum's name and URL",
"start":"",
"key":["select name, url from museum where country='Russia'"],
"lines":12,
"points":10
},{
"text":"Which artists are from France or Germany. Show the artist's full name, style and nationality.",
"start":"",
"key":["select full_name, style, nationality from artist where nationality='French' or nationality='German'"],
"lines":12,
"points":10
}]
}
"connection":"sql_book_connection",
"diagram":"canvas",
"schema":"canvas",
"owner":"atlas-query",
"scoreVisibility":["student","professor"],
"tasks":[{
"text":"Which museums are located in Russia? Show the museum's name and URL",
"start":"",
"key":["select name, url from museum where country='Russia'"],
"lines":12,
"points":10
},{
"text":"Which artists are from France or Germany. Show the artist's full name, style and nationality.",
"start":"",
"key":["select full_name, style, nationality from artist where nationality='French' or nationality='German'"],
"lines":12,
"points":10
}]
}