
CREATE TABLE singer (
	"Singer_ID" INTEGER, 
	"Name" TEXT, 
	"Birth_Year" REAL, 
	"Net_Worth_Millions" REAL, 
	"Citizenship" TEXT, 
	PRIMARY KEY ("Singer_ID")
)


CREATE TABLE song (
	"Song_ID" INTEGER, 
	"Title" TEXT, 
	"Singer_ID" INTEGER, 
	"Sales" REAL, 
	"Highest_Position" REAL, 
	PRIMARY KEY ("Song_ID"), 
	FOREIGN KEY("Singer_ID") REFERENCES singer ("Singer_ID")
)

CREATE TABLE singer (
	"Singer_ID" INTEGER, 
	"Name" TEXT, 
	"Birth_Year" REAL, 
	"Net_Worth_Millions" REAL, 
	"Citizenship" TEXT, 
	PRIMARY KEY ("Singer_ID")
)

/*
2 rows from singer table:
Singer_ID	Name	Birth_Year	Net_Worth_Millions	Citizenship
1	Liliane Bettencourt	1944.0	30.0	France
2	Christy Walton	1948.0	28.8	United States
*/


CREATE TABLE song (
	"Song_ID" INTEGER, 
	"Title" TEXT, 
	"Singer_ID" INTEGER, 
	"Sales" REAL, 
	"Highest_Position" REAL, 
	PRIMARY KEY ("Song_ID"), 
	FOREIGN KEY("Singer_ID") REFERENCES singer ("Singer_ID")
)

/*
2 rows from song table:
Song_ID	Title	Singer_ID	Sales	Highest_Position
1	Do They Know It's Christmas	1	1094000.0	1.0
2	F**k It (I Don't Want You Back)	1	552407.0	1.0
*/
What are the names of the singers who are not French citizens?
SELECT Name FROM singer WHERE Citizenship != "France"
[{'Name': 'Christy Walton'}, {'Name': 'Alice Walton'}, {'Name': 'Iris Fontbona'}, {'Name': 'Jacqueline Mars'}, {'Name': 'Gina Rinehart'}, {'Name': 'Susanne Klatten'}, {'Name': 'Abigail Johnson'}]