SQL worldwide fragrance houses

// Worldwide Fragrance Houses - compiled FROM fragrantica.com/country/
CREATE TABLE perfumeries (
    country VARCHAR(33),
    house VARCHAR(50) ) ;
INSERT INTO perfumeries
VALUES
    ( "Argentina", "Arkadia Sabores y Aromas de Autor" ),
    ( "Argentina", "Frassai" ),
    ( "Argentina", "Fueguia 1833" ),
    ( "Argentina", "Gabriela Sabatini" ),
    ( "Argentina", "Kosiuko" ),
    ( "Argentina", "La Martina" ),
    ( "Argentina", "Ricky Sarkany" ),
    ( "Argentina", "Valeria Mazza" ),
    ( "Argentina", "Zazil" ),
    ( "Armenia", "Arman Manoukian Parfums" ),
    ( "Armenia", "Voskanian Parfums" ),
    ( "Aruba", "Agatha" ),
    ( "Austria", "Acqua Alpes" ),
    ( "Austria", "Alt-Innsbruck" ),
    ( "Austria", "ANNO 1555" ),
    ( "Austria", "CnR Create" ),
    ( "Austria", "Dianne Brill Cosmetics" ),
    ( "Austria", "Frey Wille" ),
    ( "Austria", "Knize" ),
    ( "Austria", "La Ric" ),
    ( "Austria", "Lena Hoschek" ),
    ( "Austria", "Liaison de Parfum" ),
    ( "Austria", "Nana de Bary" ),
    ( "Austria", "Nanadebary" ),
    ( "Austria", "Palmers" ),
    ( "Austria", "W. F. Adlmuller" ),
    ( "Austria", "WienerBlut" ),
    ( "Azerbaijan", "Crystal Parfum" ),
    ( "Azerbaijan", "Murad Mesud" ),
    ( "Azerbaijan", "The Spirit Of Azerbaijan" ),
    ( "Bahrain", "Asgharali" ),
    ( "Bahrain", "Reehat Al Atoor" ),
    ( "Bahrain", "Shaik" ),
    ( "Bahrain", "Syed Junaid Alam" ),
    ( "Belarus", "Dilis Parfum" ),
    ( "Belarus", "Ninel Perfume" ),
    ( "Belarus", "Vlad Rekunov" ),
    ( "Belgium", "BillyXClub" ),
    ( "Belgium", "C&A" ),
    ( "Belgium", "Creation Lamis" ),
    ( "Belgium", "Dirk Bikkembergs" ),
    ( "Belgium", "Gabriel et Valentin" ),
    ( "Belgium", "Glenn Bracke" ),
    ( "Belgium", "Kamila Aubre Botanical Perfume" ),
    ( "Belgium", "L'Antichambre" ),
    ( "Belgium", "Les Ecuadors" ),
    ( "Belgium", "Les Soeurs de Noe" ),
    ( "Belgium", "NeZ ZeN" ),
    ( "Belgium", "Nico Uytterhaegen" ),
    ( "Bermuda", "Lili Bermuda" ),
    ( "Bermuda", "Royall Lyme Bermuda" ),
    ( "Bulgaria", "Alen Mak" ),
    ( "Bulgaria", "Aroma Essence" ),
    ( "Bulgaria", "Bulgarian Rose" ),
    ( "Bulgaria", "Bulgarska Rosa" ),
    ( "Bulgaria", "Evterpa" ),
    ( "Bulgaria", "Faviol Seferi" ),
    ( "Bulgaria", "Metanoa De La Rose" ),
    ( "Bulgaria", "Nature Of Agiva" ),
    ( "Bulgaria", "Rose of Bulgaria" ),
    ( "Bulgaria", "Sense of Nature" ),
    ( "Cayman Islands", "Ted Green Cayman Islands" ),
    ( "Chile", "Coral" ),
    ( "Chile", "Cristian Brinck" ),
    ( "Chile", "Natalie" ),
    ( "Chile", "Terragonia" ),
    ( "China", "Atelier Ulric Fragrances" ),
    ( "China", "Boitown 冰希黎" ),
    ( "China", "Daichun Lin 戴春林" ),
    ( "China", "Ecarlou 露嘉伊" ),
    ( "China", "LiLai 丽来" ),
    ( "China", "LiuShen 六神" ),
    ( "China", "Lonkoom Parfum" ),
    ( "China", "Love&Wish 爱唯施" ),
    ( "China", "Modern Lady 摩登红人" ),
    ( "China", "Parizino 贝丽丝" ),
    ( "China", "RE CLASSIFIED RE调香室" ),
    ( "China", "Scents & The City 寻味地图" ),
    ( "China", "Shanghai Tang" ),
    ( "China", "Soapmeet 香约" ),
    ( "China", "Synes Moon 偷自月亮" ),
    ( "China", "TianDe" ),
    ( "China", "Tiens" ),
    ( "China", "XiangHai 香海" ),
    ( "China", "Yili Olfactory Art" ),
    ( "Columbia", "Jean Pascal" ),
    ( "Columbia", "The Lab" ),
    ( "Cote D’Ivoire", "Olfacto" ),
    ( "Croatia", "Antonija Šola" ),
    ( "Croatia", "Aromatica" ),
    ( "Croatia", "Croatian Perfume House" ),
    ( "Croatia", "Danijela Martinovic" ),
    ( "Croatia", "Imotski" ),
    ( "Croatia", "Just Wow" ),
    ( "Croatia", "Macal Palma" ),
    ( "Croatia", "Majushka" ),
    ( "Croatia", "The Plitvice Times" ),
    ( "Croatia", "XD Xenia Design" ),
    ( "Cuba", "Agustin Reyes" ),
    ( "Cuba", "Suchel Camacho" ),
    ( "Cuba", "Vegueros" ),
    ( "Czech Republic", "Astrid" ),
    ( "Czech Republic", "F.Prochaska" ),
    ( "Czech Republic", "Giorgio Michel" ),
    ( "Czech Republic", "Renier Perfumes" ),
    ( "Czech Republic", "S.A.C.K.Y" ),
    ( "Denmark", "Allison" ),
    ( "Denmark", "Axe" ),
    ( "Denmark", "Gosh" ),
    ( "Denmark", "Henrik Vibskov" ),
    ( "Denmark", "RPL" ),
    ( "Denmark", "Raunsborg" ),
    ( "Denmark", "Royal Copenhagen" ),
    ( "Denmark", "Skandinavisk" ),
    ( "Denmark", "Tromborg" ),
    ( "Denmark", "Zarkoperfume" ),
    ( "Dominican Republic", "Dominican Perfumes" ),
    ( "Dubai", "I-Scents Premium" ),
    ( "Ecuador", "Nino Touma" ),
    ( "Ecuador", "Roberto Manrique" ),
    ( "Egypt", "Chabrawichi" ),
    ( "Egypt", "EaSTory" ),
    ( "Egypt", "Kesma" ),
    ( "Egypt", "Mau Perfume" ),
    ( "Egypt", "Nilafar du Nil" ),
    ( "Egypt", "Omar Sharif" ),
    ( "Egypt", "Parfico" ),
    ( "England", "Jamal Perfumers London" ),
    ( "England", "Odore Mio" ),
    ( "England", "Prosody London" ),
    ( "England", "Bamford" ),
    ( "England", "Scapa" ),
    ( "England", "Seren" ),
    ( "Estonia", "Flora" ),
    ( "Finland", "Lumene" ),
    ( "Finland", "Nakuna Helsinki" ),
    ( "Finland", "PP Perfumes Helsinki" ),
    ( "Finland", "Scent of Finland" ),
    ( "Finland", "Sue Wong" ),
    ( "Georgia", "Iberia - Иверия" ),
    ( "Ghana", "Ghandour" ),
    ( "Greece", "Apivita" ),
    ( "Greece", "Apvita" ),
    ( "Greece", "Aromatologic" ),
    ( "Greece", "Avgerinos" ),
    ( "Greece", "Bioselect" ),
    ( "Greece", "Blue Scents" ),
    ( "Greece", "Folli Follie" ),
    ( "Greece", "For Kings & Queens by Korres" ),
    ( "Greece", "Fresh Line" ),
    ( "Greece", "Journaper" ),
    ( "Greece", "Korres" ),
    ( "Greece", "Lavish Care" ),
    ( "Greece", "Manos Gerakinis" ),
    ( "Greece", "Mastiha Shop" ),
    ( "Greece", "Mythos" ),
    ( "Greece", "Sarantis" ),
    ( "Greece", "Seventeen" ),
    ( "Greece", "Str8" ),
    ( "Greece", "The Land Of Corfu" ),
    ( "Greece", "Theodoros Kalotinis" ),
    ( "Greece", "Tonias Handmade" ),
    ( "Greece", "Vassilis Zoulias" ),
    ( "Guatemala", "INVISIBLE/HR" ),
    ( "Hong Kong", "Aurora par Charles Wong" ),
    ( "Hong Kong", "Cathay Pacific Airways" ),
    ( "Hungary", "Mar Galliti" ),
    ( "Hungary", "Omorovicza" ),
    ( "Iceland", "Gydja" ),
    ( "India", "All Good Scents" ),
    ( "India", "Amelia Perfumes" ),
    ( "India", "Bombay Perfumery" ),
    ( "India", "Boutique Perfumery" ),
    ( "India", "Dixit & Zak" ),
    ( "India", "Lisa Ray" ),
    ( "India", "Nuroma" ),
    ( "India", "Oudh Al Anfar" ),
    ( "India", "Parfums Louis Armand" ),
    ( "India", "Paris Elysees" ),
    ( "India", "Perfumologist" ),
    ( "India", "Projekt Alternative" ),
    ( "India", "Regal" ),
    ( "India", "Sunny Leone" ),
    ( "India", "UpShots" ),
    ( "Indonesia", "Animale" ),
    ( "Iran", "Aqua Perfume Atelier" ),
    ( "Iran", "Ayliroma" ),
    ( "Iran", "Lotus" ),
    ( "Iran", "Viva Creation" ),
    ( "Ireland", "Cloon Keen Atelier" ),
    ( "Ireland", "Fragrances of Ireland" ),
    ( "Ireland", "Primark" ),
    ( "Ireland", "Roads" ),
    ( "Ireland", "Waters + Wild Perfumery" ),
    ( "Ireland", "Yveperfume" ),
    ( "Israel", "Ein Gedi" ),
    ( "Israel", "Ga-De" ),
    ( "Israel", "Judith Muller" ),
    ( "Israel", "LAOR" ),
    ( "Israel", "Persifleur" ),
    ( "Israel", "Sheinvald" ),
    ( "Israel", "Spring" ),
    ( "Israel", "The New Jerusalem" ),
    ( "Israel", "The Three Arches Co." ),
    ( "Israel", "Zielinski & Rozen" ),
    ( "Jordan", "Zeitun" ),
    ( "Kazakhstan", "Aura of Kazakhstan" ),
    ( "Kenya", "Lheritier" ),
    ( "Korea", "Mag & Logan" ),
    ( "Korea", "Skinfood" ),
    ( "Korea", "Spectator" ),
    ( "Korea", "The Face Shop" ),
    ( "Korea", "TonyMoly" ),
    ( "Korea", "Too Cool For School" ),
    ( "Kuwait", "ASAMA Perfumes" ),
    ( "Kuwait", "Dar Hamad Perfumes" ),
    ( "Kuwait", "Etry" ),
    ( "Kuwait", "Mahdi Alajmi" ),
    ( "Kuwait", "Ne'emah For Fragrance & Oudh" ),
    ( "Kuwait", "Rasht Otr" ),
    ( "Kuwait", "Shades Of Scents" ),
    ( "Kuwait", "Suhad Perfumes" ),
    ( "Kuwait", "The Fragrance Kitchen" ),
    ( "Latvia", "Attirance" ),
    ( "Latvia", "Dzintars" ),
    ( "Latvia", "Stenders" ),
    ( "Liberia", "Tammie Garr" ),
    ( "Lithuania", "Aromata Mirabilia" ),
    ( "Lithuania", "Eglė Jonaitytė Botanical Perfumes" ),
    ( "Lithuania", "FUMparFUM" ),
    ( "Lithuania", "Juozas Statkevicius Josef Statkus" ),
    ( "Luxembourg", "Mypa" ),
    ( "Malaysia", "Auphorie" ),
    ( "Malaysia", "BAU" ),
    ( "Malaysia", "Bunkface" ),
    ( "Malaysia", "Malay Perfumery" ),
    ( "Malaysia", "Ningen Parfums" ),
    ( "Malaysia", "Rirana Parfume" ),
    ( "Malta", "FWIEHA FRAGRANZA TA'MALTA" ),
    ( "Mexico", "Aguas de Colonia Sanborns" ),
    ( "Mexico", "Azteque" ),
    ( "Mexico", "Coqui Coqui" ),
    ( "Mexico", "Fuller Cosmetics®" ),
    ( "Mexico", "Loly In The Sky" ),
    ( "Mexico", "Natural Scents" ),
    ( "Mexico", "Paulina Rubio" ),
    ( "Mexico", "Pedacito de Cielo" ),
    ( "Mexico", "Perfumes Artesanales" ),
    ( "Mexico", "Perfumérica" ),
    ( "Mexico", "Sandovalis" ),
    ( "Mexico", "Seajewels" ),
    ( "Mexico", "Sukimuki" ),
    ( "Mexico", "Urania" ),
    ( "Mexico", "Xinú" ),
    ( "Monaco", "Alex Simone" ),
    ( "Monaco", "Isabell Kristensen" ),
    ( "Monaco", "Lancaster" ),
    ( "Monaco", "Perris Monte Carlo" ),
    ( "Morocco", "Heritage Berbere" ),
    ( "Morocco", "Les Parfums du Soleil" ),
    ( "Morocco", "Les Sens de Marrakech" ),
    ( "New Zealand", "Fragrifert Parfumeur" ),
    ( "New Zealand", "Herdahl-Thorsing" ),
    ( "New Zealand", "Ingrid Starnes" ),
    ( "New Zealand", "Karen Walker" ),
    ( "New Zealand", "Michael Hill" ),
    ( "Nigeria", "Catherine Omai" ),
    ( "Nigeria", "Sapphire Scents" ),
    ( "Norway", "DoubleYou" ),
    ( "Norway", "Eroma Perfumes" ),
    ( "Norway", "Geir Ness" ),
    ( "Norway", "Kanøn" ),
    ( "Norway", "Malbrum Parfums" ),
    ( "Norway", "Moods Of Norway" ),
    ( "Norway", "Son Venïn" ),
    ( "Pakistan", "Junaid Jamshed" ),
    ( "Peru", "Cyzone" ),
    ( "Peru", "L'Bel" ),
    ( "Peru", "Ésika" ),
    ( "Philippines", "Botanique" ),
    ( "Philippines", "Heno de Pravia" ),
    ( "Philippines", "Hershee Izell" ),
    ( "Philippines", "Manny Pacman Pacquiao" ),
    ( "Philippines", "Radioactive Mushrooms in the Forest" ),
    ( "Philippines", "bench" ),
    ( "Portugal", "Ach. Brito" ),
    ( "Portugal", "Acqua di Portokali" ),
    ( "Portugal", "Alma da Comporta" ),
    ( "Portugal", "Ana Salazar" ),
    ( "Portugal", "Antiga Barbearia de Bairro" ),
    ( "Portugal", "Aqua Dos Açores Atlantic Ocean" ),
    ( "Portugal", "CR7" ),
    ( "Portugal", "Claus Porto" ),
    ( "Portugal", "Comporta Perfumes" ),
    ( "Portugal", "Cristiano Ronaldo" ),
    ( "Portugal", "Cristina Ferreira" ),
    ( "Portugal", "Eugénio Campos" ),
    ( "Portugal", "Fatima Lopes" ),
    ( "Portugal", "Jose Antonio Tenente" ),
    ( "Portugal", "Miguel Matos" ),
    ( "Portugal", "Musgo Real" ),
    ( "Portugal", "Ourige Since Douro" ),
    ( "Portugal", "Papillon" ),
    ( "Portugal", "Yntenzo" ),
    ( "Puerto Rico", "Exotic Island Aromas" ),
    ( "Puerto Rico", "The Exotic Island Perfumer" ),
    ( "Qatar", "Al-Jazeera Perfumes" ),
    ( "Qatar", "Anec. Perfumery" ),
    ( "Qatar", "S'Ishira Perfumes" ),
    ( "Qatar", "S.Ishira" ),
    ( "Romania", "1918 Parfum National" ),
    ( "Romania", "All Your Personal Aroma" ),
    ( "Romania", "B.A.S.M. by Createur 5 D’Emotions" ),
    ( "Romania", "Calaj" ),
    ( "Romania", "Dana Savuica" ),
    ( "Romania", "EXTRAitORDINAIRE by Createur 5 D’Emotions" ),
    ( "Romania", "Essence de Roumanie" ),
    ( "Romania", "Giulia Nahmany" ),
    ( "Romania", "Livia Rus" ),
    ( "Romania", "Moon by Dana Rogoz" ),
    ( "Rwanda", "Aqua Rwanda" ),
    ( "Scotland", "Jorum Studio" ),
    ( "Serbia", "Aura" ),
    ( "Serbia", "Balint Parfums" ),
    ( "Serbia", "Crea Parfums" ),
    ( "Serbia", "Emina Jahovic" ),
    ( "Serbia", "HRH Princess Elizabeth" ),
    ( "Serbia", "Ipseity" ),
    ( "Serbia", "Zorannah" ),
    ( "Seychelles", "Kreolfleurage Parfums" ),
    ( "Singapore", "Bleulight" ),
    ( "Singapore", "FEN Perfumes" ),
    ( "Singapore", "The Lab Fragrances" ),
    ( "Singapore", "VT x BTS" ),
    ( "Slovakia", "1907" ),
    ( "South Africa", "Frazer Parfum" ),
    ( "South Africa", "Hoity Toity" ),
    ( "South Africa", "Menelik Fragrances" ),
    ( "South Africa", "Rose en Bos" ),
    ( "South Africa", "Titanium Man" ),
    ( "Spain", "Label" ),
    ( "Sri Lanka", "La Signore The Fragrance" ),
    ( "St. Barts", "Calypso Christiane Celle" ),
    ( "Tahiti", "Parfumerie Tiki Tahiti" ),
    ( "Thailand", "Bortnikoff" ),
    ( "Thailand", "Café de Parfum" ),
    ( "Thailand", "Feel Oud" ),
    ( "Thailand", "Itstree" ),
    ( "Thailand", "Lyn" ),
    ( "Thailand", "Mith" ),
    ( "Thailand", "Natural Teller" ),
    ( "Thailand", "Prin" ),
    ( "Thailand", "Prissana" ),
    ( "Thailand", "Proad" ),
    ( "Thailand", "Pryn Parfum" ),
    ( "Thailand", "SIAM 1928" ),
    ( "Thailand", "Strangers Parfumerie" ),
    ( "Thailand", "The Fragrance Engineers" ),
    ( "Ukraine", "AKParfume" ),
    ( "Ukraine", "BZ Parfums" ),
    ( "Ukraine", "Char-Zillya" ),
    ( "Ukraine", "Ervin Viner" ),
    ( "Ukraine", "G Parfums" ),
    ( "Ukraine", "Karen Doué" ),
    ( "Ukraine", "Kharkov perfume factory" ),
    ( "Ukraine", "Mi6ka" ),
    ( "Ukraine", "Mihail Voronin" ),
    ( "Ukraine", "Negligé Perfume Lab" ),
    ( "Ukraine", "Partisan Parfums" ),
    ( "Ukraine", "Red Carnation – Красная гвоздика" ),
    ( "Ukraine", "Votre Parfum" ),
    ( "Ukraine", "le Pelerin" ),
    ( "United States", "American Perfumer" ),
    ( "United States", "Chronotope" ),
    ( "United States", "Come Tees" ),
    ( "United States", "Fray Ardens" ),
    ( "United States", "Gather Perfume" ),
    ( "United States", "Guy Fox" ),
    ( "United States", "Harlem Botanica" ),
    ( "United States", "Ignacio Figueras" ),
    ( "United States", "Lazarus Douvos" ),
    ( "United States", "Mizu" ),
    ( "United States", "Nick Ricardo Collection" ),
    ( "United States", "Olfactum" ),
    ( "United States", "Parallax Olfactory" ),
    ( "United States", "Pomares Stolen Perfume" ),
    ( "United States", "Swank Inc" ),
    ( "United States", "Zaharoff" ),
    ( "Uzbekistan", "Begim" ),
    ( "Uzbekistan", "Guli" ),
    ( "Vietnam", "Levinia" ),
    ( "Vietnam", "Saigon Cosmetics" ),
    ( "Vietnam", "Y25" ) ;