text: DROP DATABASE IF EXISTS topreleases_db;
  CREATE DATABASE topreleases_db;
  USE topreleases_db;
  
  CREATE TABLE topSongs (
  	position INT NOT NULL,
      artist VARCHAR(100) NULL,
      song VARCHAR(100) NULL,
      year INT NULL,
      raw_total DECIMAL(10, 4) NULL,
      raw_usa DECIMAL(10, 4) NULL,
      raw_uk DECIMAL(10, 4) NULL,
      raw_eur DECIMAL(10, 4) NULL,
      raw_row DECIMAL(10, 4) NULL,
      PRIMARY KEY (position)
      );
  
  CREATE TABLE topAlbums (
  	position INT NOT NULL,
      artist VARCHAR(100) NULL,
      album VARCHAR(100) NULL,
      year INT NULL,
      raw_total DECIMAL(10, 4) NULL,
      raw_usa DECIMAL(10, 4) NULL,
      raw_uk DECIMAL(10, 4) NULL,
      raw_eur DECIMAL(10, 4) NULL,
      raw_row DECIMAL(10, 4) NULL,
      PRIMARY KEY (position)
      );
  
  
  //query
  
  SELECT topalbums.year, topalbums.album, topalbumbs.position, topsongs.song, topalbums.artist
  FROM topalbums INNER JOIN topsongs
  ON (topalbums.artist = topsongs.artist AND topalbums.year = topsongs.year)
  WHERE (topalbums.artist = "Queen" AND topsongs.artist = "Queen")
  ORDER BY topalbums.year, topalbums.position;