SELECT song_name FROM song WHERE languages  =  "english"
What are the names of all songs in English?
create table genre(
	g_name varchar2(20) not null,
	rating varchar2(10),
	most_popular_in varchar2(50),
	primary key(g_name)
);
create table artist(
	artist_name varchar2(50) not null,
	country varchar2(20),
	gender varchar2(20),
	preferred_genre varchar2(50),
	constraint a_name primary key(artist_name),
	foreign key(preferred_genre) references genre(g_name) ON DELETE CASCADE
);
create table files(
	f_id number(10) not null,
	artist_name varchar2(50),
	file_size varchar2(20),
	duration varchar2(20),
	formats varchar2(20),
	primary key(f_id),
	foreign key(artist_name) references artist(artist_name) ON DELETE CASCADE
);
create table song(
	song_name varchar2(50),
	artist_name varchar2(50),
	country varchar2(20),
	f_id number(10),
    	genre_is varchar2(20),
	rating number(10) check(rating>0 and rating<11),
	languages varchar2(20),
	releasedate Date, 
	resolution number(10) not null,
	constraint s_name primary key(song_name),
	foreign key(artist_name) references artist(artist_name) ON DELETE CASCADE,
	foreign key(f_id) references files(f_id) ON DELETE CASCADE,
	foreign key(genre_is) references genre(g_name) ON DELETE CASCADE
);
INSERTion of attributes in the table
INSERT into genre(g_name,rating,most_popular_in) values ('tagore','8','Bangladesh');
INSERT into genre values ('nazrul','7','Bangladesh');
INSERT into artist(artist_name,country,gender,preferred_genre) values('Shrikanta','India','Male','tagore');
INSERT into artist values('Prity','Bangladesh','Female','nazrul');
INSERT into files(f_id,artist_name,file_size,duration,formats) values (1,'Shrikanta','3.78 MB','3:45','mp4');
INSERT into files values (2,'Prity','4.12 MB','2:56','mp3');
INSERT into song(song_name,artist_name,country,f_id,genre_is,rating,languages,releasedate,resolution) values ('Tumi robe nirobe','Shrikanta','India','1','tagore','8','bangla','28-AUG-2011',1080);
INSERT into song values ('Shukno patar nupur pae','Prity','Bangladesh','2','nazrul','5','bangla','21-SEP-1997',512);
INSERT INTO genre VALUES [('tagore', '8', 'Bangladesh'), ('nazrul', '7', 'Bangladesh')]
INSERT INTO artist VALUES [('Shrikanta', 'India', 'Male', 'tagore'), ('Prity', 'Bangladesh', 'Female', 'nazrul')]
INSERT INTO files VALUES [(1, 'Shrikanta', '3.78 MB', '3:45', 'mp4'), (2, 'Prity', '4.12 MB', '2:56', 'mp3')]
INSERT INTO song VALUES [('Tumi robe nirobe', 'Shrikanta', 'India', 1, 'tagore', 8, 'bangla', '28-AUG-2011', 1080), ('Shukno patar nupur pae', 'Prity', 'Bangladesh', 2, 'nazrul', 5, 'bangla', '21-SEP-1997', 512)]