01 Dataliteracy

Spotify Dataset

Kaggle link: Top Hits Spotify from 2000-2019

SQL Link: Dataset as SQL script

Coffee Dataset

SQL Link

Delivery

• Random Pairs

• Max 5 pages in .pdf using the hand-in link

Report content

• Brief introduction & description of ONE of the dataset

  • How is the data structured? (E.g. Highligts of: Examples of data scales, dataset description, examples of data types)

• For each question below of BOTH of the datasets:

  • Write a query solving the question

  • Describe - how does the query work?

• A single example application/usage of the data set within ONE of the datasets:

  • Your personal domain

  • A professional domain (You decide whom the "user" is)

• Research topic to ONE of the datasets

  • Formulate a specific question and answer that question with a query

Questions (Top Hits Spotify dataset)

• How many songs have explicit content?

• Display all songs made between 2000-2010

• What is the name of the most danceable track from 2001?

• Display only the artist name and song title of tracks with a key between 1-5

• Display all data of songs starting with 'B' that has a key between 1-5

Questions (Coffee dataset)

• Display all data from customers who do not have a phone number entered into the customer table

• Display all products and their country of origin in a single table

• Display all orders, customer firstname & lastname, and the country of origin of the product they ordered

Handin Date

12/9 - 2025

Handlin Link

https://ek.itslearning.com/LearningToolElement/ViewLearningToolElement.aspx?LearningToolElementId=1411230

1. Group 1

   1. Rosalina Hoff Kjærgaard

   2. Dilar Mohammad Ali

   3. Loui Fatum Mikkelsen

2. Group 2

   1. Sofia Rosa Zimmermann

   2. Oscar Bertram Merino Andersen

   3. kagi0001 kagi0001

3. Group 3

   1. Kai Thelonious Brooklyn Bomholtz

   2. seho0004 seho0004

   3. Baldur Thorkildshøj Súnason

4. Group 4

   1. Carla Isabel Leiton

   2. Pin Yuan Lu

   3. Jannik Wæver Olsen

5. Group 5

   1. Hjalte-Emil Schultz Holm

   2. Amira El Khattouti

   3. Beyza Yasar

6. Group 6

   1. Oliver Baasch Feichtinger

   2. Elliot Theodor Lyhne Christensen

   3. Astrid Sofie Falkenberg

7. Group 7

   1. vial0001 vial0001

   2. Stephanie Skjøtt Rone

   3. Sebastian Sigurd Sandby Anthonsen

8. Group 8

   1. Sylvester Erbs Ledet

   2. Noah Prang Larsen

   3. Mathilde Louise Farnø Pedersen

9. Group 9

   1. Sebastian Herler Lindquist

   2. Christoffer Bohnzen Hansen

   3. Storm Dyva Toubro

10. Group 10

    1. Kenadid Kablalah Ali

    2. Ali Hussein Ibrahim Hassan

    3. Mathias Hartung Borup

11. Group 11

    1. Simon Bransholm

    2. Frederik Egede Johansen

    3. Mohsen Estakhr

12. Group 12

    1. Magnus Egemose Ørnhof

    2. Victor Bischoff Mørkeberg

    3. Jacob Naghdeh

13. Group 13

    1. Peter Reedtz Wille-Jørgensen

    2. Gustav Felix Anker Meyer

    3. thmo0003 thmo0003

14. Group 14

    1. Nina Lind Johansen

    2. Oliver Fritz Koogi

    3. Freja Johnna Tromborg

15. Group 15

    1. Maja Samer Massoud

    2. Benjamin Skak Vestergaard Larsen

    3. Johanne Schledermann Jeilsø

16. Group 16

    1. Jonas Mørk Nielsen

    2. Nikolaj Birkelund Rahe

    3. Mathias Albin Blynning