forked from kyagrd/introCS2018spring
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathHW4.html
117 lines (104 loc) · 20.6 KB
/
HW4.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
<meta charset="utf-8">
<title>Franchise Notebook a</title>
<!--
_______ ______ _______ __ _ _______ _ _ _____ _______ _______
|______ |_____/ |_____| | \ | | |_____| | |______ |______
| | \_ | | | \_| |_____ | | __|__ ______| |______
_______ _____
|______ | __| |
______| |____\| |_____
__ _ _____ _______ _______ ______ _____ _____ _ _
| \ | | | | |______ |_____] | | | | |____/
| \_| |_____| | |______ |_____] |_____| |_____| | \_
-->
<style>
body {
font-family: sans-serif;
padding: 100px;
background: #f7f7f7;
}
iframe {
position: absolute;
top: -10000px;
left: -10000px;
}
a {
font-size: large;
}
#click {
background: #2257d9;
padding: 20px;
color: white;
text-decoration: none;
border-radius: 3px;
}
/*https://projects.lukehaas.me/css-loaders/*/
.loader,
.loader:after {
border-radius: 50%;
width: 10em;
height: 10em;
}
.loader {
margin: 60px auto;
font-size: 10px;
position: relative;
text-indent: -9999em;
border-top: 1.1em solid rgba(34,87,217, 0.2);
border-right: 1.1em solid rgba(34,87,217, 0.2);
border-bottom: 1.1em solid rgba(34,87,217, 0.2);
border-left: 1.1em solid #2257d9;
-webkit-transform: translateZ(0);
-ms-transform: translateZ(0);
transform: translateZ(0);
-webkit-animation: load8 1.1s infinite linear;
animation: load8 1.1s infinite linear;
}
@-webkit-keyframes load8 {
0% {
-webkit-transform: rotate(0deg);
transform: rotate(0deg);
}
100% {
-webkit-transform: rotate(360deg);
transform: rotate(360deg);
}
}
@keyframes load8 {
0% {
-webkit-transform: rotate(0deg);
transform: rotate(0deg);
}
100% {
-webkit-transform: rotate(360deg);
transform: rotate(360deg);
}
}
</style>
<div class="loader" id="loader">Loading Franchise...</div>
<center><a id="click" style="display:none" href="https://franchise.cloud/app/" target="_blank">Click here to open Franchise SQL Notebook</a></center>
<script type="text/javascript">
const DATA = "{\"state\":{\"config\":{},\"connect\":{\"active\":\"sqlite\",\"status\":\"unconfigured\"},\"trash\":{\"open\":false,\"cells\":[]},\"deltas\":{\"open\":false,\"changes\":[]},\"notebook\":{\"layout\":[{\"rowId\":\"tdegpb0\",\"items\":[{\"query\":\"-- SQL에서 한줄 주석은 이렇게\\n/* 여러 줄 주석석은 요렇게 한다. 아래에 분반, 이름, 학번을 꼭 먼저 쓰고 나서 과제를 할 것.\\n분반:\\n이름:\\n학번:\\n*/ \\n\\nSELECT * FROM \\\"albums\\\" LEFT JOIN \\\"artists\\\" LIMIT 400\\n\",\"id\":\"zjvtzhs\",\"error\":null,\"suggestedName\":\"query2\",\"loading\":false,\"result\":{\"nameable\":true,\"columns\":[\"AlbumId\",\"Title\",\"ArtistId\",\"ArtistId\",\"Name\"],\"values\":[[1,\"For Those About To Rock We Salute You\",1,1,\"AC/DC\"],[1,\"For Those About To Rock We Salute You\",1,2,\"Accept\"],[1,\"For Those About To Rock We Salute You\",1,3,\"Aerosmith\"],[1,\"For Those About To Rock We Salute You\",1,4,\"Alanis Morissette\"],[1,\"For Those About To Rock We Salute You\",1,5,\"Alice In Chains\"],[1,\"For Those About To Rock We Salute You\",1,6,\"Antônio Carlos Jobim\"],[1,\"For Those About To Rock We Salute You\",1,7,\"Apocalyptica\"],[1,\"For Those About To Rock We Salute You\",1,8,\"Audioslave\"],[1,\"For Those About To Rock We Salute You\",1,9,\"BackBeat\"],[1,\"For Those About To Rock We Salute You\",1,10,\"Billy Cobham\"],[1,\"For Those About To Rock We Salute You\",1,11,\"Black Label Society\"],[1,\"For Those About To Rock We Salute You\",1,12,\"Black Sabbath\"],[1,\"For Those About To Rock We Salute You\",1,13,\"Body Count\"],[1,\"For Those About To Rock We Salute You\",1,14,\"Bruce Dickinson\"],[1,\"For Those About To Rock We Salute You\",1,15,\"Buddy Guy\"],[1,\"For Those About To Rock We Salute You\",1,16,\"Caetano Veloso\"],[1,\"For Those About To Rock We Salute You\",1,17,\"Chico Buarque\"],[1,\"For Those About To Rock We Salute You\",1,18,\"Chico Science & Nação Zumbi\"],[1,\"For Those About To Rock We Salute You\",1,19,\"Cidade Negra\"],[1,\"For Those About To Rock We Salute You\",1,20,\"Cláudio Zoli\"],[1,\"For Those About To Rock We Salute You\",1,21,\"Various Artists\"],[1,\"For Those About To Rock We Salute You\",1,22,\"Led Zeppelin\"],[1,\"For Those About To Rock We Salute You\",1,23,\"Frank Zappa & Captain Beefheart\"],[1,\"For Those About To Rock We Salute You\",1,24,\"Marcos Valle\"],[1,\"For Those About To Rock We Salute You\",1,25,\"Milton Nascimento & Bebeto\"],[1,\"For Those About To Rock We Salute You\",1,26,\"Azymuth\"],[1,\"For Those About To Rock We Salute You\",1,27,\"Gilberto Gil\"],[1,\"For Those About To Rock We Salute You\",1,28,\"João Gilberto\"],[1,\"For Those About To Rock We Salute You\",1,29,\"Bebel Gilberto\"],[1,\"For Those About To Rock We Salute You\",1,30,\"Jorge Vercilo\"],[1,\"For Those About To Rock We Salute You\",1,31,\"Baby Consuelo\"],[1,\"For Those About To Rock We Salute You\",1,32,\"Ney Matogrosso\"],[1,\"For Those About To Rock We Salute You\",1,33,\"Luiz Melodia\"],[1,\"For Those About To Rock We Salute You\",1,34,\"Nando Reis\"],[1,\"For Those About To Rock We Salute You\",1,35,\"Pedro Luís & A Parede\"],[1,\"For Those About To Rock We Salute You\",1,36,\"O Rappa\"],[1,\"For Those About To Rock We Salute You\",1,37,\"Ed Motta\"],[1,\"For Those About To Rock We Salute You\",1,38,\"Banda Black Rio\"],[1,\"For Those About To Rock We Salute You\",1,39,\"Fernanda Porto\"],[1,\"For Those About To Rock We Salute You\",1,40,\"Os Cariocas\"],[1,\"For Those About To Rock We Salute You\",1,41,\"Elis Regina\"],[1,\"For Those About To Rock We Salute You\",1,42,\"Milton Nascimento\"],[1,\"For Those About To Rock We Salute You\",1,43,\"A Cor Do Som\"],[1,\"For Those About To Rock We Salute You\",1,44,\"Kid Abelha\"],[1,\"For Those About To Rock We Salute You\",1,45,\"Sandra De Sá\"],[1,\"For Those About To Rock We Salute You\",1,46,\"Jorge Ben\"],[1,\"For Those About To Rock We Salute You\",1,47,\"Hermeto Pascoal\"],[1,\"For Those About To Rock We Salute You\",1,48,\"Barão Vermelho\"],[1,\"For Those About To Rock We Salute You\",1,49,\"Edson, DJ Marky & DJ Patife Featuring Fernanda Porto\"],[1,\"For Those About To Rock We Salute You\",1,50,\"Metallica\"],[1,\"For Those About To Rock We Salute You\",1,51,\"Queen\"],[1,\"For Those About To Rock We Salute You\",1,52,\"Kiss\"],[1,\"For Those About To Rock We Salute You\",1,53,\"Spyro Gyra\"],[1,\"For Those About To Rock We Salute You\",1,54,\"Green Day\"],[1,\"For Those About To Rock We Salute You\",1,55,\"David Coverdale\"],[1,\"For Those About To Rock We Salute You\",1,56,\"Gonzaguinha\"],[1,\"For Those About To Rock We Salute You\",1,57,\"Os Mutantes\"],[1,\"For Those About To Rock We Salute You\",1,58,\"Deep Purple\"],[1,\"For Those About To Rock We Salute You\",1,59,\"Santana\"],[1,\"For Those About To Rock We Salute You\",1,60,\"Santana Feat. Dave Matthews\"],[1,\"For Those About To Rock We Salute You\",1,61,\"Santana Feat. Everlast\"],[1,\"For Those About To Rock We Salute You\",1,62,\"Santana Feat. Rob Thomas\"],[1,\"For Those About To Rock We Salute You\",1,63,\"Santana Feat. Lauryn Hill & Cee-Lo\"],[1,\"For Those About To Rock We Salute You\",1,64,\"Santana Feat. The Project G&B\"],[1,\"For Those About To Rock We Salute You\",1,65,\"Santana Feat. Maná\"],[1,\"For Those About To Rock We Salute You\",1,66,\"Santana Feat. Eagle-Eye Cherry\"],[1,\"For Those About To Rock We Salute You\",1,67,\"Santana Feat. Eric Clapton\"],[1,\"For Those About To Rock We Salute You\",1,68,\"Miles Davis\"],[1,\"For Those About To Rock We Salute You\",1,69,\"Gene Krupa\"],[1,\"For Those About To Rock We Salute You\",1,70,\"Toquinho & Vinícius\"],[1,\"For Those About To Rock We Salute You\",1,71,\"Vinícius De Moraes & Baden Powell\"],[1,\"For Those About To Rock We Salute You\",1,72,\"Vinícius De Moraes\"],[1,\"For Those About To Rock We Salute You\",1,73,\"Vinícius E Qurteto Em Cy\"],[1,\"For Those About To Rock We Salute You\",1,74,\"Vinícius E Odette Lara\"],[1,\"For Those About To Rock We Salute You\",1,75,\"Vinicius, Toquinho & Quarteto Em Cy\"],[1,\"For Those About To Rock We Salute You\",1,76,\"Creedence Clearwater Revival\"],[1,\"For Those About To Rock We Salute You\",1,77,\"Cássia Eller\"],[1,\"For Those About To Rock We Salute You\",1,78,\"Def Leppard\"],[1,\"For Those About To Rock We Salute You\",1,79,\"Dennis Chambers\"],[1,\"For Those About To Rock We Salute You\",1,80,\"Djavan\"],[1,\"For Those About To Rock We Salute You\",1,81,\"Eric Clapton\"],[1,\"For Those About To Rock We Salute You\",1,82,\"Faith No More\"],[1,\"For Those About To Rock We Salute You\",1,83,\"Falamansa\"],[1,\"For Those About To Rock We Salute You\",1,84,\"Foo Fighters\"],[1,\"For Those About To Rock We Salute You\",1,85,\"Frank Sinatra\"],[1,\"For Those About To Rock We Salute You\",1,86,\"Funk Como Le Gusta\"],[1,\"For Those About To Rock We Salute You\",1,87,\"Godsmack\"],[1,\"For Those About To Rock We Salute You\",1,88,\"Guns N' Roses\"],[1,\"For Those About To Rock We Salute You\",1,89,\"Incognito\"],[1,\"For Those About To Rock We Salute You\",1,90,\"Iron Maiden\"],[1,\"For Those About To Rock We Salute You\",1,91,\"James Brown\"],[1,\"For Those About To Rock We Salute You\",1,92,\"Jamiroquai\"],[1,\"For Those About To Rock We Salute You\",1,93,\"JET\"],[1,\"For Those About To Rock We Salute You\",1,94,\"Jimi Hendrix\"],[1,\"For Those About To Rock We Salute You\",1,95,\"Joe Satriani\"],[1,\"For Those About To Rock We Salute You\",1,96,\"Jota Quest\"],[1,\"For Those About To Rock We Salute You\",1,97,\"João Suplicy\"],[1,\"For Those About To Rock We Salute You\",1,98,\"Judas Priest\"],[1,\"For Those About To Rock We Salute You\",1,99,\"Legião Urbana\"],[1,\"For Those About To Rock We Salute You\",1,100,\"Lenny Kravitz\"],[1,\"For Those About To Rock We Salute You\",1,101,\"Lulu Santos\"],[1,\"For Those About To Rock We Salute You\",1,102,\"Marillion\"],[1,\"For Those About To Rock We Salute You\",1,103,\"Marisa Monte\"],[1,\"For Those About To Rock We Salute You\",1,104,\"Marvin Gaye\"],[1,\"For Those About To Rock We Salute You\",1,105,\"Men At Work\"],[1,\"For Those About To Rock We Salute You\",1,106,\"Motörhead\"],[1,\"For Those About To Rock We Salute You\",1,107,\"Motörhead & Girlschool\"],[1,\"For Those About To Rock We Salute You\",1,108,\"Mônica Marianno\"],[1,\"For Those About To Rock We Salute You\",1,109,\"Mötley Crüe\"],[1,\"For Those About To Rock We Salute You\",1,110,\"Nirvana\"],[1,\"For Those About To Rock We Salute You\",1,111,\"O Terço\"],[1,\"For Those About To Rock We Salute You\",1,112,\"Olodum\"],[1,\"For Those About To Rock We Salute You\",1,113,\"Os Paralamas Do Sucesso\"],[1,\"For Those About To Rock We Salute You\",1,114,\"Ozzy Osbourne\"],[1,\"For Those About To Rock We Salute You\",1,115,\"Page & Plant\"],[1,\"For Those About To Rock We Salute You\",1,116,\"Passengers\"],[1,\"For Those About To Rock We Salute You\",1,117,\"Paul D'Ianno\"],[1,\"For Those About To Rock We Salute You\",1,118,\"Pearl Jam\"],[1,\"For Those About To Rock We Salute You\",1,119,\"Peter Tosh\"],[1,\"For Those About To Rock We Salute You\",1,120,\"Pink Floyd\"],[1,\"For Those About To Rock We Salute You\",1,121,\"Planet Hemp\"],[1,\"For Those About To Rock We Salute You\",1,122,\"R.E.M. Feat. Kate Pearson\"],[1,\"For Those About To Rock We Salute You\",1,123,\"R.E.M. Feat. KRS-One\"],[1,\"For Those About To Rock We Salute You\",1,124,\"R.E.M.\"],[1,\"For Those About To Rock We Salute You\",1,125,\"Raimundos\"],[1,\"For Those About To Rock We Salute You\",1,126,\"Raul Seixas\"],[1,\"For Those About To Rock We Salute You\",1,127,\"Red Hot Chili Peppers\"],[1,\"For Those About To Rock We Salute You\",1,128,\"Rush\"],[1,\"For Those About To Rock We Salute You\",1,129,\"Simply Red\"],[1,\"For Those About To Rock We Salute You\",1,130,\"Skank\"],[1,\"For Those About To Rock We Salute You\",1,131,\"Smashing Pumpkins\"],[1,\"For Those About To Rock We Salute You\",1,132,\"Soundgarden\"],[1,\"For Those About To Rock We Salute You\",1,133,\"Stevie Ray Vaughan & Double Trouble\"],[1,\"For Those About To Rock We Salute You\",1,134,\"Stone Temple Pilots\"],[1,\"For Those About To Rock We Salute You\",1,135,\"System Of A Down\"],[1,\"For Those About To Rock We Salute You\",1,136,\"Terry Bozzio, Tony Levin & Steve Stevens\"],[1,\"For Those About To Rock We Salute You\",1,137,\"The Black Crowes\"],[1,\"For Those About To Rock We Salute You\",1,138,\"The Clash\"],[1,\"For Those About To Rock We Salute You\",1,139,\"The Cult\"],[1,\"For Those About To Rock We Salute You\",1,140,\"The Doors\"],[1,\"For Those About To Rock We Salute You\",1,141,\"The Police\"],[1,\"For Those About To Rock We Salute You\",1,142,\"The Rolling Stones\"],[1,\"For Those About To Rock We Salute You\",1,143,\"The Tea Party\"],[1,\"For Those About To Rock We Salute You\",1,144,\"The Who\"],[1,\"For Those About To Rock We Salute You\",1,145,\"Tim Maia\"],[1,\"For Those About To Rock We Salute You\",1,146,\"Titãs\"],[1,\"For Those About To Rock We Salute You\",1,147,\"Battlestar Galactica\"],[1,\"For Those About To Rock We Salute You\",1,148,\"Heroes\"],[1,\"For Those About To Rock We Salute You\",1,149,\"Lost\"],[1,\"For Those About To Rock We Salute You\",1,150,\"U2\"],[1,\"For Those About To Rock We Salute You\",1,151,\"UB40\"],[1,\"For Those About To Rock We Salute You\",1,152,\"Van Halen\"],[1,\"For Those About To Rock We Salute You\",1,153,\"Velvet Revolver\"],[1,\"For Those About To Rock We Salute You\",1,154,\"Whitesnake\"],[1,\"For Those About To Rock We Salute You\",1,155,\"Zeca Pagodinho\"],[1,\"For Those About To Rock We Salute You\",1,156,\"The Office\"],[1,\"For Those About To Rock We Salute You\",1,157,\"Dread Zeppelin\"],[1,\"For Those About To Rock We Salute You\",1,158,\"Battlestar Galactica (Classic)\"],[1,\"For Those About To Rock We Salute You\",1,159,\"Aquaman\"],[1,\"For Those About To Rock We Salute You\",1,160,\"Christina Aguilera featuring BigElf\"],[1,\"For Those About To Rock We Salute You\",1,161,\"Aerosmith & Sierra Leone's Refugee Allstars\"],[1,\"For Those About To Rock We Salute You\",1,162,\"Los Lonely Boys\"],[1,\"For Those About To Rock We Salute You\",1,163,\"Corinne Bailey Rae\"],[1,\"For Those About To Rock We Salute You\",1,164,\"Dhani Harrison & Jakob Dylan\"],[1,\"For Those About To Rock We Salute You\",1,165,\"Jackson Browne\"],[1,\"For Those About To Rock We Salute You\",1,166,\"Avril Lavigne\"],[1,\"For Those About To Rock We Salute You\",1,167,\"Big & Rich\"],[1,\"For Those About To Rock We Salute You\",1,168,\"Youssou N'Dour\"],[1,\"For Those About To Rock We Salute You\",1,169,\"Black Eyed Peas\"],[1,\"For Those About To Rock We Salute You\",1,170,\"Jack Johnson\"],[1,\"For Those About To Rock We Salute You\",1,171,\"Ben Harper\"],[1,\"For Those About To Rock We Salute You\",1,172,\"Snow Patrol\"],[1,\"For Those About To Rock We Salute You\",1,173,\"Matisyahu\"],[1,\"For Those About To Rock We Salute You\",1,174,\"The Postal Service\"],[1,\"For Those About To Rock We Salute You\",1,175,\"Jaguares\"],[1,\"For Those About To Rock We Salute You\",1,176,\"The Flaming Lips\"],[1,\"For Those About To Rock We Salute You\",1,177,\"Jack's Mannequin & Mick Fleetwood\"],[1,\"For Those About To Rock We Salute You\",1,178,\"Regina Spektor\"],[1,\"For Those About To Rock We Salute You\",1,179,\"Scorpions\"],[1,\"For Those About To Rock We Salute You\",1,180,\"House Of Pain\"],[1,\"For Those About To Rock We Salute You\",1,181,\"Xis\"],[1,\"For Those About To Rock We Salute You\",1,182,\"Nega Gizza\"],[1,\"For Those About To Rock We Salute You\",1,183,\"Gustavo & Andres Veiga & Salazar\"],[1,\"For Those About To Rock We Salute You\",1,184,\"Rodox\"],[1,\"For Those About To Rock We Salute You\",1,185,\"Charlie Brown Jr.\"],[1,\"For Those About To Rock We Salute You\",1,186,\"Pedro Luís E A Parede\"],[1,\"For Those About To Rock We Salute You\",1,187,\"Los Hermanos\"],[1,\"For Those About To Rock We Salute You\",1,188,\"Mundo Livre S/A\"],[1,\"For Those About To Rock We Salute You\",1,189,\"Otto\"],[1,\"For Those About To Rock We Salute You\",1,190,\"Instituto\"],[1,\"For Those About To Rock We Salute You\",1,191,\"Nação Zumbi\"],[1,\"For Those About To Rock We Salute You\",1,192,\"DJ Dolores & Orchestra Santa Massa\"],[1,\"For Those About To Rock We Salute You\",1,193,\"Seu Jorge\"],[1,\"For Those About To Rock We Salute You\",1,194,\"Sabotage E Instituto\"],[1,\"For Those About To Rock We Salute You\",1,195,\"Stereo Maracana\"],[1,\"For Those About To Rock We Salute You\",1,196,\"Cake\"],[1,\"For Those About To Rock We Salute You\",1,197,\"Aisha Duo\"],[1,\"For Those About To Rock We Salute You\",1,198,\"Habib Koité and Bamada\"],[1,\"For Those About To Rock We Salute You\",1,199,\"Karsh Kale\"],[1,\"For Those About To Rock We Salute You\",1,200,\"The Posies\"]]}}]},{\"rowId\":\"fib0su2\",\"items\":[{\"query\":\"/* 문제 (1) : 1점\\n위의 LEFT JOIN을 이용한 쿼리는 albums 테이블과 artists 테이블을 아무런 제한 없이 마구 갖다붙이고 있다.\\n두 테이블에서 같은 AirtistId를 가진 튜플(또는 레코드)끼리 JOIN되도록 쿼리를 작성해서 실행하라.\\n그리고 AlbumId나 ArtistId는 보이지 않고 Title과 Name 두 개의 속성만 결과로 나오도록 쿼리를 작성하라.\\n\\n힌트:\\nSELECT \\\"Title\\\", \\\"Name\\\" FROM \\\"albums\\\" LEFT JOIN \\\"artists\\\" ON ...(여기에 JOIN 조건 작성)...\\n*/\",\"id\":\"1y12f2a\",\"loading\":false}]},{\"rowId\":\"tg02qjo\",\"items\":[{\"query\":\"\",\"id\":\"1h1drra\",\"loading\":false}]},{\"rowId\":\"kgyq74e\",\"items\":[{\"query\":\"/* 문제 (2) : 1점\\n문제(1)번의 쿼리에 ORDER BY를 추가하여 앨범 제목(Title) 오름차순(알파벳 순서, 사전순으로) 정렬되어 나오도록 쿼리를 작성해 실행하라.\\n*/\",\"id\":\"kttmgqv\",\"loading\":false}]},{\"rowId\":\"lp99rsb\",\"items\":[{\"query\":\"\",\"id\":\"3i6i2sm\",\"loading\":false}]},{\"rowId\":\"lio8mnv\",\"items\":[{\"query\":\"/* 문제 (3) : 1점\\n문제(1)번의 쿼리에 ORDER BY를 추가하여 앨범 제목(Title) 내림차순(알파벳 순서 반대, 사전의 역순으로)으로 정렬되어 나오도록 쿼리를 작성해 실행하라.\\n*/\",\"id\":\"6bp4v92\",\"loading\":false}]},{\"rowId\":\"rlgk1g3\",\"items\":[{\"query\":\"\",\"id\":\"b0pjxdt\",\"loading\":false}]},{\"rowId\":\"ha5xqzf\",\"items\":[{\"query\":\"/* 문제 (4) : 2점\\n문제(1)번의 쿼리에 ORDER BY를 추가하여 우선 아티스트 이름(Name) 오름차순으로 정렬되고\\n또 같은 아티스트의 앨범들끼리는 앨범 이름(Title) 오름차순 정렬되어 나오도록 쿼리를 작성해 실행하라.\\n*/\",\"id\":\"5zp4428\",\"loading\":false}]},{\"rowId\":\"j738vdc\",\"items\":[{\"query\":\"\",\"id\":\"hbngdih\",\"loading\":false}]},{\"rowId\":\"78s6ma3\",\"items\":[{\"query\":\"/* 문제 (5) : 2점\\n아티스트 별로 몇 개의 앨범이 albums 테이블에 등록되어 있는지\\n아티스트 이름(Name)과 그 아티스트의 앨범이 몇 개인지 개수 이렇게 두 개의 열로 이루어진 결과가 나오도록 쿼리를 작성해 실행하라\\n힌트: GROUP BY를 사용\\n*/\",\"id\":\"9t38kws\",\"loading\":false}]},{\"rowId\":\"borzysk\",\"items\":[{\"query\":\"\",\"id\":\"8k472r8\",\"loading\":false}]},{\"rowId\":\"9gqe5o3\",\"items\":[{\"query\":\"/* 문제 (6) : 1점\\n(5)번 문제의 결과와 같은 내용이지만 아티스트 이름 내림차순(알파벳 역순, 사전순 반대)으로 정렬되어 나오도록 쿼리를 작성해 실행하라\\n*/\",\"id\":\"blow2yl\",\"loading\":false}]},{\"rowId\":\"17y46aa\",\"items\":[{\"query\":\"\",\"id\":\"jibuu52\",\"loading\":false}]}],\"forceRenderToken\":23}},\"autoconnect\":false,\"version\":2}";
</script>
<script type="text/javascript">
function sendData(target, src){
console.log(src)
if(typeof DATA != 'undefined'){
target.postMessage(DATA, '*')
}
}
window.addEventListener("message", function(e){
console.log(e.data)
if(e.data == 'franchise-request-import'){
e.source.postMessage({ action: 'franchise-import', data: DATA }, '*')
}
}, false)
setTimeout(function(){
if(typeof DATA != 'undefined'){
document.getElementById('click').style.display = ''
document.getElementById('loader').style.display = 'none'
}
}, 1500);
</script>
<iframe src="http://localhost:3000/reciever.html" onload="sendData(this.contentWindow, this.src)"></iframe>
<iframe src="https://franchise.cloud/app/reciever.html" onload="sendData(this.contentWindow, this.src)"></iframe>