In [18]:
%%capture
%load_ext sql
%sql sqlite:///chinook.db
Out[18]:
'Connected: [email protected]'
In [19]:
%%%sql
SELECT
    name,
    type
FROM sqlite_master
WHERE type in ('table','view');
Done.
Out[19]:
name type
album table
artist table
customer table
employee table
genre table
invoice table
invoice_line table
media_type table
playlist table
playlist_track table
track table
In [20]:
%%%sql
SELECT * FROM genre;
Done.
Out[20]:
genre_id name
1 Rock
2 Jazz
3 Metal
4 Alternative & Punk
5 Rock And Roll
6 Blues
7 Latin
8 Reggae
9 Pop
10 Soundtrack
11 Bossa Nova
12 Easy Listening
13 Heavy Metal
14 R&B/Soul
15 Electronica/Dance
16 World
17 Hip Hop/Rap
18 Science Fiction
19 TV Shows
20 Sci Fi & Fantasy
21 Drama
22 Comedy
23 Alternative
24 Classical
25 Opera
In [21]:
%%%sql
SELECT * FROM invoice;
Done.
Out[21]:
invoice_id customer_id invoice_date billing_address billing_city billing_state billing_country billing_postal_code total
1 18 2017-01-03 00:00:00 627 Broadway New York NY USA 10012-2612 15.84
2 30 2017-01-03 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 9.9
3 40 2017-01-05 00:00:00 8, Rue Hanovre Paris None France 75002 1.98
4 18 2017-01-06 00:00:00 627 Broadway New York NY USA 10012-2612 7.92
5 27 2017-01-07 00:00:00 1033 N Park Ave Tucson AZ USA 85719 16.83
6 31 2017-01-10 00:00:00 194A Chain Lake Drive Halifax NS Canada B3S 1C5 1.98
7 49 2017-01-12 00:00:00 Ordynacka 10 Warsaw None Poland 00-358 10.89
8 59 2017-01-13 00:00:00 3,Raj Bhavan Road Bangalore None India 560001 9.9
9 18 2017-01-18 00:00:00 627 Broadway New York NY USA 10012-2612 8.91
10 31 2017-01-18 00:00:00 194A Chain Lake Drive Halifax NS Canada B3S 1C5 1.98
11 38 2017-01-20 00:00:00 Barbarossastraße 19 Berlin None Germany 10779 10.89
12 42 2017-01-21 00:00:00 9, Place Louis Barthou Bordeaux None France 33000 3.96
13 35 2017-01-22 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 0.99
14 25 2017-01-23 00:00:00 319 N. Frances Street Madison WI USA 53703 0.99
15 44 2017-01-25 00:00:00 Porthaninkatu 9 Helsinki None Finland 00530 3.96
16 1 2017-01-26 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 8.91
17 20 2017-01-28 00:00:00 541 Del Medio Avenue Mountain View CA USA 94040-111 10.89
18 24 2017-02-02 00:00:00 162 E Superior Street Chicago IL USA 60611 4.95
19 10 2017-02-06 00:00:00 Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 6.93
20 43 2017-02-06 00:00:00 68, Rue Jouvence Dijon None France 21000 9.9
21 9 2017-02-07 00:00:00 Sønder Boulevard 51 Copenhagen None Denmark 1720 8.91
22 35 2017-02-08 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 1.98
23 53 2017-02-09 00:00:00 113 Lupus St London None United Kingdom SW1V 3EN 9.9
24 4 2017-02-10 00:00:00 Ullevålsveien 14 Oslo None Norway 0171 11.879999999999999
25 39 2017-02-11 00:00:00 4, Rue Milton Paris None France 75009 7.92
26 55 2017-02-15 00:00:00 421 Bourke Street Sidney NSW Australia 2010 1.98
27 35 2017-02-15 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 7.92
28 12 2017-02-17 00:00:00 Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 2.9699999999999998
29 45 2017-02-17 00:00:00 Erzsébet krt. 58. Budapest None Hungary H-1073 5.9399999999999995
30 46 2017-02-18 00:00:00 3 Chatham Street Dublin Dublin Ireland None 10.89
31 3 2017-02-21 00:00:00 1498 rue Bélanger Montréal QC Canada H2G 1A7 19.8
32 30 2017-02-21 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 12.87
33 58 2017-02-21 00:00:00 12,Community Centre Delhi None India 110017 3.96
34 33 2017-02-23 00:00:00 5112 48 Street Yellowknife NT Canada X1A 1N6 0.99
35 34 2017-02-25 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 4.95
36 51 2017-02-27 00:00:00 Celsiusg. 9 Stockholm None Sweden 11230 6.93
37 59 2017-03-05 00:00:00 3,Raj Bhavan Road Bangalore None India 560001 9.9
38 49 2017-03-05 00:00:00 Ordynacka 10 Warsaw None Poland 00-358 6.93
39 39 2017-03-12 00:00:00 4, Rue Milton Paris None France 75009 7.92
40 37 2017-03-13 00:00:00 Berger Straße 10 Frankfurt None Germany 60316 9.9
41 50 2017-03-17 00:00:00 C/ San Bernardo 85 Madrid None Spain 28015 7.92
42 19 2017-03-18 00:00:00 1 Infinite Loop Cupertino CA USA 95014 8.91
43 22 2017-03-19 00:00:00 120 S Orange Ave Orlando FL USA 32801 6.93
44 21 2017-03-20 00:00:00 801 W 4th Street Reno NV USA 89503 11.879999999999999
45 36 2017-03-24 00:00:00 Tauentzienstraße 8 Berlin None Germany 10789 7.92
46 4 2017-03-24 00:00:00 Ullevålsveien 14 Oslo None Norway 0171 10.89
47 57 2017-03-25 00:00:00 Calle Lira, 198 Santiago None Chile None 5.9399999999999995
48 44 2017-03-28 00:00:00 Porthaninkatu 9 Helsinki None Finland 00530 3.96
49 10 2017-03-30 00:00:00 Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 4.95
50 18 2017-04-02 00:00:00 627 Broadway New York NY USA 10012-2612 6.93
51 19 2017-04-03 00:00:00 1 Infinite Loop Cupertino CA USA 95014 7.92
52 19 2017-04-11 00:00:00 1 Infinite Loop Cupertino CA USA 95014 11.879999999999999
53 43 2017-04-12 00:00:00 68, Rue Jouvence Dijon None France 21000 2.9699999999999998
54 26 2017-04-13 00:00:00 2211 W Berry Street Fort Worth TX USA 76110 17.82
55 33 2017-04-16 00:00:00 5112 48 Street Yellowknife NT Canada X1A 1N6 9.9
56 34 2017-04-22 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 16.83
57 19 2017-04-22 00:00:00 1 Infinite Loop Cupertino CA USA 95014 0.99
58 9 2017-04-23 00:00:00 Sønder Boulevard 51 Copenhagen None Denmark 1720 5.9399999999999995
59 38 2017-04-24 00:00:00 Barbarossastraße 19 Berlin None Germany 10779 10.89
60 15 2017-04-24 00:00:00 700 W Pender Street Vancouver BC Canada V6C 1G8 7.92
61 59 2017-04-24 00:00:00 3,Raj Bhavan Road Bangalore None India 560001 11.879999999999999
62 9 2017-04-25 00:00:00 Sønder Boulevard 51 Copenhagen None Denmark 1720 2.9699999999999998
63 31 2017-04-25 00:00:00 194A Chain Lake Drive Halifax NS Canada B3S 1C5 5.9399999999999995
64 52 2017-04-25 00:00:00 202 Hoxton Street London None United Kingdom N1 5LH 12.87
65 47 2017-04-26 00:00:00 Via Degli Scipioni, 43 Rome RM Italy 00192 1.98
66 16 2017-04-29 00:00:00 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 6.93
67 39 2017-05-01 00:00:00 4, Rue Milton Paris None France 75009 10.89
68 57 2017-05-01 00:00:00 Calle Lira, 198 Santiago None Chile None 10.89
69 2 2017-05-09 00:00:00 Theodor-Heuss-Straße 34 Stuttgart None Germany 70174 13.86
70 31 2017-05-13 00:00:00 194A Chain Lake Drive Halifax NS Canada B3S 1C5 0.99
71 3 2017-05-17 00:00:00 1498 rue Bélanger Montréal QC Canada H2G 1A7 16.83
72 47 2017-05-18 00:00:00 Via Degli Scipioni, 43 Rome RM Italy 00192 2.9699999999999998
73 13 2017-05-18 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 14.85
74 26 2017-05-18 00:00:00 2211 W Berry Street Fort Worth TX USA 76110 1.98
75 16 2017-05-24 00:00:00 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 3.96
76 40 2017-05-26 00:00:00 8, Rue Hanovre Paris None France 75002 12.87
77 1 2017-05-28 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 5.9399999999999995
78 5 2017-05-29 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 8.91
79 36 2017-06-08 00:00:00 Tauentzienstraße 8 Berlin None Germany 10789 13.86
80 13 2017-06-08 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 0.99
81 4 2017-06-12 00:00:00 Ullevålsveien 14 Oslo None Norway 0171 5.9399999999999995
82 58 2017-06-13 00:00:00 12,Community Centre Delhi None India 110017 6.93
83 22 2017-06-15 00:00:00 120 S Orange Ave Orlando FL USA 32801 3.96
84 48 2017-06-15 00:00:00 Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 11.879999999999999
85 33 2017-06-17 00:00:00 5112 48 Street Yellowknife NT Canada X1A 1N6 4.95
86 46 2017-06-18 00:00:00 3 Chatham Street Dublin Dublin Ireland None 0.99
87 30 2017-06-20 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 7.92
88 31 2017-06-21 00:00:00 194A Chain Lake Drive Halifax NS Canada B3S 1C5 4.95
89 21 2017-06-23 00:00:00 801 W 4th Street Reno NV USA 89503 1.98
90 55 2017-06-28 00:00:00 421 Bourke Street Sidney NSW Australia 2010 10.89
91 36 2017-07-01 00:00:00 Tauentzienstraße 8 Berlin None Germany 10789 10.89
92 32 2017-07-02 00:00:00 696 Osborne Street Winnipeg MB Canada R3L 2B9 19.8
93 42 2017-07-05 00:00:00 9, Place Louis Barthou Bordeaux None France 33000 9.9
94 51 2017-07-08 00:00:00 Celsiusg. 9 Stockholm None Sweden 11230 7.92
95 45 2017-07-10 00:00:00 Erzsébet krt. 58. Budapest None Hungary H-1073 10.89
96 53 2017-07-17 00:00:00 113 Lupus St London None United Kingdom SW1V 3EN 5.9399999999999995
97 8 2017-07-22 00:00:00 Grétrystraat 63 Brussels None Belgium 1000 5.9399999999999995
98 17 2017-07-23 00:00:00 1 Microsoft Way Redmond WA USA 98052-8300 9.9
99 55 2017-07-28 00:00:00 421 Bourke Street Sidney NSW Australia 2010 17.82
100 58 2017-07-31 00:00:00 12,Community Centre Delhi None India 110017 5.9399999999999995
101 20 2017-07-31 00:00:00 541 Del Medio Avenue Mountain View CA USA 94040-111 3.96
102 8 2017-08-02 00:00:00 Grétrystraat 63 Brussels None Belgium 1000 9.9
103 39 2017-08-03 00:00:00 4, Rue Milton Paris None France 75009 5.9399999999999995
104 4 2017-08-06 00:00:00 Ullevålsveien 14 Oslo None Norway 0171 1.98
105 31 2017-08-12 00:00:00 194A Chain Lake Drive Halifax NS Canada B3S 1C5 7.92
106 54 2017-08-19 00:00:00 110 Raeburn Pl Edinburgh None United Kingdom EH4 1HH 7.92
107 32 2017-08-21 00:00:00 696 Osborne Street Winnipeg MB Canada R3L 2B9 10.89
108 30 2017-08-27 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 4.95
109 22 2017-08-29 00:00:00 120 S Orange Ave Orlando FL USA 32801 10.89
110 15 2017-08-29 00:00:00 700 W Pender Street Vancouver BC Canada V6C 1G8 5.9399999999999995
111 13 2017-08-30 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 4.95
112 6 2017-08-31 00:00:00 Rilská 3174/6 Prague None Czech Republic 14300 16.83
113 13 2017-09-01 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 9.9
114 12 2017-09-05 00:00:00 Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 16.83
115 50 2017-09-08 00:00:00 C/ San Bernardo 85 Madrid None Spain 28015 8.91
116 6 2017-09-08 00:00:00 Rilská 3174/6 Prague None Czech Republic 14300 10.89
117 44 2017-09-10 00:00:00 Porthaninkatu 9 Helsinki None Finland 00530 10.89
118 28 2017-09-10 00:00:00 302 S 700 E Salt Lake City UT USA 84102 0.99
119 5 2017-09-12 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 1.98
120 29 2017-09-19 00:00:00 796 Dundas Street West Toronto ON Canada M6J 1V1 5.9399999999999995
121 59 2017-09-20 00:00:00 3,Raj Bhavan Road Bangalore None India 560001 8.91
122 9 2017-09-21 00:00:00 Sønder Boulevard 51 Copenhagen None Denmark 1720 4.95
123 7 2017-09-23 00:00:00 Rotenturmstraße 4, 1010 Innere Stadt Vienne None Austria 1010 11.879999999999999
124 8 2017-09-25 00:00:00 Grétrystraat 63 Brussels None Belgium 1000 5.9399999999999995
125 3 2017-09-29 00:00:00 1498 rue Bélanger Montréal QC Canada H2G 1A7 9.9
126 32 2017-10-07 00:00:00 696 Osborne Street Winnipeg MB Canada R3L 2B9 3.96
127 35 2017-10-08 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 10.89
128 17 2017-10-12 00:00:00 1 Microsoft Way Redmond WA USA 98052-8300 6.93
129 17 2017-10-16 00:00:00 1 Microsoft Way Redmond WA USA 98052-8300 10.89
130 13 2017-10-19 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 3.96
131 2 2017-10-21 00:00:00 Theodor-Heuss-Straße 34 Stuttgart None Germany 70174 2.9699999999999998
132 14 2017-10-22 00:00:00 8210 111 ST NW Edmonton AB Canada T6G 2C7 1.98
133 35 2017-10-22 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 9.9
134 2 2017-10-23 00:00:00 Theodor-Heuss-Straße 34 Stuttgart None Germany 70174 7.92
135 11 2017-10-25 00:00:00 Av. Paulista, 2022 São Paulo SP Brazil 01310-200 2.9699999999999998
136 33 2017-10-29 00:00:00 5112 48 Street Yellowknife NT Canada X1A 1N6 3.96
137 34 2017-10-29 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 1.98
138 33 2017-10-30 00:00:00 5112 48 Street Yellowknife NT Canada X1A 1N6 10.89
139 23 2017-11-03 00:00:00 69 Salem Street Boston MA USA 2113 4.95
140 58 2017-11-06 00:00:00 12,Community Centre Delhi None India 110017 7.92
141 45 2017-11-07 00:00:00 Erzsébet krt. 58. Budapest None Hungary H-1073 17.82
142 15 2017-11-10 00:00:00 700 W Pender Street Vancouver BC Canada V6C 1G8 14.85
143 25 2017-11-10 00:00:00 319 N. Frances Street Madison WI USA 53703 4.95
144 33 2017-11-18 00:00:00 5112 48 Street Yellowknife NT Canada X1A 1N6 2.9699999999999998
145 28 2017-11-22 00:00:00 302 S 700 E Salt Lake City UT USA 84102 4.95
146 58 2017-11-22 00:00:00 12,Community Centre Delhi None India 110017 12.87
147 19 2017-11-28 00:00:00 1 Infinite Loop Cupertino CA USA 95014 4.95
148 42 2017-11-30 00:00:00 9, Place Louis Barthou Bordeaux None France 33000 8.91
149 1 2017-11-30 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 8.91
150 22 2017-12-01 00:00:00 120 S Orange Ave Orlando FL USA 32801 2.9699999999999998
151 35 2017-12-06 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 2.9699999999999998
152 12 2017-12-12 00:00:00 Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 5.9399999999999995
153 1 2017-12-14 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 13.86
154 39 2017-12-17 00:00:00 4, Rue Milton Paris None France 75009 2.9699999999999998
155 59 2018-01-02 00:00:00 3,Raj Bhavan Road Bangalore None India 560001 8.91
156 10 2018-01-03 00:00:00 Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 10.89
157 57 2018-01-04 00:00:00 Calle Lira, 198 Santiago None Chile None 0.99
158 57 2018-01-07 00:00:00 Calle Lira, 198 Santiago None Chile None 5.9399999999999995
159 20 2018-01-08 00:00:00 541 Del Medio Avenue Mountain View CA USA 94040-111 5.9399999999999995
160 41 2018-01-09 00:00:00 11, Place Bellecour Lyon None France 69002 8.91
161 24 2018-01-13 00:00:00 162 E Superior Street Chicago IL USA 60611 7.92
162 2 2018-01-15 00:00:00 Theodor-Heuss-Straße 34 Stuttgart None Germany 70174 8.91
163 6 2018-01-16 00:00:00 Rilská 3174/6 Prague None Czech Republic 14300 8.91
164 49 2018-01-20 00:00:00 Ordynacka 10 Warsaw None Poland 00-358 3.96
165 41 2018-01-21 00:00:00 11, Place Bellecour Lyon None France 69002 7.92
166 17 2018-01-21 00:00:00 1 Microsoft Way Redmond WA USA 98052-8300 9.9
167 21 2018-01-25 00:00:00 801 W 4th Street Reno NV USA 89503 5.9399999999999995
168 47 2018-01-27 00:00:00 Via Degli Scipioni, 43 Rome RM Italy 00192 5.9399999999999995
169 21 2018-01-28 00:00:00 801 W 4th Street Reno NV USA 89503 8.91
170 45 2018-01-28 00:00:00 Erzsébet krt. 58. Budapest None Hungary H-1073 9.9
171 53 2018-01-30 00:00:00 113 Lupus St London None United Kingdom SW1V 3EN 12.87
172 33 2018-01-31 00:00:00 5112 48 Street Yellowknife NT Canada X1A 1N6 7.92
173 5 2018-01-31 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 10.89
174 48 2018-01-31 00:00:00 Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 6.93
175 39 2018-01-31 00:00:00 4, Rue Milton Paris None France 75009 17.82
176 46 2018-01-31 00:00:00 3 Chatham Street Dublin Dublin Ireland None 6.93
177 47 2018-02-01 00:00:00 Via Degli Scipioni, 43 Rome RM Italy 00192 1.98
178 9 2018-02-02 00:00:00 Sønder Boulevard 51 Copenhagen None Denmark 1720 2.9699999999999998
179 25 2018-02-03 00:00:00 319 N. Frances Street Madison WI USA 53703 9.9
180 46 2018-02-05 00:00:00 3 Chatham Street Dublin Dublin Ireland None 9.9
181 45 2018-02-06 00:00:00 Erzsébet krt. 58. Budapest None Hungary H-1073 6.93
182 1 2018-02-07 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 5.9399999999999995
183 42 2018-02-09 00:00:00 9, Place Louis Barthou Bordeaux None France 33000 23.759999999999998
184 1 2018-02-09 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 0.99
185 21 2018-02-10 00:00:00 801 W 4th Street Reno NV USA 89503 8.91
186 11 2018-02-10 00:00:00 Av. Paulista, 2022 São Paulo SP Brazil 01310-200 2.9699999999999998
187 18 2018-02-18 00:00:00 627 Broadway New York NY USA 10012-2612 6.93
188 13 2018-02-20 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 10.89
189 13 2018-02-21 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 3.96
190 51 2018-02-21 00:00:00 Celsiusg. 9 Stockholm None Sweden 11230 4.95
191 51 2018-02-22 00:00:00 Celsiusg. 9 Stockholm None Sweden 11230 3.96
192 28 2018-02-25 00:00:00 302 S 700 E Salt Lake City UT USA 84102 8.91
193 41 2018-02-26 00:00:00 11, Place Bellecour Lyon None France 69002 1.98
194 34 2018-02-27 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 0.99
195 27 2018-03-02 00:00:00 1033 N Park Ave Tucson AZ USA 85719 10.89
196 37 2018-03-02 00:00:00 Berger Straße 10 Frankfurt None Germany 60316 9.9
197 46 2018-03-05 00:00:00 3 Chatham Street Dublin Dublin Ireland None 10.89
198 13 2018-03-05 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 10.89
199 20 2018-03-08 00:00:00 541 Del Medio Avenue Mountain View CA USA 94040-111 2.9699999999999998
200 24 2018-03-08 00:00:00 162 E Superior Street Chicago IL USA 60611 7.92
201 39 2018-03-11 00:00:00 4, Rue Milton Paris None France 75009 11.879999999999999
202 25 2018-03-13 00:00:00 319 N. Frances Street Madison WI USA 53703 1.98
203 38 2018-03-16 00:00:00 Barbarossastraße 19 Berlin None Germany 10779 9.9
204 20 2018-03-17 00:00:00 541 Del Medio Avenue Mountain View CA USA 94040-111 10.89
205 4 2018-03-20 00:00:00 Ullevålsveien 14 Oslo None Norway 0171 9.9
206 11 2018-03-21 00:00:00 Av. Paulista, 2022 São Paulo SP Brazil 01310-200 4.95
207 17 2018-03-21 00:00:00 1 Microsoft Way Redmond WA USA 98052-8300 3.96
208 4 2018-03-22 00:00:00 Ullevålsveien 14 Oslo None Norway 0171 5.9399999999999995
209 27 2018-03-25 00:00:00 1033 N Park Ave Tucson AZ USA 85719 3.96
210 2 2018-03-25 00:00:00 Theodor-Heuss-Straße 34 Stuttgart None Germany 70174 10.89
211 51 2018-03-26 00:00:00 Celsiusg. 9 Stockholm None Sweden 11230 8.91
212 45 2018-03-31 00:00:00 Erzsébet krt. 58. Budapest None Hungary H-1073 11.879999999999999
213 53 2018-04-01 00:00:00 113 Lupus St London None United Kingdom SW1V 3EN 10.89
214 57 2018-04-03 00:00:00 Calle Lira, 198 Santiago None Chile None 4.95
215 26 2018-04-04 00:00:00 2211 W Berry Street Fort Worth TX USA 76110 1.98
216 49 2018-04-14 00:00:00 Ordynacka 10 Warsaw None Poland 00-358 4.95
217 27 2018-04-17 00:00:00 1033 N Park Ave Tucson AZ USA 85719 9.9
218 56 2018-04-19 00:00:00 307 Macacha Güemes Buenos Aires None Argentina 1106 8.91
219 20 2018-04-21 00:00:00 541 Del Medio Avenue Mountain View CA USA 94040-111 2.9699999999999998
220 59 2018-04-25 00:00:00 3,Raj Bhavan Road Bangalore None India 560001 8.91
221 35 2018-04-25 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 7.92
222 2 2018-04-29 00:00:00 Theodor-Heuss-Straße 34 Stuttgart None Germany 70174 1.98
223 1 2018-05-04 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 17.82
224 34 2018-05-06 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 9.9
225 7 2018-05-08 00:00:00 Rotenturmstraße 4, 1010 Innere Stadt Vienne None Austria 1010 5.9399999999999995
226 42 2018-05-12 00:00:00 9, Place Louis Barthou Bordeaux None France 33000 10.89
227 52 2018-05-16 00:00:00 202 Hoxton Street London None United Kingdom N1 5LH 9.9
228 57 2018-05-16 00:00:00 Calle Lira, 198 Santiago None Chile None 3.96
229 15 2018-05-19 00:00:00 700 W Pender Street Vancouver BC Canada V6C 1G8 2.9699999999999998
230 54 2018-05-21 00:00:00 110 Raeburn Pl Edinburgh None United Kingdom EH4 1HH 7.92
231 19 2018-05-27 00:00:00 1 Infinite Loop Cupertino CA USA 95014 2.9699999999999998
232 57 2018-05-29 00:00:00 Calle Lira, 198 Santiago None Chile None 3.96
233 14 2018-06-01 00:00:00 8210 111 ST NW Edmonton AB Canada T6G 2C7 5.9399999999999995
234 36 2018-06-01 00:00:00 Tauentzienstraße 8 Berlin None Germany 10789 0.99
235 5 2018-06-06 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 6.93
236 35 2018-06-08 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 2.9699999999999998
237 52 2018-06-13 00:00:00 202 Hoxton Street London None United Kingdom N1 5LH 15.84
238 46 2018-06-14 00:00:00 3 Chatham Street Dublin Dublin Ireland None 9.9
239 38 2018-06-16 00:00:00 Barbarossastraße 19 Berlin None Germany 10779 15.84
240 10 2018-06-17 00:00:00 Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 2.9699999999999998
241 45 2018-06-18 00:00:00 Erzsébet krt. 58. Budapest None Hungary H-1073 1.98
242 36 2018-06-18 00:00:00 Tauentzienstraße 8 Berlin None Germany 10789 9.9
243 6 2018-06-23 00:00:00 Rilská 3174/6 Prague None Czech Republic 14300 10.89
244 53 2018-06-23 00:00:00 113 Lupus St London None United Kingdom SW1V 3EN 4.95
245 20 2018-06-30 00:00:00 541 Del Medio Avenue Mountain View CA USA 94040-111 2.9699999999999998
246 58 2018-07-12 00:00:00 12,Community Centre Delhi None India 110017 8.91
247 27 2018-07-12 00:00:00 1033 N Park Ave Tucson AZ USA 85719 10.89
248 3 2018-07-13 00:00:00 1498 rue Bélanger Montréal QC Canada H2G 1A7 6.93
249 12 2018-07-14 00:00:00 Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 1.98
250 23 2018-07-20 00:00:00 69 Salem Street Boston MA USA 2113 10.89
251 7 2018-07-20 00:00:00 Rotenturmstraße 4, 1010 Innere Stadt Vienne None Austria 1010 6.93
252 44 2018-07-25 00:00:00 Porthaninkatu 9 Helsinki None Finland 00530 7.92
253 8 2018-07-29 00:00:00 Grétrystraat 63 Brussels None Belgium 1000 11.879999999999999
254 57 2018-07-30 00:00:00 Calle Lira, 198 Santiago None Chile None 9.9
255 46 2018-07-31 00:00:00 3 Chatham Street Dublin Dublin Ireland None 3.96
256 13 2018-07-31 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 4.95
257 16 2018-08-01 00:00:00 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 10.89
258 48 2018-08-02 00:00:00 Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 0.99
259 38 2018-08-03 00:00:00 Barbarossastraße 19 Berlin None Germany 10779 6.93
260 10 2018-08-04 00:00:00 Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 7.92
261 49 2018-08-06 00:00:00 Ordynacka 10 Warsaw None Poland 00-358 8.91
262 3 2018-08-09 00:00:00 1498 rue Bélanger Montréal QC Canada H2G 1A7 7.92
263 36 2018-08-13 00:00:00 Tauentzienstraße 8 Berlin None Germany 10789 4.95
264 38 2018-08-15 00:00:00 Barbarossastraße 19 Berlin None Germany 10779 0.99
265 52 2018-08-18 00:00:00 202 Hoxton Street London None United Kingdom N1 5LH 6.93
266 44 2018-08-22 00:00:00 Porthaninkatu 9 Helsinki None Finland 00530 5.9399999999999995
267 9 2018-08-22 00:00:00 Sønder Boulevard 51 Copenhagen None Denmark 1720 1.98
268 16 2018-08-23 00:00:00 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 10.89
269 43 2018-08-26 00:00:00 68, Rue Jouvence Dijon None France 21000 0.99
270 1 2018-08-27 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 10.89
271 47 2018-08-30 00:00:00 Via Degli Scipioni, 43 Rome RM Italy 00192 10.89
272 4 2018-08-30 00:00:00 Ullevålsveien 14 Oslo None Norway 0171 8.91
273 37 2018-09-02 00:00:00 Berger Straße 10 Frankfurt None Germany 60316 16.83
274 26 2018-09-04 00:00:00 2211 W Berry Street Fort Worth TX USA 76110 4.95
275 6 2018-09-06 00:00:00 Rilská 3174/6 Prague None Czech Republic 14300 7.92
276 22 2018-09-07 00:00:00 120 S Orange Ave Orlando FL USA 32801 18.81
277 53 2018-09-10 00:00:00 113 Lupus St London None United Kingdom SW1V 3EN 4.95
278 22 2018-09-23 00:00:00 120 S Orange Ave Orlando FL USA 32801 2.9699999999999998
279 41 2018-10-01 00:00:00 11, Place Bellecour Lyon None France 69002 4.95
280 6 2018-10-02 00:00:00 Rilská 3174/6 Prague None Czech Republic 14300 10.89
281 50 2018-10-06 00:00:00 C/ San Bernardo 85 Madrid None Spain 28015 13.86
282 20 2018-10-11 00:00:00 541 Del Medio Avenue Mountain View CA USA 94040-111 16.83
283 48 2018-10-13 00:00:00 Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 8.91
284 49 2018-10-16 00:00:00 Ordynacka 10 Warsaw None Poland 00-358 10.89
285 58 2018-10-25 00:00:00 12,Community Centre Delhi None India 110017 9.9
286 27 2018-10-25 00:00:00 1033 N Park Ave Tucson AZ USA 85719 1.98
287 23 2018-11-04 00:00:00 69 Salem Street Boston MA USA 2113 1.98
288 17 2018-11-04 00:00:00 1 Microsoft Way Redmond WA USA 98052-8300 10.89
289 16 2018-11-06 00:00:00 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 6.93
290 17 2018-11-18 00:00:00 1 Microsoft Way Redmond WA USA 98052-8300 4.95
291 35 2018-11-19 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 2.9699999999999998
292 4 2018-11-21 00:00:00 Ullevålsveien 14 Oslo None Norway 0171 9.9
293 14 2018-11-29 00:00:00 8210 111 ST NW Edmonton AB Canada T6G 2C7 4.95
294 58 2018-12-02 00:00:00 12,Community Centre Delhi None India 110017 10.89
295 33 2018-12-03 00:00:00 5112 48 Street Yellowknife NT Canada X1A 1N6 0.99
296 1 2018-12-10 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 12.87
297 22 2018-12-11 00:00:00 120 S Orange Ave Orlando FL USA 32801 2.9699999999999998
298 12 2018-12-13 00:00:00 Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 8.91
299 30 2018-12-14 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 5.9399999999999995
300 25 2018-12-15 00:00:00 319 N. Frances Street Madison WI USA 53703 11.879999999999999
301 34 2018-12-15 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 7.92
302 40 2018-12-18 00:00:00 8, Rue Hanovre Paris None France 75002 3.96
303 28 2018-12-21 00:00:00 302 S 700 E Salt Lake City UT USA 84102 9.9
304 56 2018-12-23 00:00:00 307 Macacha Güemes Buenos Aires None Argentina 1106 6.93
305 40 2018-12-26 00:00:00 8, Rue Hanovre Paris None France 75002 14.85
306 8 2019-01-01 00:00:00 Grétrystraat 63 Brussels None Belgium 1000 10.89
307 26 2019-01-05 00:00:00 2211 W Berry Street Fort Worth TX USA 76110 9.9
308 37 2019-01-06 00:00:00 Berger Straße 10 Frankfurt None Germany 60316 10.89
309 36 2019-01-14 00:00:00 Tauentzienstraße 8 Berlin None Germany 10789 8.91
310 22 2019-01-16 00:00:00 120 S Orange Ave Orlando FL USA 32801 8.91
311 8 2019-01-18 00:00:00 Grétrystraat 63 Brussels None Belgium 1000 5.9399999999999995
312 42 2019-01-21 00:00:00 9, Place Louis Barthou Bordeaux None France 33000 9.9
313 30 2019-01-24 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 4.95
314 43 2019-01-29 00:00:00 68, Rue Jouvence Dijon None France 21000 9.9
315 10 2019-01-30 00:00:00 Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 4.95
316 11 2019-02-03 00:00:00 Av. Paulista, 2022 São Paulo SP Brazil 01310-200 1.98
317 40 2019-02-14 00:00:00 8, Rue Hanovre Paris None France 75002 11.879999999999999
318 43 2019-02-19 00:00:00 68, Rue Jouvence Dijon None France 21000 7.92
319 50 2019-02-20 00:00:00 C/ San Bernardo 85 Madrid None Spain 28015 9.9
320 58 2019-02-22 00:00:00 12,Community Centre Delhi None India 110017 16.83
321 14 2019-02-23 00:00:00 8210 111 ST NW Edmonton AB Canada T6G 2C7 0.99
322 21 2019-02-24 00:00:00 801 W 4th Street Reno NV USA 89503 9.9
323 23 2019-03-03 00:00:00 69 Salem Street Boston MA USA 2113 7.92
324 57 2019-03-03 00:00:00 Calle Lira, 198 Santiago None Chile None 4.95
325 33 2019-03-04 00:00:00 5112 48 Street Yellowknife NT Canada X1A 1N6 9.9
326 52 2019-03-04 00:00:00 202 Hoxton Street London None United Kingdom N1 5LH 8.91
327 49 2019-03-05 00:00:00 Ordynacka 10 Warsaw None Poland 00-358 8.91
328 10 2019-03-08 00:00:00 Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 3.96
329 9 2019-03-09 00:00:00 Sønder Boulevard 51 Copenhagen None Denmark 1720 0.99
330 22 2019-03-13 00:00:00 120 S Orange Ave Orlando FL USA 32801 12.87
331 25 2019-03-15 00:00:00 319 N. Frances Street Madison WI USA 53703 5.9399999999999995
332 29 2019-03-15 00:00:00 796 Dundas Street West Toronto ON Canada M6J 1V1 9.9
333 12 2019-03-21 00:00:00 Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 5.9399999999999995
334 53 2019-03-21 00:00:00 113 Lupus St London None United Kingdom SW1V 3EN 14.85
335 57 2019-03-23 00:00:00 Calle Lira, 198 Santiago None Chile None 14.85
336 6 2019-03-31 00:00:00 Rilská 3174/6 Prague None Czech Republic 14300 15.84
337 7 2019-04-03 00:00:00 Rotenturmstraße 4, 1010 Innere Stadt Vienne None Austria 1010 9.9
338 58 2019-04-03 00:00:00 12,Community Centre Delhi None India 110017 4.95
339 36 2019-04-07 00:00:00 Tauentzienstraße 8 Berlin None Germany 10789 7.92
340 48 2019-04-08 00:00:00 Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 2.9699999999999998
341 5 2019-04-09 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 11.879999999999999
342 3 2019-04-13 00:00:00 1498 rue Bélanger Montréal QC Canada H2G 1A7 2.9699999999999998
343 2 2019-04-13 00:00:00 Theodor-Heuss-Straße 34 Stuttgart None Germany 70174 5.9399999999999995
344 3 2019-04-15 00:00:00 1498 rue Bélanger Montréal QC Canada H2G 1A7 16.83
345 50 2019-04-16 00:00:00 C/ San Bernardo 85 Madrid None Spain 28015 9.9
346 40 2019-04-17 00:00:00 8, Rue Hanovre Paris None France 75002 5.9399999999999995
347 44 2019-04-17 00:00:00 Porthaninkatu 9 Helsinki None Finland 00530 3.96
348 35 2019-04-18 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 8.91
349 37 2019-04-21 00:00:00 Berger Straße 10 Frankfurt None Germany 60316 0.99
350 44 2019-04-21 00:00:00 Porthaninkatu 9 Helsinki None Finland 00530 2.9699999999999998
351 57 2019-04-23 00:00:00 Calle Lira, 198 Santiago None Chile None 9.9
352 10 2019-04-23 00:00:00 Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 0.99
353 28 2019-04-28 00:00:00 302 S 700 E Salt Lake City UT USA 84102 9.9
354 9 2019-05-02 00:00:00 Sønder Boulevard 51 Copenhagen None Denmark 1720 4.95
355 43 2019-05-04 00:00:00 68, Rue Jouvence Dijon None France 21000 6.93
356 55 2019-05-04 00:00:00 421 Bourke Street Sidney NSW Australia 2010 6.93
357 13 2019-05-08 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 2.9699999999999998
358 19 2019-05-12 00:00:00 1 Infinite Loop Cupertino CA USA 95014 6.93
359 43 2019-05-12 00:00:00 68, Rue Jouvence Dijon None France 21000 8.91
360 45 2019-05-15 00:00:00 Erzsébet krt. 58. Budapest None Hungary H-1073 3.96
361 5 2019-05-18 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 1.98
362 29 2019-05-24 00:00:00 796 Dundas Street West Toronto ON Canada M6J 1V1 19.8
363 38 2019-05-24 00:00:00 Barbarossastraße 19 Berlin None Germany 10779 2.9699999999999998
364 26 2019-05-26 00:00:00 2211 W Berry Street Fort Worth TX USA 76110 5.9399999999999995
365 28 2019-05-27 00:00:00 302 S 700 E Salt Lake City UT USA 84102 3.96
366 26 2019-05-27 00:00:00 2211 W Berry Street Fort Worth TX USA 76110 8.91
367 40 2019-05-29 00:00:00 8, Rue Hanovre Paris None France 75002 7.92
368 35 2019-05-30 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 1.98
369 50 2019-05-31 00:00:00 C/ San Bernardo 85 Madrid None Spain 28015 9.9
370 14 2019-06-01 00:00:00 8210 111 ST NW Edmonton AB Canada T6G 2C7 8.91
371 14 2019-06-01 00:00:00 8210 111 ST NW Edmonton AB Canada T6G 2C7 0.99
372 18 2019-06-01 00:00:00 627 Broadway New York NY USA 10012-2612 13.86
373 39 2019-06-01 00:00:00 4, Rue Milton Paris None France 75009 3.96
374 43 2019-06-03 00:00:00 68, Rue Jouvence Dijon None France 21000 5.9399999999999995
375 35 2019-06-05 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 8.91
376 5 2019-06-06 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 3.96
377 28 2019-06-09 00:00:00 302 S 700 E Salt Lake City UT USA 84102 2.9699999999999998
378 48 2019-06-13 00:00:00 Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 3.96
379 54 2019-06-13 00:00:00 110 Raeburn Pl Edinburgh None United Kingdom EH4 1HH 11.879999999999999
380 56 2019-06-14 00:00:00 307 Macacha Güemes Buenos Aires None Argentina 1106 9.9
381 56 2019-06-21 00:00:00 307 Macacha Güemes Buenos Aires None Argentina 1106 12.87
382 48 2019-06-22 00:00:00 Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 3.96
383 23 2019-07-03 00:00:00 69 Salem Street Boston MA USA 2113 9.9
384 50 2019-07-10 00:00:00 C/ San Bernardo 85 Madrid None Spain 28015 10.89
385 42 2019-07-11 00:00:00 9, Place Louis Barthou Bordeaux None France 33000 6.93
386 26 2019-07-12 00:00:00 2211 W Berry Street Fort Worth TX USA 76110 4.95
387 6 2019-07-15 00:00:00 Rilská 3174/6 Prague None Czech Republic 14300 5.9399999999999995
388 5 2019-07-16 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 9.9
389 16 2019-07-18 00:00:00 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 16.83
390 34 2019-07-19 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 2.9699999999999998
391 30 2019-07-20 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 3.96
392 11 2019-07-24 00:00:00 Av. Paulista, 2022 São Paulo SP Brazil 01310-200 7.92
393 17 2019-07-25 00:00:00 1 Microsoft Way Redmond WA USA 98052-8300 10.89
394 31 2019-07-27 00:00:00 194A Chain Lake Drive Halifax NS Canada B3S 1C5 7.92
395 24 2019-07-28 00:00:00 162 E Superior Street Chicago IL USA 60611 9.9
396 42 2019-07-29 00:00:00 9, Place Louis Barthou Bordeaux None France 33000 8.91
397 36 2019-07-31 00:00:00 Tauentzienstraße 8 Berlin None Germany 10789 6.93
398 51 2019-08-03 00:00:00 Celsiusg. 9 Stockholm None Sweden 11230 16.83
399 51 2019-08-03 00:00:00 Celsiusg. 9 Stockholm None Sweden 11230 11.879999999999999
400 36 2019-08-06 00:00:00 Tauentzienstraße 8 Berlin None Germany 10789 3.96
401 46 2019-08-06 00:00:00 3 Chatham Street Dublin Dublin Ireland None 9.9
402 54 2019-08-09 00:00:00 110 Raeburn Pl Edinburgh None United Kingdom EH4 1HH 8.91
403 54 2019-08-10 00:00:00 110 Raeburn Pl Edinburgh None United Kingdom EH4 1HH 8.91
404 31 2019-08-13 00:00:00 194A Chain Lake Drive Halifax NS Canada B3S 1C5 13.86
405 6 2019-08-14 00:00:00 Rilská 3174/6 Prague None Czech Republic 14300 7.92
406 10 2019-08-15 00:00:00 Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 1.98
407 57 2019-08-19 00:00:00 Calle Lira, 198 Santiago None Chile None 9.9
408 34 2019-08-20 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 5.9399999999999995
409 48 2019-08-24 00:00:00 Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 10.89
410 7 2019-08-27 00:00:00 Rotenturmstraße 4, 1010 Innere Stadt Vienne None Austria 1010 3.96
411 9 2019-08-27 00:00:00 Sønder Boulevard 51 Copenhagen None Denmark 1720 1.98
412 12 2019-08-28 00:00:00 Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 7.92
413 47 2019-08-28 00:00:00 Via Degli Scipioni, 43 Rome RM Italy 00192 14.85
414 54 2019-08-30 00:00:00 110 Raeburn Pl Edinburgh None United Kingdom EH4 1HH 9.9
415 54 2019-08-31 00:00:00 110 Raeburn Pl Edinburgh None United Kingdom EH4 1HH 8.91
416 5 2019-08-31 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 0.99
417 24 2019-09-01 00:00:00 162 E Superior Street Chicago IL USA 60611 9.9
418 50 2019-09-01 00:00:00 C/ San Bernardo 85 Madrid None Spain 28015 0.99
419 3 2019-09-02 00:00:00 1498 rue Bélanger Montréal QC Canada H2G 1A7 9.9
420 20 2019-09-05 00:00:00 541 Del Medio Avenue Mountain View CA USA 94040-111 9.9
421 48 2019-09-05 00:00:00 Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 7.92
422 53 2019-09-07 00:00:00 113 Lupus St London None United Kingdom SW1V 3EN 6.93
423 21 2019-09-07 00:00:00 801 W 4th Street Reno NV USA 89503 10.89
424 35 2019-09-09 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 1.98
425 14 2019-09-13 00:00:00 8210 111 ST NW Edmonton AB Canada T6G 2C7 0.99
426 37 2019-09-14 00:00:00 Berger Straße 10 Frankfurt None Germany 60316 4.95
427 55 2019-09-14 00:00:00 421 Bourke Street Sidney NSW Australia 2010 14.85
428 43 2019-09-17 00:00:00 68, Rue Jouvence Dijon None France 21000 3.96
429 5 2019-09-17 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 10.89
430 55 2019-09-20 00:00:00 421 Bourke Street Sidney NSW Australia 2010 1.98
431 8 2019-09-21 00:00:00 Grétrystraat 63 Brussels None Belgium 1000 9.9
432 32 2019-09-23 00:00:00 696 Osborne Street Winnipeg MB Canada R3L 2B9 1.98
433 33 2019-09-24 00:00:00 5112 48 Street Yellowknife NT Canada X1A 1N6 2.9699999999999998
434 26 2019-09-27 00:00:00 2211 W Berry Street Fort Worth TX USA 76110 9.9
435 38 2019-09-28 00:00:00 Barbarossastraße 19 Berlin None Germany 10779 5.9399999999999995
436 17 2019-10-02 00:00:00 1 Microsoft Way Redmond WA USA 98052-8300 5.9399999999999995
437 54 2019-10-02 00:00:00 110 Raeburn Pl Edinburgh None United Kingdom EH4 1HH 9.9
438 23 2019-10-04 00:00:00 69 Salem Street Boston MA USA 2113 10.89
439 11 2019-10-08 00:00:00 Av. Paulista, 2022 São Paulo SP Brazil 01310-200 6.93
440 45 2019-10-08 00:00:00 Erzsébet krt. 58. Budapest None Hungary H-1073 2.9699999999999998
441 44 2019-10-26 00:00:00 Porthaninkatu 9 Helsinki None Finland 00530 6.93
442 1 2019-11-05 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 3.96
443 20 2019-11-07 00:00:00 541 Del Medio Avenue Mountain View CA USA 94040-111 7.92
444 52 2019-11-08 00:00:00 202 Hoxton Street London None United Kingdom N1 5LH 8.91
445 40 2019-11-11 00:00:00 8, Rue Hanovre Paris None France 75002 3.96
446 49 2019-11-19 00:00:00 Ordynacka 10 Warsaw None Poland 00-358 8.91
447 12 2019-11-23 00:00:00 Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 10.89
448 18 2019-11-27 00:00:00 627 Broadway New York NY USA 10012-2612 9.9
449 34 2019-11-27 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 16.83
450 55 2019-12-04 00:00:00 421 Bourke Street Sidney NSW Australia 2010 6.93
451 46 2019-12-13 00:00:00 3 Chatham Street Dublin Dublin Ireland None 0.99
452 47 2019-12-18 00:00:00 Via Degli Scipioni, 43 Rome RM Italy 00192 7.92
453 31 2019-12-19 00:00:00 194A Chain Lake Drive Halifax NS Canada B3S 1C5 4.95
454 46 2019-12-21 00:00:00 3 Chatham Street Dublin Dublin Ireland None 14.85
455 28 2019-12-24 00:00:00 302 S 700 E Salt Lake City UT USA 84102 4.95
456 13 2019-12-24 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 9.9
457 37 2019-12-25 00:00:00 Berger Straße 10 Frankfurt None Germany 60316 14.85
458 42 2019-12-26 00:00:00 9, Place Louis Barthou Bordeaux None France 33000 0.99
459 50 2019-12-26 00:00:00 C/ San Bernardo 85 Madrid None Spain 28015 1.98
460 20 2019-12-28 00:00:00 541 Del Medio Avenue Mountain View CA USA 94040-111 10.89
461 11 2019-12-29 00:00:00 Av. Paulista, 2022 São Paulo SP Brazil 01310-200 7.92
462 7 2019-12-29 00:00:00 Rotenturmstraße 4, 1010 Innere Stadt Vienne None Austria 1010 8.91
463 34 2019-12-30 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 11.879999999999999
464 1 2019-12-31 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 3.96
465 21 2020-01-12 00:00:00 801 W 4th Street Reno NV USA 89503 6.93
466 30 2020-01-19 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 3.96
467 5 2020-01-20 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 9.9
468 25 2020-01-22 00:00:00 319 N. Frances Street Madison WI USA 53703 15.84
469 14 2020-01-28 00:00:00 8210 111 ST NW Edmonton AB Canada T6G 2C7 0.99
470 9 2020-01-29 00:00:00 Sønder Boulevard 51 Copenhagen None Denmark 1720 1.98
471 35 2020-01-30 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 0.99
472 7 2020-01-31 00:00:00 Rotenturmstraße 4, 1010 Innere Stadt Vienne None Austria 1010 2.9699999999999998
473 58 2020-02-02 00:00:00 12,Community Centre Delhi None India 110017 3.96
474 4 2020-02-04 00:00:00 Ullevålsveien 14 Oslo None Norway 0171 6.93
475 11 2020-02-06 00:00:00 Av. Paulista, 2022 São Paulo SP Brazil 01310-200 7.92
476 6 2020-02-11 00:00:00 Rilská 3174/6 Prague None Czech Republic 14300 10.89
477 5 2020-02-15 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 6.93
478 28 2020-02-21 00:00:00 302 S 700 E Salt Lake City UT USA 84102 16.83
479 46 2020-02-21 00:00:00 3 Chatham Street Dublin Dublin Ireland None 16.83
480 44 2020-02-22 00:00:00 Porthaninkatu 9 Helsinki None Finland 00530 9.9
481 43 2020-02-25 00:00:00 68, Rue Jouvence Dijon None France 21000 3.96
482 10 2020-02-26 00:00:00 Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 7.92
483 15 2020-02-29 00:00:00 700 W Pender Street Vancouver BC Canada V6C 1G8 4.95
484 47 2020-03-02 00:00:00 Via Degli Scipioni, 43 Rome RM Italy 00192 2.9699999999999998
485 37 2020-03-05 00:00:00 Berger Straße 10 Frankfurt None Germany 60316 9.9
486 18 2020-03-05 00:00:00 627 Broadway New York NY USA 10012-2612 8.91
487 27 2020-03-11 00:00:00 1033 N Park Ave Tucson AZ USA 85719 9.9
488 7 2020-03-13 00:00:00 Rotenturmstraße 4, 1010 Innere Stadt Vienne None Austria 1010 13.86
489 43 2020-03-14 00:00:00 68, Rue Jouvence Dijon None France 21000 2.9699999999999998
490 19 2020-03-14 00:00:00 1 Infinite Loop Cupertino CA USA 95014 8.91
491 51 2020-03-24 00:00:00 Celsiusg. 9 Stockholm None Sweden 11230 1.98
492 54 2020-03-25 00:00:00 110 Raeburn Pl Edinburgh None United Kingdom EH4 1HH 4.95
493 41 2020-03-26 00:00:00 11, Place Bellecour Lyon None France 69002 3.96
494 26 2020-03-31 00:00:00 2211 W Berry Street Fort Worth TX USA 76110 9.9
495 10 2020-04-01 00:00:00 Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 0.99
496 21 2020-04-01 00:00:00 801 W 4th Street Reno NV USA 89503 7.92
497 34 2020-04-01 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 6.93
498 13 2020-04-02 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 3.96
499 17 2020-04-03 00:00:00 1 Microsoft Way Redmond WA USA 98052-8300 9.9
500 36 2020-04-07 00:00:00 Tauentzienstraße 8 Berlin None Germany 10789 8.91
501 11 2020-04-09 00:00:00 Av. Paulista, 2022 São Paulo SP Brazil 01310-200 12.87
502 53 2020-04-10 00:00:00 113 Lupus St London None United Kingdom SW1V 3EN 3.96
503 39 2020-04-11 00:00:00 4, Rue Milton Paris None France 75009 9.9
504 6 2020-04-12 00:00:00 Rilská 3174/6 Prague None Czech Republic 14300 10.89
505 19 2020-04-14 00:00:00 1 Infinite Loop Cupertino CA USA 95014 0.99
506 58 2020-04-14 00:00:00 12,Community Centre Delhi None India 110017 15.84
507 2 2020-04-20 00:00:00 Theodor-Heuss-Straße 34 Stuttgart None Germany 70174 0.99
508 38 2020-04-22 00:00:00 Barbarossastraße 19 Berlin None Germany 10779 8.91
509 48 2020-04-27 00:00:00 Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 6.93
510 25 2020-04-28 00:00:00 319 N. Frances Street Madison WI USA 53703 9.9
511 24 2020-05-01 00:00:00 162 E Superior Street Chicago IL USA 60611 6.93
512 43 2020-05-02 00:00:00 68, Rue Jouvence Dijon None France 21000 8.91
513 41 2020-05-03 00:00:00 11, Place Bellecour Lyon None France 69002 10.89
514 25 2020-05-14 00:00:00 319 N. Frances Street Madison WI USA 53703 2.9699999999999998
515 23 2020-05-15 00:00:00 69 Salem Street Boston MA USA 2113 2.9699999999999998
516 23 2020-05-16 00:00:00 69 Salem Street Boston MA USA 2113 1.98
517 3 2020-05-16 00:00:00 1498 rue Bélanger Montréal QC Canada H2G 1A7 8.91
518 22 2020-05-22 00:00:00 120 S Orange Ave Orlando FL USA 32801 1.98
519 32 2020-05-22 00:00:00 696 Osborne Street Winnipeg MB Canada R3L 2B9 6.93
520 5 2020-05-26 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 9.9
521 13 2020-05-27 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 3.96
522 22 2020-05-27 00:00:00 120 S Orange Ave Orlando FL USA 32801 7.92
523 50 2020-05-29 00:00:00 C/ San Bernardo 85 Madrid None Spain 28015 7.92
524 41 2020-06-01 00:00:00 11, Place Bellecour Lyon None France 69002 4.95
525 30 2020-06-02 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 9.9
526 5 2020-06-08 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 19.8
527 57 2020-06-09 00:00:00 Calle Lira, 198 Santiago None Chile None 10.89
528 50 2020-06-10 00:00:00 C/ San Bernardo 85 Madrid None Spain 28015 15.84
529 24 2020-06-12 00:00:00 162 E Superior Street Chicago IL USA 60611 13.86
530 14 2020-06-22 00:00:00 8210 111 ST NW Edmonton AB Canada T6G 2C7 0.99
531 44 2020-06-22 00:00:00 Porthaninkatu 9 Helsinki None Finland 00530 11.879999999999999
532 13 2020-06-23 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 13.86
533 11 2020-06-24 00:00:00 Av. Paulista, 2022 São Paulo SP Brazil 01310-200 12.87
534 10 2020-06-25 00:00:00 Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 5.9399999999999995
535 56 2020-07-05 00:00:00 307 Macacha Güemes Buenos Aires None Argentina 1106 0.99
536 1 2020-07-06 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 5.9399999999999995
537 12 2020-07-07 00:00:00 Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 7.92
538 31 2020-07-10 00:00:00 194A Chain Lake Drive Halifax NS Canada B3S 1C5 8.91
539 46 2020-07-12 00:00:00 3 Chatham Street Dublin Dublin Ireland None 0.99
540 37 2020-07-12 00:00:00 Berger Straße 10 Frankfurt None Germany 60316 10.89
541 58 2020-07-15 00:00:00 12,Community Centre Delhi None India 110017 2.9699999999999998
542 34 2020-07-18 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 10.89
543 17 2020-07-23 00:00:00 1 Microsoft Way Redmond WA USA 98052-8300 2.9699999999999998
544 1 2020-07-24 00:00:00 Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 8.91
545 33 2020-07-26 00:00:00 5112 48 Street Yellowknife NT Canada X1A 1N6 7.92
546 32 2020-07-30 00:00:00 696 Osborne Street Winnipeg MB Canada R3L 2B9 6.93
547 41 2020-08-01 00:00:00 11, Place Bellecour Lyon None France 69002 9.9
548 30 2020-08-02 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 10.89
549 2 2020-08-10 00:00:00 Theodor-Heuss-Straße 34 Stuttgart None Germany 70174 10.89
550 42 2020-08-12 00:00:00 9, Place Louis Barthou Bordeaux None France 33000 9.9
551 16 2020-08-18 00:00:00 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 10.89
552 30 2020-08-19 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 5.9399999999999995
553 7 2020-08-26 00:00:00 Rotenturmstraße 4, 1010 Innere Stadt Vienne None Austria 1010 4.95
554 30 2020-08-27 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 8.91
555 55 2020-09-04 00:00:00 421 Bourke Street Sidney NSW Australia 2010 1.98
556 21 2020-09-04 00:00:00 801 W 4th Street Reno NV USA 89503 10.89
557 2 2020-09-08 00:00:00 Theodor-Heuss-Straße 34 Stuttgart None Germany 70174 9.9
558 17 2020-09-11 00:00:00 1 Microsoft Way Redmond WA USA 98052-8300 10.89
559 32 2020-09-11 00:00:00 696 Osborne Street Winnipeg MB Canada R3L 2B9 5.9399999999999995
560 5 2020-09-11 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 8.91
561 23 2020-09-12 00:00:00 69 Salem Street Boston MA USA 2113 6.93
562 27 2020-09-17 00:00:00 1033 N Park Ave Tucson AZ USA 85719 8.91
563 5 2020-09-19 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 1.98
564 15 2020-09-20 00:00:00 700 W Pender Street Vancouver BC Canada V6C 1G8 5.9399999999999995
565 53 2020-09-23 00:00:00 113 Lupus St London None United Kingdom SW1V 3EN 9.9
566 37 2020-09-27 00:00:00 Berger Straße 10 Frankfurt None Germany 60316 4.95
567 15 2020-09-27 00:00:00 700 W Pender Street Vancouver BC Canada V6C 1G8 7.92
568 35 2020-10-01 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 6.93
569 47 2020-10-06 00:00:00 Via Degli Scipioni, 43 Rome RM Italy 00192 0.99
570 52 2020-10-07 00:00:00 202 Hoxton Street London None United Kingdom N1 5LH 2.9699999999999998
571 51 2020-10-09 00:00:00 Celsiusg. 9 Stockholm None Sweden 11230 2.9699999999999998
572 34 2020-10-13 00:00:00 Rua da Assunção 53 Lisbon None Portugal None 4.95
573 27 2020-10-16 00:00:00 1033 N Park Ave Tucson AZ USA 85719 10.89
574 49 2020-10-17 00:00:00 Ordynacka 10 Warsaw None Poland 00-358 10.89
575 15 2020-10-19 00:00:00 700 W Pender Street Vancouver BC Canada V6C 1G8 3.96
576 45 2020-10-19 00:00:00 Erzsébet krt. 58. Budapest None Hungary H-1073 5.9399999999999995
577 28 2020-10-20 00:00:00 302 S 700 E Salt Lake City UT USA 84102 8.91
578 25 2020-10-21 00:00:00 319 N. Frances Street Madison WI USA 53703 11.879999999999999
579 6 2020-10-23 00:00:00 Rilská 3174/6 Prague None Czech Republic 14300 10.89
580 24 2020-10-25 00:00:00 162 E Superior Street Chicago IL USA 60611 9.9
581 32 2020-10-26 00:00:00 696 Osborne Street Winnipeg MB Canada R3L 2B9 13.86
582 5 2020-10-30 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 17.82
583 22 2020-10-30 00:00:00 120 S Orange Ave Orlando FL USA 32801 10.89
584 30 2020-10-31 00:00:00 230 Elgin Street Ottawa ON Canada K2P 1L7 0.99
585 40 2020-10-31 00:00:00 8, Rue Hanovre Paris None France 75002 8.91
586 55 2020-11-01 00:00:00 421 Bourke Street Sidney NSW Australia 2010 10.89
587 12 2020-11-07 00:00:00 Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 1.98
588 5 2020-11-12 00:00:00 Klanova 9/506 Prague None Czech Republic 14700 0.99
589 41 2020-11-12 00:00:00 11, Place Bellecour Lyon None France 69002 10.89
590 51 2020-11-17 00:00:00 Celsiusg. 9 Stockholm None Sweden 11230 8.91
591 16 2020-11-20 00:00:00 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 6.93
592 2 2020-11-21 00:00:00 Theodor-Heuss-Straße 34 Stuttgart None Germany 70174 7.92
593 12 2020-11-23 00:00:00 Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 10.89
594 31 2020-11-24 00:00:00 194A Chain Lake Drive Halifax NS Canada B3S 1C5 2.9699999999999998
595 23 2020-11-27 00:00:00 69 Salem Street Boston MA USA 2113 7.92
596 42 2020-11-27 00:00:00 9, Place Louis Barthou Bordeaux None France 33000 5.9399999999999995
597 13 2020-11-28 00:00:00 Qe 7 Bloco G Brasília DF Brazil 71020-677 6.93
598 26 2020-12-04 00:00:00 2211 W Berry Street Fort Worth TX USA 76110 4.95
599 59 2020-12-06 00:00:00 3,Raj Bhavan Road Bangalore None India 560001 7.92
600 29 2020-12-08 00:00:00 796 Dundas Street West Toronto ON Canada M6J 1V1 4.95
601 44 2020-12-08 00:00:00 Porthaninkatu 9 Helsinki None Finland 00530 10.89
602 21 2020-12-09 00:00:00 801 W 4th Street Reno NV USA 89503 6.93
603 26 2020-12-10 00:00:00 2211 W Berry Street Fort Worth TX USA 76110 4.95
604 46 2020-12-12 00:00:00 3 Chatham Street Dublin Dublin Ireland None 17.82
605 35 2020-12-17 00:00:00 Rua dos Campeões Europeus de Viena, 4350 Porto None Portugal None 3.96
606 15 2020-12-18 00:00:00 700 W Pender Street Vancouver BC Canada V6C 1G8 11.879999999999999
607 59 2020-12-19 00:00:00 3,Raj Bhavan Road Bangalore None India 560001 4.95
608 49 2020-12-20 00:00:00 Ordynacka 10 Warsaw None Poland 00-358 0.99
609 14 2020-12-20 00:00:00 8210 111 ST NW Edmonton AB Canada T6G 2C7 2.9699999999999998
610 55 2020-12-21 00:00:00 421 Bourke Street Sidney NSW Australia 2010 6.93
611 52 2020-12-27 00:00:00 202 Hoxton Street London None United Kingdom N1 5LH 1.98
612 33 2020-12-27 00:00:00 5112 48 Street Yellowknife NT Canada X1A 1N6 11.879999999999999
613 20 2020-12-29 00:00:00 541 Del Medio Avenue Mountain View CA USA 94040-111 8.91
614 53 2020-12-30 00:00:00 113 Lupus St London None United Kingdom SW1V 3EN 12.87

