Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write an individual SQL Query that can answer each of the following questions: 1. Should a medium budget restaurant cater to married people or single

image text in transcribedWrite an individual SQL Query that can answer each of the following questions:

1. Should a medium budget restaurant cater to married people or single people?

2. What restaurant is most popular in San Luis Potosi

H J M N PlaceID Price Interest variety Budget medium Ambience Quiet familiar familiar technology low medium low none low variety none medium medium OW low familiar familiar familier familiar variety medium low Activity student student Student professional student student student student student student student Student professional student medium medium medium medium familiar familiar Smoker FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE TRUE variety technology variety technology variety technology retro OW 1987 mone low medium medium medium medium medium medium familiar familiar familiar familiar familiar familiar low medium high medium medium medium medium OWY none technology eco-friendly retro technology variet technology familiar w Student student professional student student professiona student low Quiet medium medium low familiar familiar familiar medium none medium medium high high Usarlo U1001 U1002 U1003 U1004 U1005 U1000 U1007 U1000 U1000 U1010 U1011 U1012 U1013 U1014 U1015 U1016 U1017 U1018 U1010 U1020 U1021 U1022 U1023 U1026 U1020 U1026 U1020 U1030 U1031 U1032 U1033 U1034 U1035 U1030 U1037 U1038 U1030 U1040 U1041 U1042 U1043 U1044 U1045 U1040 U1047 U1050 U1051 U1052 C D Personality Transport thritty-protector on foot hunter-ostentatic public hard- worker public hard-worker public thrifty-protector publie hard- worker car owner thrifty-protector public hard-worker public thrifty protector on foot and worker car owner hard-worker public hard- worker public thrifty-protector public hard-worker public thrifty-protector public thrifty-protector on foot hunter ostentatic public thrifty-protector public thrifty-protector public hard- worker public hard-worker car owner hard-worker car owner hard-worker car owner thrifty-protector public hunter-ostentatic public hard-worker public conformist public hard- worker on foot hard-worker ? hard-worker public hard-worker on foot thrifty-protector public hunter-ostentati car owner hard-worker public thrifty-protector public thrifty-protector public hard-worker ? thrifty-protector public hunter-ostentatic on foot thrifty-protector car owner hard-worker public thrifty-protector car owner thrifty-protector car owner hard-worker car owner thrifty-protector public hard-worker car owner thrifty-protector public conformist on foot medium G Mantal_Status Birth Year Religion single 1989 none single 1900 Catholic single 1989 Catholic Single 1940 none Single 1992 Catholic single 1989 more Single 1989 Catholic Single 1989 Catholic single 1901 Catholic married single 1989 Catholic single 1988 Catholic widow 1982 none single 1990 Catholic Single 1989 Catholic single 1901 Catholic Single 1901 none single 1080 Christian single 1980 Catholic single 1982 Catholic single 1984 Catholic single 1990 Catholic single 1988 Catholic Single 1990 Catholic single 1989 Catholic sngle 1989 Christian single 1900 Catholic single 1001 Catholic mamed 1992 Catholic single 1989 Catholic single 1991 none single 1990 Catholic Single 1985 none Single 1991 Catholic single 1990 Catholic single 1930 Catholic Single 1980 none single 1004 Catholic single 1985 Catholic single 1943 Christian single 1989 none married 1909 Catholic Single 1991 Mormon Single 1990 Catholic single 1992 Catholic single 1960 none single 1970 none single 1900 Catholic Student Student student low Drink_Level Dress_Pret Hijos abstenious informa independent abstemious informal independent social drinker formal independent abstemious informal independent abstemious no preference independent social drinker no preference independent casual drinker informal independent social drinker formal independent abstemious formal kids social drinker no preference kids abstemious no preference Independent casual drinker formal independent abstemious no preference independent abstemious ? independent social drinker informal independent casual drinker informal independent casual drinker formal ? casual drinker formal independent casual drinker no preference independent abstemious no preference independent social drinker no preference dependent casual drinker formal independent casual drinker informal independent social drinker no preference ? abstemious formal independent abstemious no preference independent casual drinker formal independent casual drinker formal independent abstemos informal kids absterious formal independent social drinker no preference ? casual drinker informal independent casual drinker no preference independent social drinker informal independent social drinker no preference independent social drinker no preference independent social drinker no preference independent absterious no preference independent absterious no preference independent abstemious no preference independent abstemious no preference independent social drinker informal kids casual drinker elegant independent social drinker no preference independent abstemious no preference independent social drinker no preference independent casual drinker no preference independent social drinker no preference independent variety none none technology variety variety eco-friendly none variety none technology variety none variety variety none none eco-friendly technology technology variety Name Address 132809 Polic_Frito_Buenos Aires tampico Victoria 122813 carnitas mata lia Emilio portes i Victoria 132830 palomo tec blvnd emilio portes gil Victoria 132007 little pizza Emilio Portes Gil calle emilio portes gil Victoria 132732 Taqueria El amigo Calle Mezquite Fraco Frambor Ciudad Victoria 132755 La Estrella de Dimas Av. de los Pintores San Luis Potos 132768 Mikasa Himno nacionales. Blvd. Jus Cuernavaca 132707 Restaurant Familiar El Chino Paseo de las Fuentes Jiutepec 132768 Mariscos Tia Licha avenida Salvador montie cuernavaca 132773 El cotorreo Emiliano Zapata Col. Tres de Cuernavaca 132825 puesto de tacos esquina santos degollado y le San Luis Potos 132864 Sirona carr. mexico San Luis Potos 132850 Unicols Pizza Plaza del Carmen San Luis Potos 132868 Hamburguesas Valle Dorado Av. Coral San Luis Potos 132861 Carls Av. V. Carranza San Luis Potos 132802 La Posada del Virrey Av V. Carranza San Luis Potosi 122 Tortas y hamburguesas el go Ricardo B. Anaya San Luis Potos 132885 Hamburguesas saul Av. Sean Luis entre moctezur San Luis Potos 132037 rockabilly agustin de turbide san luis potosi 132954 la parroquia venustiano carranza san luis potosi 132965 milanos venustiano carranza San Luis Potos 124023 Restaurant and Bar and Clot Domingo 10 711 El Empleado Cuernavaca 134980 Restaurant Las Mananitas Ricardo Linares 107 Cuernavaca 134000 Kiku Cuernavaca Revolucion Cuernavaca 135018 El Oceano Dorado Libramiento Burgos Colonia L Cuernavaca 138025 El Rincon de San Francisco 1a. de Lozada 1 San Luis Potos 135028 Canting Capitan Caldera No. 420 Teo San Luis Potosi 135027 Restaurant Orizatlan Pascual M. Hemandez 240 San Luis Potosi 125028 La Virreina Av. Carranza 830 San Luis Potos 135032 Cafeteria y Restaurant El Pa Constitucion 200 Centro San Luis Potos 125034 Michiko Restaurant Japones Cordillera de Los Alpes 180 L. San Luis Potos 135041 Luna Cale Francisco I. Madero 215 San Luis Potosi 135042 Restaurant Oriental Express Tangamanga 7 Tangamanga San Luis Potosi 135043 pizza clasica 524 Soledad de Graciano Sar Soledad 135040 Restaurante El Reyecito Agricultura 585 del Valle San Luis Potos 125048 Restaurante Bar Fu hao Jesus Goytortua 300 Tangam: San Luis Potosi 135049 Restaurante de Mariscos la Cordilera de Los Alpes 675 Li San Luis Potosi 135062 La Cantina Restaurante Ignacio Aldama 300 Centro San Luis Potos 135054 Restaurante y Pescaderia Ta Ricardo B. Anaya 2700 Estrell San Luis Potosi 135057 El Herradero Restaurante an Costado Sur Central Camione San Luis Potosi 135060 Restaurant Bar Hacienda los Santos Degollado 745 los Alar San Luis Potosi Ala 135060 Restaurante Marisco Sam Ignacio Allende 785 Centro San Luis Potosi 135000 Abondance Restaurante Bar Industrias 908 Valle Dorado San Luis Potos 135071 Restaurante la Cantina De La Estrela 2005 Estrela d San Luis Potosi 135073 Restaurante Bar El Gallinero Pascual M. Hemandez 210 C: San Luis Potosi 135074 Restaurante la Parroquia Pol Venustiano Carranza 300 Cer San Luis Potosi 135085 Tortas Locas Hipocampo Venustiano Carranza 719 Cer San Luis Potosi 125088 Mcdonalds Parque Tangama Lateral Salvador Nava Martin San Luis Potosi Ambience family family family family family friends stary solitary family friends family family friends friends family friends family friends family friends family family friends family family family family family solitary family family family friends family family family friends friends friends family solitary family friends friends family family family family State Country Tamauipes Mexico Tamaulipas Medico tamaulipas Mexico tamaulipas Mexico Tamaulipas Medoc SLP Mexico Morelos Mexico Morelos Mexico morelos med Morelos Mexico mexico San Luis Potosi Medico San Luis Potosi Mexico San Luis Potos Medico San Luis Potosi Mexico San Luis Potosi Mexico San Luis Potosi Medico San Luis Potosi mexico san luis potosi medico san luis potosi Mexico mexico Mexico Morelos Medoc Morelos Mexico Morelos Madoo Morelos Mexico SLP Mexico SLP Mexico SLP Mexico SLP Meadoo SLP Mexico SLP Medco SLP Mexico SLP Mexico SLP Mexico SUP Mexico SLP Madoo SUP Mexico SLP Medico SLP Mexico SUP Mexico SLP Medoo SLP Mexico SLP Mexico SLP Mexico SLP Mexico SLP Mexico SLP Mexico SLP Medico Alcohol No_Alcohol Served No Alcohol Served No_Alcohol_Served No_Alcohol Served No_Alcohol_Served No_Alcohol_Served Wine-Beer Wine-Beer No_Alcohol Served Wine-Bees No Alcohol Served Wine Beer Wine-Beer No_Alcohol_Served No_Alcohol_Served Wine-Beer No Alcohol Served No_Alcohol_Served Full Bar No_Alcohol Served Wine-Beer Full_Bar Wine-Bee No Alcohol Served Full_Bar No_Alcohol_Served Full Bar Wine-Beer Wine Bee Wine-Beer No_Alcohol_Served Wine-Beer No_Alcohol Served No_Alcohol Served No_Alcohol_Served Wine-Beer No_Alcohol Served Full_Bar No Alcohol Served Wine-Beer Wine Beer No_Alcohol_Served Wine-Beer Full_Bar Wine-Beel Wine-Beer No_Alcohol Served No Alcohol Served FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE Smoking Area Dress Code not permitted informal permitted informal none informa none informal none casual none informal none informal permitted casua not permitted CU casual permitted informa none informal none informal none informal none Informal not permitted informal none casual not permitted informa none informal section informal not permitted informal none Informa section informal none formal none informal permitted informal none Informal none informa none informal none informal Section informal none informal none informal none informal none informal none informal none informal none informal none informal none informa section informal section informal none informal none Informal section informal section informal section informal not permitted informal not permitted informa medium medium medium low medium medium high medium medium medium medium medium Student student student student unemployed student student student student student Student student medium medium medium low medium medium medium medium medium medium high medium high high medium familiar familiar familiar familiar familiar familiar familiar familier familiar familiar familiar familiar familier familiar familier familiar familiar familiar familiar familiar familiar low low medium medium low student student professional student Student professional Student student student student professional student medium medium medium high medium medium high medium medium medium medium low familiar familiar echnology retro medium high high medium medium retro familier familiar familiar variety variety none H J M N PlaceID Price Interest variety Budget medium Ambience Quiet familiar familiar technology low medium low none low variety none medium medium OW low familiar familiar familier familiar variety medium low Activity student student Student professional student student student student student student student Student professional student medium medium medium medium familiar familiar Smoker FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE TRUE variety technology variety technology variety technology retro OW 1987 mone low medium medium medium medium medium medium familiar familiar familiar familiar familiar familiar low medium high medium medium medium medium OWY none technology eco-friendly retro technology variet technology familiar w Student student professional student student professiona student low Quiet medium medium low familiar familiar familiar medium none medium medium high high Usarlo U1001 U1002 U1003 U1004 U1005 U1000 U1007 U1000 U1000 U1010 U1011 U1012 U1013 U1014 U1015 U1016 U1017 U1018 U1010 U1020 U1021 U1022 U1023 U1026 U1020 U1026 U1020 U1030 U1031 U1032 U1033 U1034 U1035 U1030 U1037 U1038 U1030 U1040 U1041 U1042 U1043 U1044 U1045 U1040 U1047 U1050 U1051 U1052 C D Personality Transport thritty-protector on foot hunter-ostentatic public hard- worker public hard-worker public thrifty-protector publie hard- worker car owner thrifty-protector public hard-worker public thrifty protector on foot and worker car owner hard-worker public hard- worker public thrifty-protector public hard-worker public thrifty-protector public thrifty-protector on foot hunter ostentatic public thrifty-protector public thrifty-protector public hard- worker public hard-worker car owner hard-worker car owner hard-worker car owner thrifty-protector public hunter-ostentatic public hard-worker public conformist public hard- worker on foot hard-worker ? hard-worker public hard-worker on foot thrifty-protector public hunter-ostentati car owner hard-worker public thrifty-protector public thrifty-protector public hard-worker ? thrifty-protector public hunter-ostentatic on foot thrifty-protector car owner hard-worker public thrifty-protector car owner thrifty-protector car owner hard-worker car owner thrifty-protector public hard-worker car owner thrifty-protector public conformist on foot medium G Mantal_Status Birth Year Religion single 1989 none single 1900 Catholic single 1989 Catholic Single 1940 none Single 1992 Catholic single 1989 more Single 1989 Catholic Single 1989 Catholic single 1901 Catholic married single 1989 Catholic single 1988 Catholic widow 1982 none single 1990 Catholic Single 1989 Catholic single 1901 Catholic Single 1901 none single 1080 Christian single 1980 Catholic single 1982 Catholic single 1984 Catholic single 1990 Catholic single 1988 Catholic Single 1990 Catholic single 1989 Catholic sngle 1989 Christian single 1900 Catholic single 1001 Catholic mamed 1992 Catholic single 1989 Catholic single 1991 none single 1990 Catholic Single 1985 none Single 1991 Catholic single 1990 Catholic single 1930 Catholic Single 1980 none single 1004 Catholic single 1985 Catholic single 1943 Christian single 1989 none married 1909 Catholic Single 1991 Mormon Single 1990 Catholic single 1992 Catholic single 1960 none single 1970 none single 1900 Catholic Student Student student low Drink_Level Dress_Pret Hijos abstenious informa independent abstemious informal independent social drinker formal independent abstemious informal independent abstemious no preference independent social drinker no preference independent casual drinker informal independent social drinker formal independent abstemious formal kids social drinker no preference kids abstemious no preference Independent casual drinker formal independent abstemious no preference independent abstemious ? independent social drinker informal independent casual drinker informal independent casual drinker formal ? casual drinker formal independent casual drinker no preference independent abstemious no preference independent social drinker no preference dependent casual drinker formal independent casual drinker informal independent social drinker no preference ? abstemious formal independent abstemious no preference independent casual drinker formal independent casual drinker formal independent abstemos informal kids absterious formal independent social drinker no preference ? casual drinker informal independent casual drinker no preference independent social drinker informal independent social drinker no preference independent social drinker no preference independent social drinker no preference independent absterious no preference independent absterious no preference independent abstemious no preference independent abstemious no preference independent social drinker informal kids casual drinker elegant independent social drinker no preference independent abstemious no preference independent social drinker no preference independent casual drinker no preference independent social drinker no preference independent variety none none technology variety variety eco-friendly none variety none technology variety none variety variety none none eco-friendly technology technology variety Name Address 132809 Polic_Frito_Buenos Aires tampico Victoria 122813 carnitas mata lia Emilio portes i Victoria 132830 palomo tec blvnd emilio portes gil Victoria 132007 little pizza Emilio Portes Gil calle emilio portes gil Victoria 132732 Taqueria El amigo Calle Mezquite Fraco Frambor Ciudad Victoria 132755 La Estrella de Dimas Av. de los Pintores San Luis Potos 132768 Mikasa Himno nacionales. Blvd. Jus Cuernavaca 132707 Restaurant Familiar El Chino Paseo de las Fuentes Jiutepec 132768 Mariscos Tia Licha avenida Salvador montie cuernavaca 132773 El cotorreo Emiliano Zapata Col. Tres de Cuernavaca 132825 puesto de tacos esquina santos degollado y le San Luis Potos 132864 Sirona carr. mexico San Luis Potos 132850 Unicols Pizza Plaza del Carmen San Luis Potos 132868 Hamburguesas Valle Dorado Av. Coral San Luis Potos 132861 Carls Av. V. Carranza San Luis Potos 132802 La Posada del Virrey Av V. Carranza San Luis Potosi 122 Tortas y hamburguesas el go Ricardo B. Anaya San Luis Potos 132885 Hamburguesas saul Av. Sean Luis entre moctezur San Luis Potos 132037 rockabilly agustin de turbide san luis potosi 132954 la parroquia venustiano carranza san luis potosi 132965 milanos venustiano carranza San Luis Potos 124023 Restaurant and Bar and Clot Domingo 10 711 El Empleado Cuernavaca 134980 Restaurant Las Mananitas Ricardo Linares 107 Cuernavaca 134000 Kiku Cuernavaca Revolucion Cuernavaca 135018 El Oceano Dorado Libramiento Burgos Colonia L Cuernavaca 138025 El Rincon de San Francisco 1a. de Lozada 1 San Luis Potos 135028 Canting Capitan Caldera No. 420 Teo San Luis Potosi 135027 Restaurant Orizatlan Pascual M. Hemandez 240 San Luis Potosi 125028 La Virreina Av. Carranza 830 San Luis Potos 135032 Cafeteria y Restaurant El Pa Constitucion 200 Centro San Luis Potos 125034 Michiko Restaurant Japones Cordillera de Los Alpes 180 L. San Luis Potos 135041 Luna Cale Francisco I. Madero 215 San Luis Potosi 135042 Restaurant Oriental Express Tangamanga 7 Tangamanga San Luis Potosi 135043 pizza clasica 524 Soledad de Graciano Sar Soledad 135040 Restaurante El Reyecito Agricultura 585 del Valle San Luis Potos 125048 Restaurante Bar Fu hao Jesus Goytortua 300 Tangam: San Luis Potosi 135049 Restaurante de Mariscos la Cordilera de Los Alpes 675 Li San Luis Potosi 135062 La Cantina Restaurante Ignacio Aldama 300 Centro San Luis Potos 135054 Restaurante y Pescaderia Ta Ricardo B. Anaya 2700 Estrell San Luis Potosi 135057 El Herradero Restaurante an Costado Sur Central Camione San Luis Potosi 135060 Restaurant Bar Hacienda los Santos Degollado 745 los Alar San Luis Potosi Ala 135060 Restaurante Marisco Sam Ignacio Allende 785 Centro San Luis Potosi 135000 Abondance Restaurante Bar Industrias 908 Valle Dorado San Luis Potos 135071 Restaurante la Cantina De La Estrela 2005 Estrela d San Luis Potosi 135073 Restaurante Bar El Gallinero Pascual M. Hemandez 210 C: San Luis Potosi 135074 Restaurante la Parroquia Pol Venustiano Carranza 300 Cer San Luis Potosi 135085 Tortas Locas Hipocampo Venustiano Carranza 719 Cer San Luis Potosi 125088 Mcdonalds Parque Tangama Lateral Salvador Nava Martin San Luis Potosi Ambience family family family family family friends stary solitary family friends family family friends friends family friends family friends family friends family family friends family family family family family solitary family family family friends family family family friends friends friends family solitary family friends friends family family family family State Country Tamauipes Mexico Tamaulipas Medico tamaulipas Mexico tamaulipas Mexico Tamaulipas Medoc SLP Mexico Morelos Mexico Morelos Mexico morelos med Morelos Mexico mexico San Luis Potosi Medico San Luis Potosi Mexico San Luis Potos Medico San Luis Potosi Mexico San Luis Potosi Mexico San Luis Potosi Medico San Luis Potosi mexico san luis potosi medico san luis potosi Mexico mexico Mexico Morelos Medoc Morelos Mexico Morelos Madoo Morelos Mexico SLP Mexico SLP Mexico SLP Mexico SLP Meadoo SLP Mexico SLP Medco SLP Mexico SLP Mexico SLP Mexico SUP Mexico SLP Madoo SUP Mexico SLP Medico SLP Mexico SUP Mexico SLP Medoo SLP Mexico SLP Mexico SLP Mexico SLP Mexico SLP Mexico SLP Mexico SLP Medico Alcohol No_Alcohol Served No Alcohol Served No_Alcohol_Served No_Alcohol Served No_Alcohol_Served No_Alcohol_Served Wine-Beer Wine-Beer No_Alcohol Served Wine-Bees No Alcohol Served Wine Beer Wine-Beer No_Alcohol_Served No_Alcohol_Served Wine-Beer No Alcohol Served No_Alcohol_Served Full Bar No_Alcohol Served Wine-Beer Full_Bar Wine-Bee No Alcohol Served Full_Bar No_Alcohol_Served Full Bar Wine-Beer Wine Bee Wine-Beer No_Alcohol_Served Wine-Beer No_Alcohol Served No_Alcohol Served No_Alcohol_Served Wine-Beer No_Alcohol Served Full_Bar No Alcohol Served Wine-Beer Wine Beer No_Alcohol_Served Wine-Beer Full_Bar Wine-Beel Wine-Beer No_Alcohol Served No Alcohol Served FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE Smoking Area Dress Code not permitted informal permitted informal none informa none informal none casual none informal none informal permitted casua not permitted CU casual permitted informa none informal none informal none informal none Informal not permitted informal none casual not permitted informa none informal section informal not permitted informal none Informa section informal none formal none informal permitted informal none Informal none informa none informal none informal Section informal none informal none informal none informal none informal none informal none informal none informal none informal none informa section informal section informal none informal none Informal section informal section informal section informal not permitted informal not permitted informa medium medium medium low medium medium high medium medium medium medium medium Student student student student unemployed student student student student student Student student medium medium medium low medium medium medium medium medium medium high medium high high medium familiar familiar familiar familiar familiar familiar familiar familier familiar familiar familiar familiar familier familiar familier familiar familiar familiar familiar familiar familiar low low medium medium low student student professional student Student professional Student student student student professional student medium medium medium high medium medium high medium medium medium medium low familiar familiar echnology retro medium high high medium medium retro familier familiar familiar variety variety none

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions