SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select sqlite_version();


sqlite_version()


3.27.2


CREATE TABLE Artist(Artist_ID int not null primary key, 
                    Artist varchar(200), Followers int, 
                    Genres varchar(200), NumAlbums int, 
                    YearFirstAlbum int, Gender char(1), 
                    Group_Solo varchar(5) );
            
insert into Artist
values (0, 'Ed Sheeran',10000,'pop, uk pop',8,2011,'M', 'Solo , Group'),
 (1, 'Justin Beiber',123456,'pop, uk pop',10,2009,'M','Solo'),
  (2, 'Jonas Brother',23456,'boy band, uk pop',10,2006,'M','Group'),
   (3, 'Camila Cabelo',3435,'pop, uk pop',3,2011,'M','Group');
  select * from Artist


Artist_ID
Artist
Followers
Genres
NumAlbums
YearFirstAlbum
Gender
Group_Solo


0
Ed Sheeran
10000
pop, uk pop
8
2011
M
Solo , Group

1
Justin Beiber
123456
pop, uk pop
10
2009
M
Solo

2
Jonas Brother
23456
boy band, uk pop
10
2006
M
Group

3
Camila Cabelo
3435
pop, uk pop
3
2011
M
Group


CREATE TABLE Billboard(Song_ID int not null primary key, 
                   Name varchar(20), 
                    Weekly_rank int, Peak_position int, 
                    Weeks_on_chart int, Week Date, Date varchar(20),     
                    Genre varchar(20), Writing_Credits varchar(20), 
                    Lyrics varchar(10), Features varchar(20) );         
  insert into Billboard (Song_ID, Name)
  values (1 , 'Song1'),
  (2,'Song2'),
  (3,  'Song3');
  
CREATE TABLE Artist_Billboard
(Artist_id int,
Song_id int,
FOREIGN KEY(Artist_id) REFERENCES Artist(Artist_id),
FOREIGN KEY(Song_id) REFERENCES Billboard(Song_id))
insert into Artist_Billboard
values (0,1),
(1,2),
(0,3),
(3,3);
select a.*, b.*
from Artist_Billboard  ab
join Artist a on a.Artist_id = ab.Artist_id
join Billboard b on b.Song_id = ab.Song_id


Artist_ID
Artist
Followers
Genres
NumAlbums
YearFirstAlbum
Gender
Group_Solo
Song_ID
Name
Weekly_rank
Peak_position
Weeks_on_chart
Week
Date
Genre
Writing_Credits
Lyrics
Features


0
Ed Sheeran
10000
pop, uk pop
8
2011
M
Solo , Group
1
Song1
null
null
null
null
null
null
null
null
null

1
Justin Beiber
123456
pop, uk pop
10
2009
M
Solo
2
Song2
null
null
null
null
null
null
null
null
null

0
Ed Sheeran
10000
pop, uk pop
8
2011
M
Solo , Group
3
Song3
null
null
null
null
null
null
null
null
null

3
Camila Cabelo
3435
pop, uk pop
3
2011
M
Group
3
Song3
null
null
null
null
null
null
null
null
null


select a.Artist, NumAlbums, count(ab.artist_id) Billboar100
from Artist_Billboard  ab
join Artist a on a.Artist_id = ab.Artist_id
group by a.Artist, NumAlbums


Artist
NumAlbums
Billboar100


Camila Cabelo
3
1

Ed Sheeran
8
2

Justin Beiber
10
1

Artist_ID	Artist	Followers	Genres	NumAlbums	YearFirstAlbum	Gender	Group_Solo
0	Ed Sheeran	10000	pop, uk pop	8	2011	M	Solo , Group
1	Justin Beiber	123456	pop, uk pop	10	2009	M	Solo
2	Jonas Brother	23456	boy band, uk pop	10	2006	M	Group
3	Camila Cabelo	3435	pop, uk pop	3	2011	M	Group