Our first task is to return each genre with the number of albums sold in the USA both as total value and as a percentage.

In [22]:
%%%sql
WITH usa_invoices AS
    (
    SELECT * 
        FROM invoice_line il
        INNER JOIN invoice i ON i.invoice_id = il.invoice_id
        INNER JOIN track t ON t.track_id = il.track_id
        WHERE billing_country = "USA"
    )
    
SELECT g.name genre,
        count(ui.invoice_line_id) tracks_sold,
        ROUND((cast(count(ui.invoice_line_id) AS FLOAT)/ 
        (SELECT COUNT(*) FROM usa_invoices))*100, 2)|| "%" percentage_sold
        FROM usa_invoices ui
        INNER JOIN genre g ON g.genre_id = ui.genre_id
        GROUP BY 1
        ORDER BY 2 DESC
        LIMIT 10; 
Done.
Out[22]:
genre tracks_sold percentage_sold
Rock 561 53.38%
Alternative & Punk 130 12.37%
Metal 124 11.8%
R&B/Soul 53 5.04%
Blues 36 3.43%
Alternative 35 3.33%
Latin 22 2.09%
Pop 22 2.09%
Hip Hop/Rap 20 1.9%
Jazz 14 1.33%

What we end up seeing in our analysis is that more than half of the record sold are from the Rock genre, with Alternative & Punk coming a distant second at 12.4%, followed by Metal at 11.8%.

After that, every genre falls 5.1% of total tracks sold.

The recommendation for which albums we should purchase for the store are Red Tone and Slim Jim Bites. Additionally, our third purchase should be Meteor and the Girls, although it is only a marginal difference between this artist and Regal and could swap for each other, depending on the individual artist's popularity within their own genre.

Now, we will look into the sales reps and their total sales each in dollar amounts. We will also highlight their age and hire dates, to see if there is any analysis to be done in regards to the representatives themselves.

In [23]:
%%%sql

WITH sales_reps AS
    (
    SELECT *
        FROM employee e
        INNER JOIN customer c ON c.support_rep_id = e.employee_id
        INNER JOIN invoice i ON c.customer_id = i.customer_id
        INNER JOIN invoice_line il ON il.invoice_id = i.invoice_id
    )
    
SELECT sr.first_name || " " || sr.last_name employee_name,
    '$'||ROUND(SUM((sr.unit_price)*(sr.quantity)),2) total_sales,
    sr.birthdate birth_date, sr.hire_date hire_date
    FROM sales_reps sr
    GROUP BY 1
    ORDER BY 2 DESC;
Done.
Out[23]:
employee_name total_sales birth_date hire_date
Jane Peacock $1731.51 1973-08-29 00:00:00 2017-04-01 00:00:00
Margaret Park $1584.0 1947-09-19 00:00:00 2017-05-03 00:00:00
Steve Johnson $1393.92 1965-03-03 00:00:00 2017-10-17 00:00:00

