You will use the attached sql to create a table of employees. You will write a s
ID: 3723649 • Letter: Y
Question
You will use the attached sql to create a table of employees. You will write a separate query for each of the following questions. Each statement is worth 4 points. Be sure to test!
Get me everyone's names and emails
Select everyone whose last name begins with a ‘Z’
Select everyone who has an academic email (.edu)
Get me all employees with a 134 area code.
All American Employees have zip codes that are 5 digits long. Get me all non-american emplies
Code of sql attached: (employees.sql):
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `mmaaaco_hhassan`
--
-- --------------------------------------------------------
--
-- Table structure for table `employees`
--
CREATE TABLE IF NOT EXISTS `employees` (
`id` int(8) unsigned NOT NULL auto_increment,
`fullname` varchar(255) default NULL,
`email` varchar(255) default NULL,
`phone` varchar(100) default NULL,
`zip` varchar(10) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=201 ;
--
-- Dumping data for table `employees`
--
INSERT INTO `employees` (`id`, `fullname`, `email`, `phone`, `zip`) VALUES
(1, 'Stafford, Haviva F.', 'tellus.imperdiet.non@lectusrutrum.com', '(560) 198-7371', '9575FL'),
(2, 'Clark, Remedios S.', 'lorem.eget.mollis@lacus.edu', '(166) 692-2022', '56019'),
(3, 'Middleton, Abdul T.', 'et.malesuada@feugiat.edu', '(919) 170-1467', '93113'),
(4, 'Pugh, Buffy Z.', 'cursus@facilisiSedneque.com', '(773) 903-8128', '0397SX'),
(5, 'Burris, Patience C.', 'ut.odio.vel@dignissim.com', '(453) 600-3304', '59752'),
(6, 'Stevens, Renee G.', 'est.ac@arcu.org', '(321) 595-8495', 'X8B 4O9'),
(7, 'Lancaster, Ulric R.', 'Etiam.ligula@Quisqueporttitor.edu', '(191) 464-5785', 'Z3H 4JF'),
(8, 'Holden, Elton O.', 'felis.ullamcorper.viverra@rutrumlorem.edu', '(915) 215-1397', 'NP08 3ZF'),
(9, 'Huber, Lynn O.', 'lacinia.Sed.congue@nisi.org', '(489) 470-9925', 'M7 2ZH'),
(10, 'Alexander, Salvador E.', 'consectetuer@aliquetPhasellus.com', '(952) 997-3877', '64925'),
(11, 'Pearson, Karly H.', 'Nunc.ullamcorper.velit@enimEtiam.org', '(777) 251-0130', 'J8W 1K6'),
(12, 'Sutton, Raven Q.', 'neque@In.org', '(942) 510-2817', 'W4F 9O5'),
(13, 'Herring, Samantha R.', 'malesuada@metussit.org', '(558) 227-6437', 'Q6I 6VF'),
(14, 'Barnett, Ariel E.', 'bibendum.ullamcorper@vestibulum.com', '(307) 481-8641', 'P7W 1I5'),
(15, 'Nguyen, Natalie E.', 'lectus.pede@dapibus.edu', '(810) 843-9167', 'L7S 9VH'),
(16, 'Padilla, Merritt J.', 'Aenean.euismod.mauris@blandit.com', '(656) 265-2637', '8612GP'),
(17, 'Wheeler, Abbot M.', 'Sed.molestie.Sed@dictum.org', '(276) 812-3739', 'R63 6BG'),
(18, 'Cotton, Garth L.', 'elit.erat@Duisdignissim.com', '(384) 846-5147', '57784'),
(19, 'Leon, Jana U.', 'Etiam@sed.ca', '(505) 968-2430', '60344'),
(20, 'Walters, Claire G.', 'ligula.Donec.luctus@purusDuiselementum.com', '(558) 506-0129', 'G2N 4D4'),
(21, 'Clay, Aiko W.', 'mauris.id@eleifend.ca', '(115) 540-0351', 'G3 5AM'),
(22, 'Downs, Sage Z.', 'Aliquam@augueid.org', '(361) 490-4169', 'AX2 1YW'),
(23, 'Donaldson, Igor M.', 'in.faucibus@lacinia.org', '(501) 664-2882', 'I5D 8F1'),
(24, 'Jarvis, Raymond I.', 'at.velit.Pellentesque@pharetrasedhendrerit.ca', '(260) 945-9516', '4863CY'),
(25, 'Dyer, Sarah V.', 'est@euultrices.org', '(484) 366-9753', 'Z41 0XP'),
(26, 'Knowles, Tarik X.', 'tellus@perconubianostra.com', '(868) 342-1958', 'OE9 8SX'),
(27, 'Sykes, Graham X.', 'hendrerit@nuncinterdumfeugiat.com', '(821) 149-7322', '1117SS'),
(28, 'Mendez, Tashya P.', 'nisi.Cum@dapibusidblandit.com', '(292) 930-1516', '06170'),
(29, 'Talley, Drew E.', 'cursus@ipsumCurabiturconsequat.edu', '(557) 501-6046', '8965LP'),
(30, 'Buckley, Luke T.', 'Aenean.massa@ante.com', '(182) 906-4714', '52497'),
(31, 'Vance, Drew L.', 'Nullam.lobortis.quam@massa.com', '(776) 799-7716', '15954'),
(32, 'Brooks, Rana S.', 'pede@etrutrum.ca', '(933) 977-6444', '1248AH'),
(33, 'Leach, Adria G.', 'mattis.velit@vel.org', '(370) 779-0097', 'GG9R 5EX'),
(34, 'Blackwell, Alfreda X.', 'interdum@etipsum.org', '(454) 981-0690', '94757'),
(35, 'Lott, Anastasia K.', 'posuere.cubilia@metus.ca', '(298) 655-0199', 'B6B 2I0'),
(36, 'Salas, Brittany V.', 'dapibus.rutrum.justo@Vestibulumanteipsum.ca', '(592) 274-1616', 'U3D 7K2'),
(37, 'Johnson, Hasad J.', 'ac.tellus.Suspendisse@enimgravida.com', '(201) 406-3281', '79600'),
(38, 'Douglas, Ignatius F.', 'Aenean@pretiumet.edu', '(726) 379-4818', '11729'),
(39, 'Atkins, Myles X.', 'urna@Sedcongueelit.com', '(299) 650-3776', 'BL8 8HR'),
(40, 'Jarvis, Addison J.', 'sed@tincidunt.com', '(433) 254-0515', 'KI1 9ZF'),
(41, 'Savage, Ian C.', 'Donec.tempor.est@mauris.ca', '(469) 693-9245', 'CW07 3MB'),
(42, 'Ingram, Kristen B.', 'ultricies.adipiscing.enim@Aliquameratvolutpat.org', '(498) 234-1934', 'XN3K 6GM'),
(43, 'Myers, Gail Z.', 'neque.Sed@sedest.ca', '(428) 968-7811', 'O5D 2J6'),
(44, 'Ramirez, Leila G.', 'vitae.posuere.at@gravidasit.edu', '(976) 470-6693', 'F6W 1UL'),
(45, 'Trevino, May Q.', 'enim@consequat.ca', '(193) 623-3970', '6870PY'),
(46, 'Jefferson, Noel D.', 'accumsan.neque@asollicitudinorci.org', '(897) 678-5147', 'R2U 6QK'),
(47, 'Harrington, Joy N.', 'consectetuer@magna.com', '(742) 201-0768', 'Y1Z 4U6'),
(48, 'Mccall, Libby H.', 'dui@duiaugueeu.org', '(897) 444-9759', 'SN4I 7JK'),
(49, 'Rhodes, Nell F.', 'quam.a@egetmagnaSuspendisse.org', '(842) 331-0764', '0526HT'),
(50, 'Mills, Benedict L.', 'vehicula.risus@cubilia.edu', '(550) 218-6309', 'Q2O 3P5'),
(51, 'Sanchez, Shoshana F.', 'rutrum@facilisis.ca', '(781) 106-5087', '1937BZ'),
(52, 'Mcclain, Wesley G.', 'dictum.sapien@velit.com', '(386) 184-8048', 'X5U 7X9'),
(53, 'Crawford, Noble S.', 'vel.vulputate.eu@Proinvel.com', '(245) 587-4473', 'IG4Z 2JM'),
(54, 'Burnett, Amir J.', 'feugiat@Nuncullamcorper.org', '(739) 253-7014', 'G8M 8DT'),
(55, 'Byers, Felix A.', 'ac.facilisis.facilisis@sodales.ca', '(165) 722-1146', 'S7Q 2I9'),
(56, 'Salas, Ahmed U.', 'eget@vehicula.org', '(786) 686-1343', 'ND20 2YS'),
(57, 'Cantu, Vladimir A.', 'enim.Mauris.quis@dolordolortempus.com', '(475) 954-5022', 'T63 3EM'),
(58, 'Cole, Kieran T.', 'euismod.et@erategettincidunt.ca', '(677) 201-9614', 'N4 0UB'),
(59, 'Hodges, Raja K.', 'lectus@Etiambibendumfermentum.ca', '(616) 476-9531', 'BH6 5KJ'),
(60, 'Rosa, Alfonso J.', 'ultrices.Duis.volutpat@faucibus.com', '(381) 968-0218', 'J3G 9U3'),
(61, 'Herman, David W.', 'odio.Etiam@laoreetlectusquis.edu', '(723) 955-7753', 'QU3 5XT'),
(62, 'Church, Quynn S.', 'sit.amet@acfermentumvel.com', '(672) 189-3288', 'QH92 8OA'),
(63, 'Boyer, Dahlia X.', 'magna.malesuada.vel@parturient.com', '(663) 920-2291', 'A5Z 6C2'),
(64, 'Glenn, Keane C.', 'quam@malesuada.com', '(303) 949-6898', 'C9I 6C3'),
(65, 'Baxter, Bradley Y.', 'justo@arcuVestibulum.com', '(697) 720-7592', 'BN4 9SN'),
(66, 'Bean, Tanner E.', 'Nulla.tincidunt.neque@ac.com', '(538) 173-0412', '84130'),
(67, 'Todd, Dane M.', 'non@Nam.org', '(200) 514-0420', 'C67 3BQ'),
(68, 'Knight, Brynn U.', 'ante.iaculis@sem.edu', '(300) 462-4765', 'B3 7GZ'),
(69, 'Sosa, Tashya R.', 'mi@viverra.com', '(189) 129-3307', 'E7X 8X6'),
(70, 'Fisher, Scott K.', 'aptent@posuere.ca', '(582) 833-7240', '33435'),
(71, 'Bentley, Mira L.', 'ut.mi@arcu.com', '(435) 734-2161', 'W8L 8B2'),
(72, 'Hamilton, Colorado S.', 'sit.amet@estac.com', '(853) 287-5358', 'ZN84 5SG'),
(73, 'Mcgee, Wyoming I.', 'fringilla@Integervulputaterisus.com', '(629) 905-3231', 'PO53 5AF'),
(74, 'Lopez, Abel X.', 'ultrices@Nullamsuscipit.org', '(335) 698-6891', 'M3W 2X4'),
(75, 'Dorsey, Mikayla Y.', 'adipiscing.non.luctus@Curae;Phasellusornare.com', '(278) 841-1980', '9751WA'),
(76, 'Reynolds, Hayes E.', 'id@sagittisplaceratCras.edu', '(590) 732-5109', 'Y2G 7P1'),
(77, 'Cardenas, Jermaine H.', 'enim.Mauris@dolorvitae.com', '(921) 547-4457', 'Z8Y 4B8'),
(78, 'Frost, Justine Q.', 'Aenean@mollis.ca', '(544) 673-8983', '8115EC'),
(79, 'Bush, Illiana L.', 'at.lacus@Integereulacus.org', '(127) 302-6484', 'IR0Z 0VD'),
(80, 'Hayes, Britanni H.', 'ultrices@sitamet.com', '(461) 164-8940', '80764'),
(81, 'Montoya, Irene K.', 'est.vitae@ligulaelit.ca', '(886) 340-6017', 'PS96 3XO'),
(82, 'Morrison, Hilary E.', 'ultrices.iaculis.odio@Phasellusvitaemauris.org', '(371) 259-8738', '9124UY'),
(83, 'Hull, Jeanette H.', 'malesuada.id@etarcuimperdiet.edu', '(509) 762-3749', 'R1B 2O0'),
(84, 'Robertson, Evan N.', 'tincidunt@sedturpisnec.ca', '(456) 471-4780', 'V4E 5R8'),
(85, 'Poole, Keelie Z.', 'vitae@et.com', '(452) 956-4292', '0250NJ'),
(86, 'Oliver, John V.', 'enim@mitempor.org', '(467) 391-8104', 'RU80 2XJ'),
(87, 'Walters, Plato W.', 'Mauris@quispede.org', '(134) 671-3005', 'R3A 3Z7'),
(88, 'Benjamin, Brendan A.', 'eget@nibhdolornonummy.com', '(838) 899-1458', '95487'),
(89, 'Byers, Brenna U.', 'Sed.nunc@felispurus.edu', '(655) 348-2860', 'EF00 7ZA'),
(90, 'Holland, Erasmus V.', 'mattis@augueeutempor.ca', '(134) 399-8236', 'I5Z 9T2'),
(91, 'Sexton, Yoko Y.', 'et.netus.et@varius.org', '(396) 287-5395', '86438'),
(92, 'Strong, Paula V.', 'elit.pede@pede.com', '(953) 299-5966', '2037IB'),
(93, 'Weber, Lacey M.', 'et.tristique.pellentesque@luctus.org', '(936) 586-0180', '9707EG'),
(94, 'Jennings, Sean A.', 'sed@Namconsequat.edu', '(592) 351-6164', '66889'),
(95, 'Mendoza, Ross A.', 'placerat.eget@egestas.com', '(358) 868-3515', '1396CU'),
(96, 'Paul, Glenna Q.', 'Donec@insodales.org', '(159) 482-9606', '2694XD'),
(97, 'Townsend, Nicholas V.', 'nascetur.ridiculus.mus@sit.com', '(417) 287-7815', 'F2V 7N1'),
(98, 'Humphrey, Drake N.', 'justo@nisi.com', '(176) 500-7825', '47549'),
(99, 'Mcbride, Octavius T.', 'nisi.Aenean@orcilacusvestibulum.org', '(481) 696-6721', '8644FL'),
(100, 'Wood, Samantha Z.', 'nunc@velconvallisin.org', '(195) 749-6655', 'G5G 1U0'),
(101, 'Forbes, Merrill N.', 'elit.sed.consequat@nuncsit.org', '(674) 544-4029', '54385'),
(102, 'Gonzales, Matthew W.', 'leo.elementum.sem@auctorquistristique.com', '(521) 819-4939', '33023'),
(103, 'Stanley, Vanna U.', 'arcu@imperdietnon.edu', '(362) 206-6284', '83176'),
(104, 'Bridges, Veda B.', 'ornare@posuerevulputate.edu', '(229) 520-7929', '52706'),
(105, 'Sosa, Josiah A.', 'at.pretium@nibhvulputatemauris.org', '(850) 243-3738', '5955WK'),
(106, 'Carrillo, Blaze D.', 'aliquam@Morbineque.ca', '(355) 733-2457', '50653'),
(107, 'Hickman, Darryl X.', 'eu.arcu.Morbi@lectus.com', '(402) 191-2570', 'I3O 1B3'),
(108, 'Cabrera, Maite A.', 'vehicula@malesuada.com', '(187) 931-9519', '4453MV'),
(109, 'Bass, Nayda Y.', 'Cras.sed.leo@liberolacus.com', '(736) 387-1564', 'AV5 7IA'),
(110, 'Salazar, Clio K.', 'Praesent.eu.dui@auctor.org', '(811) 758-1219', '4671HT'),
(111, 'Rodgers, Wayne N.', 'dui@netusetmalesuada.edu', '(472) 221-3489', 'F5Z 3T4'),
(112, 'Johnson, Uma N.', 'luctus@Morbineque.org', '(774) 899-5208', '2235HP'),
(113, 'Donovan, Athena V.', 'lorem.fringilla.ornare@diamDuismi.edu', '(956) 924-6726', 'XT52 1UN'),
(114, 'Guzman, Kieran V.', 'sit@pharetra.com', '(775) 961-5549', 'F9W 9V6'),
(115, 'Booker, Ingrid U.', 'erat@interdumligula.com', '(505) 532-1918', '34766'),
(116, 'Madden, Wendy O.', 'aliquet.diam.Sed@massa.com', '(950) 315-8102', '4342LE'),
(117, 'Trevino, Lucy X.', 'rutrum@ornareelitelit.edu', '(712) 162-5656', '8262LB'),
(118, 'Stevens, Maryam H.', 'quam@dolorFuscefeugiat.ca', '(258) 965-1957', 'L7V 6E6'),
(119, 'Rowe, Seth X.', 'blandit@antedictum.edu', '(620) 612-1018', '8100IM'),
(120, 'Byrd, Roary D.', 'eget.ipsum.Suspendisse@nuncinterdumfeugiat.org', '(362) 578-6848', 'W2 5KN'),
(121, 'Maxwell, Fleur O.', 'ultricies.adipiscing@sodales.edu', '(217) 284-4569', '5194EO'),
(122, 'Hammond, Emmanuel C.', 'commodo.at.libero@Maurismolestie.com', '(715) 917-0999', '4027MW'),
(123, 'Hodge, Teegan I.', 'sit@Craseu.edu', '(434) 682-7319', 'Y1E 3J6'),
(124, 'Mullen, Eve L.', 'nisl.Quisque.fringilla@arcu.ca', '(424) 837-1740', 'J2E 5K1'),
(125, 'Mcdaniel, Jamal K.', 'rhoncus.Proin.nisl@molestietellusAenean.org', '(509) 783-9322', '0540TV'),
(126, 'Vincent, Dylan H.', 'semper.rutrum.Fusce@nonsapienmolestie.com', '(651) 116-0149', '2863HS'),
(127, 'Prince, Sylvia U.', 'Mauris.magna@augue.ca', '(755) 101-5117', '9215RK'),
(128, 'Galloway, Hayley T.', 'rutrum.Fusce.dolor@leoCras.ca', '(399) 887-4374', '6715ZC'),
(129, 'Church, Samantha Q.', 'in.hendrerit@mi.com', '(789) 272-1609', 'I09 8LR'),
(130, 'Martin, Lunea F.', 'Donec.tempus@amet.com', '(533) 470-2729', '5028PP'),
(131, 'Mcdowell, Wang L.', 'pellentesque.eget@dui.com', '(764) 590-8235', 'G5M 2XZ'),
(132, 'Carpenter, Emery W.', 'Vestibulum.ante.ipsum@Inornaresagittis.edu', '(272) 219-7636', 'Z1T 4P9'),
(133, 'Battle, Vanna F.', 'Nunc.sed.orci@odioauctor.ca', '(467) 989-6108', '44516'),
(134, 'Cook, Jin J.', 'magna.Lorem.ipsum@feugiatSed.ca', '(658) 157-4253', '0248HH'),
(135, 'Page, Griffin U.', 'a.auctor@congue.org', '(150) 835-4260', 'H5O 4Y5'),
(136, 'Harrell, Miranda M.', 'ante.blandit.viverra@placeratorcilacus.com', '(496) 167-6669', 'F9C 3B3'),
(137, 'Meadows, Peter U.', 'nonummy.ut.molestie@Fuscealiquet.org', '(574) 218-0897', 'JH5 6KU'),
(138, 'Kent, Justin A.', 'a.ultricies@consequatpurusMaecenas.org', '(531) 506-2574', '23599'),
(139, 'Decker, Victor O.', 'at.pretium@scelerisquemollis.edu', '(469) 276-6181', '3718DA'),
(140, 'Lester, Bertha O.', 'natoque@utquam.edu', '(184) 198-7994', 'QN78 9CP'),
(141, 'Turner, Charissa S.', 'et@eget.edu', '(823) 832-3421', 'C7W 7I3'),
(142, 'Chavez, Henry K.', 'nulla.vulputate@justofaucibus.com', '(747) 545-8731', 'QF8V 4YN'),
(143, 'Merrill, Eaton V.', 'sollicitudin.a.malesuada@et.org', '(769) 343-9984', 'XA65 6VK'),
(144, 'Cunningham, Jonas I.', 'luctus@eumetusIn.edu', '(982) 558-4827', '5201EC'),
(145, 'Rhodes, Quentin T.', 'molestie.sodales@libero.org', '(324) 144-9794', '3801DR'),
(146, 'Dean, Honorato V.', 'nec.diam@Vivamuseuismod.edu', '(252) 905-2456', '4899EH'),
(147, 'Emerson, Tad K.', 'tincidunt@utquamvel.org', '(453) 764-2943', 'U0J 7NT'),
(148, 'Knowles, Kenyon T.', 'nonummy.ultricies.ornare@euismodin.edu', '(790) 964-5921', 'C8V 5OP'),
(149, 'Valencia, Latifah I.', 'et@nonmassanon.com', '(640) 567-4671', '0345VO'),
(150, 'Nash, Imogene C.', 'sapien.imperdiet.ornare@accumsanlaoreetipsum.org', '(754) 400-8154', 'C6D 2X2'),
(151, 'Gomez, Kirsten T.', 'consequat.lectus@mauris.ca', '(236) 194-6386', 'T9B 6ZE'),
(152, 'Brewer, Dominic K.', 'enim@dapibusidblandit.edu', '(442) 444-7046', 'Z4U 4Z5'),
(153, 'Beach, Erasmus F.', 'luctus@loremauctor.org', '(665) 279-5939', 'B9S 6A7'),
(154, 'Sanford, Ulla B.', 'auctor.quis.tristique@pedeSuspendisse.org', '(610) 986-6384', '4638SK'),
(155, 'Holmes, Penelope Z.', 'nibh.Donec.est@imperdietdictummagna.edu', '(895) 752-9527', '10344'),
(156, 'Calhoun, Pascale V.', 'malesuada.vel@ac.com', '(314) 276-9626', '6763AN'),
(157, 'Blanchard, Kai V.', 'Nullam.enim.Sed@egestasa.com', '(296) 528-6793', '05519'),
(158, 'White, Cooper Q.', 'mauris.ut@sit.edu', '(905) 619-7152', '8131MH'),
(159, 'Benton, Charles X.', 'diam.Pellentesque@vitae.org', '(738) 838-8930', 'F5J 6W2'),
(160, 'Donovan, Quinn K.', 'mauris@sociisnatoque.com', '(935) 302-6909', '91982'),
(161, 'Frazier, Burton P.', 'Nunc.mauris.elit@enimSednulla.com', '(289) 713-7590', 'Q5D 6G0'),
(162, 'Harris, Kyra Z.', 'non.lacinia@Nam.edu', '(880) 432-2293', 'WO74 7IZ'),
(163, 'Wilkerson, Sheila F.', 'placerat.Cras.dictum@netuset.ca', '(396) 585-5287', 'R8V 4R4'),
(164, 'Burgess, Audra D.', 'interdum.enim@Maecenasmalesuadafringilla.com', '(899) 781-6564', 'T9Y 2D6'),
(165, 'Wilson, Adara Z.', 'Maecenas.malesuada.fringilla@pellentesque.org', '(584) 813-7106', 'F01 2FX'),
(166, 'Camacho, Declan D.', 'sed.consequat@nulla.org', '(877) 622-4716', '71618'),
(167, 'Burnett, Ross Z.', 'mus@risusMorbimetus.com', '(172) 219-9875', 'A9E 7Z1'),
(168, 'Buchanan, Jakeem T.', 'dapibus.gravida@auctorvelit.ca', '(608) 148-7708', '74594'),
(169, 'Shannon, Keelie P.', 'porta@metusAeneansed.ca', '(528) 197-6956', '4143UK'),
(170, 'Cochran, Ava Y.', 'sit@iaculislacus.edu', '(669) 363-5434', 'K8T 8H1'),
(171, 'Pitts, Whoopi M.', 'sem.ut.cursus@gravidaAliquam.edu', '(655) 472-0656', 'E4O 4M9'),
(172, 'Copeland, Dahlia U.', 'ligula.Aliquam@mollisDuissit.ca', '(534) 440-9046', 'H72 3VJ'),
(173, 'Green, Oliver T.', 'eros@turpisNullaaliquet.edu', '(577) 762-1065', 'P5 2UB'),
(174, 'Lindsey, Jorden G.', 'ac.risus.Morbi@sagittisplacerat.org', '(470) 410-8886', 'T6U 3S3'),
(175, 'Duran, Thane O.', 'condimentum.eget.volutpat@eu.org', '(852) 436-1392', '13464'),
(176, 'Franco, Cruz G.', 'convallis.dolor@ametfaucibus.com', '(216) 331-1935', '66990'),
(177, 'Blackburn, Shannon I.', 'dolor.Nulla@idmagnaet.edu', '(110) 753-9791', 'H1O 8J5'),
(178, 'Wilson, Joshua N.', 'lacus.Ut@mattissemper.com', '(721) 332-3499', '67079'),
(179, 'Rush, Erica M.', 'blandit@vel.edu', '(601) 955-6769', '35823'),
(180, 'Sykes, Mollie C.', 'at.pretium.aliquet@eget.com', '(515) 677-1881', '8107GY'),
(181, 'Rojas, August U.', 'vulputate.ullamcorper@fermentumfermentum.edu', '(282) 228-2840', 'VM7 1WO'),
(182, 'Turner, Ezra H.', 'scelerisque.neque@Nullamlobortis.org', '(741) 962-7930', 'WF64 8NX'),
(183, 'Oneill, Kirestin U.', 'Lorem@scelerisquenequeNullam.org', '(579) 244-2305', 'Y2W 6B0'),
(184, 'Larson, Emery X.', 'Donec.felis.orci@dolorFusce.edu', '(559) 904-6061', '54475'),
(185, 'Tanner, Holly L.', 'sem@diamDuis.com', '(419) 861-3103', 'A21 1PB'),
(186, 'Brooks, Odette O.', 'quam.Curabitur@ipsumDonecsollicitudin.edu', '(926) 370-4680', '1863KQ'),
(187, 'Luna, Lareina U.', 'augue@orcitincidunt.edu', '(991) 300-5633', '95888'),
(188, 'Peck, Yoko L.', 'Proin.eget@ornare.org', '(812) 434-3356', 'D0A 4UU'),
(189, 'Goff, Ivory Q.', 'cursus@ametconsectetuer.org', '(916) 875-9093', 'S1W 2T0'),
(190, 'Richmond, Cora L.', 'Nam@Aliquamrutrumlorem.edu', '(257) 217-2860', 'C2Y 5NR'),
(191, 'Gross, Merritt V.', 'erat.Vivamus@odio.ca', '(177) 499-9710', '8042RN'),
(192, 'Morrow, Julie C.', 'penatibus@placeratvelitQuisque.edu', '(271) 452-1360', 'U36 2TM'),
(193, 'Case, Graiden S.', 'tempus@lobortis.ca', '(305) 617-3309', 'H2G 6S0'),
(194, 'Foley, Tucker H.', 'Etiam.laoreet@eulacus.org', '(747) 429-4765', 'X6Z 5T2'),
(195, 'Yates, Marny V.', 'Etiam.vestibulum@iaculisquispede.com', '(449) 296-6609', 'RH0 1HA'),
(196, 'Duke, Patrick M.', 'Sed.eu@purus.com', '(551) 285-5874', '1528CY'),
(197, 'Conley, Blythe D.', 'molestie.in@etmagnisdis.org', '(418) 853-3642', '08452'),
(198, 'Cash, Maite O.', 'risus.quis@hendreritDonec.com', '(696) 563-8717', 'E99 3EX'),
(199, 'Bauer, Jacob K.', 'ipsum@congue.ca', '(543) 180-0556', '4017PI'),
(200, 'Logan, Oscar S.', 'convallis.ante.lectus@quis.ca', '(228) 413-7536', '2000LL');
Explanation / Answer
Get me everyone's names and emails
select fullname, email from employees
Select everyone whose last name begins with a ‘Z’
select * from employees where fullname like '% Z%'
Select everyone who has an academic email (.edu)
select * from employees where email like '%.edu'
Get me all employees with a 134 area code.
select * from employees where phone like '(134)%'
All American Employees have zip codes that are 5 digits long. Get me all non-american employees
select * from employees where length(zip)!=5
If there is anything that you do not understand, do mention it in the comments section.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.