Our query found that Jane Peacock had the highest total sales at \$1731.51, with Margaret Park and Steve Johnson both having less.

Jane also happens to be the youngest of the three sales reps, but has the most experience with the company as she was hired before Margaret and Steve.

Margaret had the second highest total, but is the oldest sales rep. She did, however, get hired before Steve, so it appears that sales totals directly correspond to experience at the company, with more experience leading to higher sales, while age does not play as significant of a factor.

In [25]:
%%%sql

WITH country_info AS
    (
    SELECT 
        CASE
            WHEN (
                    SELECT count(*)
                    FROM customer
                    WHERE country = c.country
            ) = 1 THEN "Other"
            ELSE c.country
        END AS country,
        c.customer_id,
        il.*
        FROM invoice_line il
        INNER JOIN invoice i ON i.invoice_id = il.invoice_id
        INNER JOIN customer c ON c.customer_id = i.customer_id
    )

SELECT 
    country,
    customers,
    sales,
    sales_per_customer,
    average_order
    FROM
        (
            SELECT country,
                COUNT(DISTINCT customer_id) customers,
                SUM(unit_price) sales,
                SUM(unit_price)/COUNT(DISTINCT customer_id) sales_per_customer,
                SUM(unit_price)/COUNT(DISTINCT invoice_id) average_order,
                CASE 
                    WHEN country = "Other" THEN 1
                    ELSE 0 
                END AS sort
            FROM country_info
    GROUP BY country
    ORDER BY sort ASC, sales DESC);
Done.
Out[25]:
country customers sales sales_per_customer average_order
USA 13 1040.490000000008 80.03769230769292 7.942671755725252
Canada 8 535.5900000000034 66.94875000000043 7.047236842105309
Brazil 5 427.68000000000245 85.53600000000048 7.011147540983647
France 5 389.0700000000021 77.81400000000042 7.781400000000042
Germany 4 334.6200000000016 83.6550000000004 8.161463414634186
Czech Republic 2 273.24000000000103 136.62000000000052 9.108000000000034
United Kingdom 3 245.52000000000078 81.84000000000026 8.768571428571457
Portugal 2 185.13000000000022 92.56500000000011 6.3837931034482835
India 2 183.1500000000002 91.5750000000001 8.72142857142858
Other 15 1094.9400000000085 72.99600000000056 7.448571428571486

Our query of the customers grouped into their countries shows us the following information:

  • The USA has the most customers and highest total sales of all countries, with \$1040 in total sales from 13 customers.
  • The Czech Republic, on average, has the highest sales per customer, with the 2 customers averaging \$136 each.
  • Portugal and India also averaged above \$90 per customer, although both countries, like the Czech Republic, only show 2 customers each.
In [32]:
%%%sql

WITH invoice_first AS
    (
         SELECT
             il.invoice_id invoice_id,
             MIN(il.track_id) first_track_id
         FROM invoice_line il
         GROUP BY 1
    )

SELECT
    album_purchase,
    COUNT(invoice_id) invoices,
    ROUND(100*CAST(count(invoice_id) AS FLOAT) / 
          (
             SELECT COUNT(*) FROM invoice
          ), 2) percent
FROM
    (
    SELECT
        ifs.*,
        CASE
            WHEN
                 (
                  SELECT t.track_id FROM track t
                  WHERE t.album_id = (
                                      SELECT t2.album_id FROM track t2
                                      WHERE t2.track_id = ifs.first_track_id
                                     ) 

                  EXCEPT 

                  SELECT il2.track_id FROM invoice_line il2
                  WHERE il2.invoice_id = ifs.invoice_id
                 ) IS NULL
             AND
                 (
                  SELECT il2.track_id 
                     FROM invoice_line il2
                     WHERE il2.invoice_id = ifs.invoice_id

                  EXCEPT 

                  SELECT t.track_id 
                     FROM track t
                     WHERE t.album_id = 
                         (
                            SELECT t2.album_id 
                                FROM track t2
                                WHERE t2.track_id = ifs.first_track_id
                         ) 
                 ) IS NULL
             THEN "Yes"
             ELSE "No"
         END AS "album_purchase"
     FROM invoice_first ifs
    )
GROUP BY album_purchase;
Done.
Out[32]:
album_purchase invoices percent
No 500 81.43
Yes 114 18.57

While a larger percentage of sales are from individual track sales, there are still over 18% of sales from full albums. That revenue would be decreased if Chinook stopped buying full albums, so my recommendation is to continue to buy albums.

In [ ]: