AdventureWorks Database: Find all rows outside a specified range of rate
SQL Query - AdventureWorks: Exercise-143 with Solution
143. From the following tables write a query in SQL to find all rows outside a specified range of rate between 27 and 30. Sort the result in ascending order on rate.
Sample table: HumanResources.vEmployee
businessentityid|title|firstname |middlename |lastname |suffix|jobtitle |phonenumber |phonenumbertype|emailaddress |emailpromotion|addressline1 |addressline2|city |stateprovincename|postalcode|countryregionname|additionalcontactinfo|
----------------+-----+-----------+----------------+-----------------+------+----------------------------------------+-------------------+---------------+--------------------------------+--------------+--------------------------+------------+-------------+-----------------+----------+-----------------+---------------------+
1| |Ken |J |Sánchez | |Chief Executive Officer |697-555-0142 |Cell |[email protected] | 0|4350 Minute Dr. | |Newport Hills|Washington |98006 |United States | |
2| |Terri |Lee |Duffy | |Vice President of Engineering |819-555-0175 |Work |[email protected] | 1|7559 Worth Ct. | |Renton |Washington |98055 |United States | |
3| |Roberto | |Tamburello | |Engineering Manager |212-555-0187 |Cell |[email protected] | 0|2137 Birchwood Dr | |Redmond |Washington |98052 |United States | |
4| |Rob | |Walters | |Senior Tool Designer |612-555-0100 |Cell |[email protected] | 0|5678 Lakeview Blvd. | |Minneapolis |Minnesota |55402 |United States | |
5|Ms. |Gail |A |Erickson | |Design Engineer |849-555-0139 |Cell |[email protected] | 0|9435 Breck Court | |Bellevue |Washington |98004 |United States | |
6|Mr. |Jossef |H |Goldberg | |Design Engineer |122-555-0189 |Work |[email protected] | 0|5670 Bel Air Dr. | |Renton |Washington |98055 |United States | |
7| |Dylan |A |Miller | |Research and Development Manager |181-555-0156 |Work |[email protected] | 2|7048 Laurel | |Kenmore |Washington |98028 |United States | |
8| |Diane |L |Margheim | |Research and Development Engineer |815-555-0138 |Cell |[email protected] | 0|475 Santa Maria | |Everett |Washington |98201 |United States | |
9| |Gigi |N |Matthew | |Research and Development Engineer |185-555-0186 |Cell |[email protected] | 0|7808 Brown St. | |Bellevue |Washington |98004 |United States | |
10| |Michael | |Raheem | |Research and Development Manager |330-555-2568 |Work |[email protected] | 2|1234 Seaside Way | |San Francisco|California |94109 |United States | |
11| |Ovidiu |V |Cracium | |Senior Tool Designer |719-555-0181 |Cell |[email protected] | 0|5458 Gladstone Drive | |Kenmore |Washington |98028 |United States | |
12| |Thierry |B |D'Hers | |Tool Designer |168-555-0183 |Work |[email protected] | 2|1970 Napa Ct. | |Bothell |Washington |98011 |United States | |
13|Ms. |Janice |M |Galvin | |Tool Designer |473-555-0117 |Work |[email protected] | 2|3397 Rancho View Drive | |Redmond |Washington |98052 |United States | |
14| |Michael |I |Sullivan | |Senior Design Engineer |465-555-0156 |Cell |[email protected] | 2|6510 Hacienda Drive | |Renton |Washington |98055 |United States | |
15| |Sharon |B |Salavaria | |Design Engineer |970-555-0138 |Cell |[email protected] | 2|7165 Brock Lane | |Renton |Washington |98055 |United States | |
16| |David |M |Bradley | |Marketing Manager |913-555-0172 |Work |[email protected] | 1|3768 Door Way | |Redmond |Washington |98052 |United States | |
17| |Kevin |F |Brown | |Marketing Assistant |150-555-0189 |Cell |[email protected] | 2|7883 Missing Canyon Court | |Everett |Washington |98201 |United States | |
18| |John |L |Wood | |Marketing Specialist |486-555-0150 |Work |[email protected] | 2|9906 Oak Grove Road | |Redmond |Washington |98052 |United States | |
19| |Mary |A |Dempsey | |Marketing Assistant |124-555-0114 |Cell |[email protected] | 1|6307 Greenbelt Way | |Bellevue |Washington |98004 |United States | |
20| |Wanida |M |Benshoof | |Marketing Assistant |708-555-0141 |Work |[email protected] | 2|6951 Harmony Way | |Sammamish |Washington |98074 |United States | |
21| |Terry |J |Eminhizer | |Marketing Specialist |138-555-0118 |Cell |[email protected] | 2|8668 Via Neruda | |Bellevue |Washington |98004 |United States | |
22| |Sariya |E |Harnpadoungsataya| |Marketing Specialist |399-555-0176 |Work |[email protected] | 0|1185 Dallas Drive | |Everett |Washington |98201 |United States | |
23| |Mary |E |Gibson | |Marketing Specialist |531-555-0183 |Work |[email protected] | 0|3928 San Francisco | |Everett |Washington |98201 |United States | |
24|Ms. |Jill |A |Williams | |Marketing Specialist |510-555-0121 |Work |[email protected] | 0|3238 Laguna Circle | |Everett |Washington |98201 |United States | |
25| |James |R |Hamilton | |Vice President of Production |870-555-0122 |Work |[email protected] | 0|9652 Los Angeles | |Monroe |Washington |98272 |United States | |
26| |Peter |J |Krebs | |Production Control Manager |913-555-0196 |Work |[email protected] | 0|3670 All Ways Drive | |Bellevue |Washington |98004 |United States | |
27| |Jo |A |Brown | |Production Supervisor - WC60 |632-555-0129 |Cell |[email protected] | 0|9693 Mellowood Street | |Duvall |Washington |98019 |United States | |
28| |Guy |R |Gilbert | |Production Technician - WC60 |320-555-0195 |Work |[email protected] | 0|7726 Driftwood Drive | |Monroe |Washington |98272 |United States | |
29| |Mark |K |McArthur | |Production Technician - WC60 |417-555-0154 |Work |[email protected] | 1|9863 Ridge Place | |Redmond |Washington |98052 |United States | |
30| |Britta |L |Simon | |Production Technician - WC60 |955-555-0169 |Cell |[email protected] | 0|2046 Las Palmas | |Edmonds |Washington |98020 |United States | |
31| |Margie |W |Shoop | |Production Technician - WC60 |818-555-0128 |Cell |[email protected] | 2|2080 Sycamore Drive | |Edmonds |Washington |98020 |United States | |
32| |Rebecca |A |Laszlo | |Production Technician - WC60 |314-555-0113 |Cell |[email protected] | 1|3197 Thornhill Place | |Bellevue |Washington |98004 |United States | |
33| |Annik |O |Stahl | |Production Technician - WC60 |499-555-0125 |Work |[email protected] | 0|7842 Ygnacio Valley Road | |Seattle |Washington |98104 |United States | |
34| |Suchitra |O |Mohan | |Production Technician - WC60 |753-555-0129 |Cell |[email protected] | 2|5678 Clear Court | |Bellevue |Washington |98004 |United States | |
35| |Brandon |G |Heidepriem | |Production Technician - WC60 |429-555-0137 |Cell |[email protected] | 1|8000 Crane Court | |Redmond |Washington |98052 |United States | |
36| |Jose |R |Lugo | |Production Technician - WC60 |587-555-0115 |Cell |[email protected] | 2|5125 Cotton Ct. | |Seattle |Washington |98104 |United States | |
37| |Chris |O |Okelberry | |Production Technician - WC60 |315-555-0144 |Cell |[email protected] | 0|8467 Clifford Court | |Redmond |Washington |98052 |United States | |
38| |Kim |B |Abercrombie | |Production Technician - WC60 |208-555-0114 |Cell |[email protected] | 2|9752 Jeanne Circle | |Carnation |Washington |98014 |United States | |
39| |Ed |R |Dudenhoefer | |Production Technician - WC60 |919-555-0140 |Work |[email protected] | 0|4598 Manila Avenue | |Seattle |Washington |98104 |United States | |
40| |JoLynn |M |Dobney | |Production Supervisor - WC60 |903-555-0145 |Work |[email protected] | 1|7126 Ending Ct. | |Seattle |Washington |98104 |United States | |
41| |Bryan | |Baker | |Production Technician - WC60 |712-555-0113 |Cell |[email protected] | 0|2275 Valley Blvd. | |Monroe |Washington |98272 |United States | |
42| |James |D |Kramer | |Production Technician - WC60 |119-555-0117 |Cell |[email protected] | 2|4734 Sycamore Court | |Monroe |Washington |98272 |United States | |
43| |Nancy |A |Anderson | |Production Technician - WC60 |970-555-0118 |Cell |[email protected] | 1|7820 Bird Drive | |Sammamish |Washington |98074 |United States | |
44| |Simon |D |Rapier | |Production Technician - WC60 |963-555-0134 |Work |[email protected] | 0|3421 Bouncing Road | |Duvall |Washington |98019 |United States | |
45| |Thomas |R |Michaels | |Production Technician - WC60 |278-555-0118 |Cell |[email protected] | 1|7338 Green St. | |Edmonds |Washington |98020 |United States | |
46| |Eugene |O |Kogan | |Production Technician - WC60 |173-555-0179 |Cell |[email protected] | 0|991 Vista Verde | |Duvall |Washington |98019 |United States | |
47| |Andrew |R |Hill | |Production Supervisor - WC10 |908-555-0159 |Cell |[email protected] | 1|6629 Polson Circle | |Everett |Washington |98201 |United States | |
48| |Ruth |Ann |Ellerbrock | |Production Technician - WC10 |145-555-0130 |Cell |[email protected] | 0|2176 Apollo Way | |Everett |Washington |98201 |United States | |
49| |Barry |K |Johnson | |Production Technician - WC10 |206-555-0180 |Work |[email protected] | 0|3114 Notre Dame Ave. | |Snohomish |Washington |98296 |United States | |
50| |Sidney |M |Higa | |Production Technician - WC10 |424-555-0189 |Work |[email protected] | 0|9277 Country View Lane | |Edmonds |Washington |98020 |United States | |
51| |Jeffrey |L |Ford | |Production Technician - WC10 |984-555-0185 |Work |[email protected] | 0|5734 Ashford Court | |Monroe |Washington |98272 |United States | |
52| |Doris |M |Hartwig | |Production Technician - WC10 |328-555-0150 |Cell |[email protected] | 0|5553 Cash Avenue | |Kenmore |Washington |98028 |United States | |
53| |Diane |R |Glimp | |Production Technician - WC10 |202-555-0151 |Cell |[email protected] | 2|9006 Woodside Way | |Redmond |Washington |98052 |United States | |
54| |Bonnie |N |Kearney | |Production Technician - WC10 |264-555-0150 |Work |[email protected] | 0|4852 Chaparral Court | |Snohomish |Washington |98296 |United States | |
55| |Taylor |R |Maxwell | |Production Supervisor - WC50 |508-555-0165 |Work |[email protected] | 0|504 O St. | |Edmonds |Washington |98020 |United States | |
56| |Denise |H |Smith | |Production Technician - WC50 |869-555-0119 |Cell |[email protected] | 0|5669 Ironwood Way | |Kenmore |Washington |98028 |United States | |
57| |Frank |T |Miller | |Production Technician - WC50 |167-555-0139 |Work |[email protected] | 1|591 Merriewood Drive | |Snohomish |Washington |98296 |United States | |
58| |Kendall |C |Keil | |Production Technician - WC50 |138-555-0128 |Work |[email protected] | 2|7439 Laguna Niguel | |Seattle |Washington |98104 |United States | |
59| |Bob |N |Hohman | |Production Technician - WC50 |611-555-0116 |Work |[email protected] | 0|6387 Scenic Avenue | |Bothell |Washington |98011 |United States | |
60| |Pete |C |Male | |Production Technician - WC50 |768-555-0123 |Cell |[email protected] | 2|5375 Clearland Circle | |Seattle |Washington |98104 |United States | |
61| |Diane |H |Tibbott | |Production Technician - WC50 |361-555-0180 |Work |[email protected] | 0|8192 Seagull Court | |Kenmore |Washington |98028 |United States | |
62| |John |T |Campbell | |Production Supervisor - WC60 |435-555-0113 |Work |[email protected] | 1|2639 Anchor Court | |Seattle |Washington |98104 |United States | |
63| |Maciej |W |Dusza | |Production Technician - WC60 |237-555-0128 |Cell |[email protected] | 0|3026 Anchor Drive | |Edmonds |Washington |98020 |United States | |
64| |Michael |J |Zwilling | |Production Technician - WC60 |582-555-0148 |Cell |[email protected] | 1|7511 Cooper Dr. | |Edmonds |Washington |98020 |United States | |
65| |Randy |T |Reeves | |Production Technician - WC60 |961-555-0122 |Cell |[email protected] | 0|3632 Bank Way | |Edmonds |Washington |98020 |United States | |
66| |Karan |R |Khanna | |Production Technician - WC60 |447-555-0186 |Work |[email protected] | 1|1102 Ravenwood | |Seattle |Washington |98104 |United States | |
67| |Jay |G |Adams | |Production Technician - WC60 |407-555-0165 |Work |[email protected] | 0|896 Southdale | |Monroe |Washington |98272 |United States | |
68| |Charles |B |Fitzgerald | |Production Technician - WC60 |931-555-0118 |Work |[email protected] | 2|5263 Etcheverry Dr | |Sammamish |Washington |98074 |United States | |
69| |Steve |F |Masters | |Production Technician - WC60 |712-555-0170 |Work |[email protected] | 1|1398 Yorba Linda | |Seattle |Washington |98104 |United States | |
70| |David |J |Ortiz | |Production Technician - WC60 |712-555-0119 |Work |[email protected] | 0|931 Corte De Luna | |Seattle |Washington |98104 |United States | |
71| |Michael |Sean |Ray | |Production Supervisor - WC30 |156-555-0199 |Cell |[email protected] | 2|6498 Mining Rd. | |Seattle |Washington |98104 |United States | |
72| |Steven |T |Selikoff | |Production Technician - WC30 |925-555-0114 |Work |[email protected] | 2|181 Gaining Drive | |Everett |Washington |98201 |United States | |
73| |Carole |M |Poland | |Production Technician - WC30 |688-555-0192 |Cell |[email protected] | 2|8411 Mt. Orange Place | |Edmonds |Washington |98020 |United States | |
74| |Bjorn |M |Rettig | |Production Technician - WC30 |199-555-0117 |Work |[email protected] | 1|5802 Ampersand Drive | |Seattle |Washington |98104 |United States | |
75| |Michiko |F |Osada | |Production Technician - WC30 |984-555-0148 |Work |[email protected] | 0|1962 Ferndale Lane | |Sammamish |Washington |98074 |United States | |
76| |Carol |M |Philips | |Production Technician - WC30 |609-555-0153 |Cell |[email protected] | 2|6872 Thornwood Dr. | |Bothell |Washington |98011 |United States | |
77| |Merav |A |Netz | |Production Technician - WC30 |224-555-0187 |Work |[email protected] | 0|5666 Hazelnut Lane | |Seattle |Washington |98104 |United States | |
78| |Reuben |H |D'sa | |Production Supervisor - WC40 |191-555-0112 |Work |[email protected] | 2|1064 Slow Creek Road | |Seattle |Washington |98104 |United States | |
79| |Eric |L |Brown | |Production Technician - WC40 |680-555-0118 |Cell |[email protected] | 0|5086 Nottingham Place | |Duvall |Washington |98019 |United States | |
80| |Sandeep |P |Kaliyath | |Production Technician - WC40 |166-555-0156 |Work |[email protected] | 2|4310 Kenston Dr. | |Sammamish |Washington |98074 |United States | |
81| |Mihail |U |Frintu | |Production Technician - WC40 |733-555-0128 |Work |[email protected] | 0|2466 Clearland Circle | |Edmonds |Washington |98020 |United States | |
82| |Jack |T |Creasey | |Production Technician - WC40 |521-555-0113 |Cell |[email protected] | 0|874 Olivera Road | |Seattle |Washington |98104 |United States | |
83| |Patrick |M |Cook | |Production Technician - WC40 |425-555-0117 |Cell |[email protected] | 0|9537 Ridgewood Drive | |Seattle |Washington |98104 |United States | |
84| |Frank |R |Martinez | |Production Technician - WC40 |203-555-0196 |Work |[email protected] | 1|5724 Victory Lane | |Snohomish |Washington |98296 |United States | |
85| |Brian |Richard |Goldstein | |Production Technician - WC40 |730-555-0117 |Cell |[email protected] | 0|8157 W. Book | |Bothell |Washington |98011 |United States | |
86| |Ryan |L |Cornelsen | |Production Technician - WC40 |208-555-0114 |Work |[email protected] | 2|177 11th Ave | |Sammamish |Washington |98074 |United States | |
87| |Cristian |K |Petculescu | |Production Supervisor - WC10 |434-555-0133 |Cell |[email protected] | 1|7166 Brock Lane | |Seattle |Washington |98104 |United States | |
88| |Betsy |A |Stadick | |Production Technician - WC10 |405-555-0171 |Cell |[email protected] | 0|5672 Hale Dr. | |Bothell |Washington |98011 |United States | |
89| |Patrick |C |Wedge | |Production Technician - WC10 |413-555-0124 |Cell |[email protected] | 0|3067 Maya | |Bellevue |Washington |98004 |United States | |
90| |Danielle |C |Tiedt | |Production Technician - WC10 |500-555-0172 |Cell |[email protected] | 1|5203 Virginia Lane | |Kenmore |Washington |98028 |United States | |
91| |Kimberly |B |Zimmerman | |Production Technician - WC10 |123-555-0167 |Work |[email protected] | 0|8656 Lakespring Place | |Seattle |Washington |98104 |United States | |
92| |Tom |M |Vande Velde | |Production Technician - WC10 |295-555-0161 |Work |[email protected] | 0|5242 Marvelle Ln. | |Everett |Washington |98201 |United States | |
93| |Kok-Ho |T |Loh | |Production Supervisor - WC50 |999-555-0155 |Work |[email protected] | 2|3708 Montana | |Bellevue |Washington |98004 |United States | |
94| |Russell | |Hunter | |Production Technician - WC50 |786-555-0144 |Work |[email protected] | 1|7616 Honey Court | |Seattle |Washington |98104 |United States | |
95| |Jim |H |Scardelis | |Production Technician - WC50 |679-555-0113 |Work |[email protected] | 2|172 Turning Dr. | |Edmonds |Washington |98020 |United States | |
96| |Elizabeth |I |Keyser | |Production Technician - WC50 |318-555-0137 |Cell |[email protected] | 0|350 Pastel Drive | |Kent |Washington |98031 |United States | |
97| |Mandar |H |Samant | |Production Technician - WC50 |140-555-0132 |Work |[email protected] | 0|2598 La Vista Circle | |Duvall |Washington |98019 |United States | |
98| |Sameer |A |Tejani | |Production Technician - WC50 |990-555-0172 |Cell |[email protected] | 0|5379 Treasure Island Way |# 14 |Duvall |Washington |98019 |United States | |
99| |Nuan | |Yu | |Production Technician - WC50 |913-555-0184 |Cell |[email protected] | 0|3454 Bel Air Drive | |Bellevue |Washington |98004 |United States | |
100| |Lolan |B |Song | |Production Technician - WC50 |582-555-0178 |Cell |[email protected] | 1|8152 Claudia Dr. | |Edmonds |Washington |98020 |United States | |
101| |Houman |N |Pournasseh | |Production Technician - WC50 |180-555-0136 |Cell |[email protected] | 2|9882 Clay Rde | |Redmond |Washington |98052 |United States | |
102| |Zheng |W |Mu | |Production Supervisor - WC10 |113-555-0173 |Cell |[email protected] | 0|6578 Woodhaven Ln. | |Seattle |Washington |98104 |United States | |
103| |Ebru |N |Ersan | |Production Technician - WC10 |202-555-0187 |Cell |[email protected] | 2|8316 La Salle St. | |Sammamish |Washington |98074 |United States | |
104| |Mary |R |Baker | |Production Technician - WC10 |283-555-0185 |Work |[email protected] | 2|2354 Frame Ln. | |Seattle |Washington |98104 |United States | |
105| |Kevin |M |Homer | |Production Technician - WC10 |555-555-0113 |Work |[email protected] | 0|6058 Hill Street |# 4 |Bellevue |Washington |98004 |United States | |
106| |John |T |Kane | |Production Technician - WC10 |254-555-0114 |Work |[email protected] | 1|8209 Green View Court | |Duvall |Washington |98019 |United States | |
107| |Christopher|E |Hill | |Production Technician - WC10 |153-555-0166 |Cell |[email protected]| 0|1902 Santa Cruz | |Bothell |Washington |98011 |United States | |
108| |Jinghao |K |Liu | |Production Supervisor - WC50 |794-555-0159 |Cell |[email protected] | 0|9666 Northridge Ct. | |Carnation |Washington |98014 |United States | |
109| |Alice |O |Ciccu | |Production Technician - WC50 |333-555-0173 |Cell |[email protected] | 1|3280 Pheasant Circle | |Snohomish |Washington |98296 |United States | |
110| |Jun |T |Cao | |Production Technician - WC50 |299-555-0113 |Work |[email protected] | 0|4909 Poco Lane | |Redmond |Washington |98052 |United States | |
111| |Suroor |R |Fatima | |Production Technician - WC50 |932-555-0161 |Work |[email protected] | 0|3281 Hillview Dr. | |Edmonds |Washington |98020 |United States | |
112| |John |P |Evans | |Production Technician - WC50 |172-555-0130 |Cell |[email protected] | 1|136 Balboa Court | |Seattle |Washington |98104 |United States | |
113| |Linda |K |Moschell | |Production Technician - WC50 |612-555-0171 |Cell |[email protected] | 1|3284 S. Blank Avenue | |Bellevue |Washington |98004 |United States | |
114| |Mindaugas |J |Krapauskas | |Production Technician - WC50 |637-555-0120 |Work |[email protected] | 1|9825 Coralie Drive | |Edmonds |Washington |98020 |United States | |
115| |Angela |W |Barbariol | |Production Technician - WC50 |150-555-0194 |Cell |[email protected] | 2|2687 Ridge Road | |Edmonds |Washington |98020 |United States | |
116| |Michael |W |Patten | |Production Technician - WC50 |441-555-0195 |Work |[email protected] | 0|2038 Encino Drive | |Edmonds |Washington |98020 |United States | |
117| |Chad |W |Niswonger | |Production Technician - WC50 |559-555-0175 |Work |[email protected] | 1|5747 Shirley Drive | |Bothell |Washington |98011 |United States | |
118| |Don |L |Hall | |Production Technician - WC50 |100-555-0174 |Work |[email protected] | 0|1411 Ranch Drive | |Carnation |Washington |98014 |United States | |
119| |Michael |T |Entin | |Production Technician - WC50 |817-555-0186 |Work |[email protected] | 1|2482 Buckingham Dr. | |Redmond |Washington |98052 |United States | |
120| |Kitti |H |Lertpiriyasuwat | |Production Technician - WC50 |785-555-0132 |Work |[email protected] | 0|5376 Catanzaro Way | |Seattle |Washington |98104 |United States | |
121| |Pilar |G |Ackerman | |Shipping and Receiving Supervisor |577-555-0185 |Work |[email protected] | 0|5407 Cougar Way | |Seattle |Washington |98104 |United States | |
122| |Susan |W |Eaton | |Stocker |943-555-0196 |Work |[email protected] | 2|2736 Scramble Rd | |Renton |Washington |98055 |United States | |
123| |Vamsi |N |Kuppa | |Shipping and Receiving Clerk |937-555-0137 |Work |[email protected] | 0|9833 Mt. Dias Blv. | |Bothell |Washington |98011 |United States | |
124| |Kim |T |Ralls | |Stocker |309-555-0129 |Work |[email protected] | 2|1226 Shoe St. | |Bothell |Washington |98011 |United States | |
125| |Matthias |T |Berndt | |Shipping and Receiving Clerk |139-555-0120 |Cell |[email protected] | 0|4312 Cambridge Drive | |Renton |Washington |98055 |United States | |
126| |Jimmy |T |Bischoff | |Stocker |927-555-0168 |Cell |[email protected] | 0|2176 Brown Street | |Renton |Washington |98055 |United States | |
127| |David |P |Hamilton | |Production Supervisor - WC40 |986-555-0177 |Cell |[email protected] | 1|4095 Cooper Dr. | |Kenmore |Washington |98028 |United States | |
128| |Paul |B |Komosinski | |Production Technician - WC40 |147-555-0160 |Work |[email protected] | 2|7270 Pepper Way | |Bellevue |Washington |98004 |United States | |
129| |Gary |W |Yukish | |Production Technician - WC40 |901-555-0125 |Cell |[email protected] | 0|6057 Hill Street | |Edmonds |Washington |98020 |United States | |
130| |Rob |T |Caron | |Production Technician - WC40 |238-555-0116 |Work |[email protected] | 0|5030 Blue Ridge Dr. | |Monroe |Washington |98272 |United States | |
131| |Baris |F |Cetinok | |Production Technician - WC40 |164-555-0114 |Work |[email protected] | 2|426 San Rafael | |Seattle |Washington |98104 |United States | |
132| |Nicole |B |Holliday | |Production Technician - WC40 |508-555-0129 |Cell |[email protected] | 0|3243 Buckingham Dr. |# 207 |Seattle |Washington |98104 |United States | |
133| |Michael |L |Rothkugel | |Production Technician - WC40 |454-555-0119 |Work |[email protected] | 2|207 Berry Court | |Edmonds |Washington |98020 |United States | |
134| |Eric | |Gubbels | |Production Supervisor - WC20 |260-555-0119 |Cell |[email protected] | 2|371 Apple Dr. | |Edmonds |Washington |98020 |United States | |
135| |Ivo |William |Salmre | |Production Technician - WC20 |115-555-0179 |Work |[email protected] | 0|3841 Silver Oaks Place | |Monroe |Washington |98272 |United States | |
136| |Sylvester |A |Valdez | |Production Technician - WC20 |492-555-0174 |Cell |[email protected] | 0|7902 Grammercy Lane |Unit A |Bellevue |Washington |98004 |United States | |
137| |Anibal |T |Sousa | |Production Technician - WC20 |106-555-0120 |Work |[email protected] | 0|6891 Ham Drive | |Redmond |Washington |98052 |United States | |
138| |Samantha |H |Smith | |Production Technician - WC20 |587-555-0114 |Cell |[email protected] | 0|1648 Eastgate Lane | |Bellevue |Washington |98004 |United States | |
139|Mr. |Hung-Fu |T |Ting | |Production Technician - WC20 |497-555-0181 |Cell |[email protected] | 0|7086 O St. | |Sammamish |Washington |98074 |United States | |
140| |Prasanna |E |Samarawickrama | |Production Technician - WC20 |129-555-0199 |Cell |[email protected] | 1|9322 Driving Drive | |Redmond |Washington |98052 |United States | |
141| |Min |G |Su | |Production Technician - WC20 |590-555-0152 |Work |[email protected] | 0|7396 Stratton Circle | |Bellevue |Washington |98004 |United States | |
142| |Olinda |C |Turner | |Production Technician - WC20 |306-555-0186 |Cell |[email protected] | 0|7221 Peachwillow Street | |Bellevue |Washington |98004 |United States | |
143| |Krishna | |Sunkammurali | |Production Technician - WC20 |491-555-0183 |Cell |[email protected] | 2|6870 D Bel Air Drive | |Edmonds |Washington |98020 |United States | |
144| |Paul |R |Singh | |Production Technician - WC20 |727-555-0112 |Cell |[email protected] | 2|1343 Prospect St | |Bellevue |Washington |98004 |United States | |
145| |Cynthia |S |Randall | |Production Supervisor - WC30 |352-555-0138 |Cell |[email protected] | 0|463 H Stagecoach Rd. | |Kenmore |Washington |98028 |United States | |
146| |Jian Shuo | |Wang | |Production Technician - WC30 |952-555-0178 |Cell |[email protected] | 0|8310 Ridge Circle | |Monroe |Washington |98272 |United States | |
147| |Sandra | |Reátegui Alayo | |Production Technician - WC30 |896-555-0168 |Work |[email protected] | 0|1619 Stillman Court | |Seattle |Washington |98104 |United States | |
148| |Jason |M |Watters | |Production Technician - WC30 |571-555-0179 |Work |[email protected] | 0|9320 Teakwood Dr. | |Bellevue |Washington |98004 |United States | |
149| |Andy |M |Ruth | |Production Technician - WC30 |118-555-0110 |Cell |[email protected] | 1|4777 Rockne Drive | |Bellevue |Washington |98004 |United States | |
150| |Michael |T |Vanderhyde | |Production Technician - WC30 |296-555-0121 |Cell |[email protected] | 2|2812 Mazatlan | |Edmonds |Washington |98020 |United States | |
151| |Rostislav |E |Shabalin | |Production Technician - WC30 |751-555-0134 |Cell |[email protected] | 2|3711 Rollingwood Dr | |Bellevue |Washington |98004 |United States | |
152| |Yuhong |L |Li | |Production Supervisor - WC20 |965-555-0155 |Cell |[email protected] | 1|502 Alexander Pl. | |Seattle |Washington |98104 |United States | |
153| |Hanying |P |Feng | |Production Technician - WC20 |319-555-0139 |Work |[email protected] | 0|7297 RisingView | |Redmond |Washington |98052 |United States | |
154| |Raymond |K |Sam | |Production Technician - WC20 |226-555-0197 |Work |[email protected] | 0|9784 Mt Etna Drive | |Edmonds |Washington |98020 |United States | |
155| |Fadi |K |Fakhouri | |Production Technician - WC20 |935-555-0116 |Work |[email protected] | 2|1285 Greenbrier Street | |Snohomish |Washington |98296 |United States | |
156| |Lane |M |Sacksteder | |Production Technician - WC20 |200-555-0117 |Cell |[email protected] | 1|3029 Pastime Dr |# 2 |Seattle |Washington |98104 |United States | |
157| |Linda |A |Randall | |Production Technician - WC20 |696-555-0157 |Work |[email protected] | 0|77 Birchwood | |Seattle |Washington |98104 |United States | |
158| |Shelley |N |Dyck | |Production Technician - WC20 |991-555-0184 |Cell |[email protected] | 0|3747 W. Landing Avenue | |Monroe |Washington |98272 |United States | |
159| |Terrence |W |Earls | |Production Technician - WC20 |110-555-0115 |Work |[email protected] | 1|6968 Wren Ave. | |Bellevue |Washington |98004 |United States | |
160| |Jeff |V |Hay | |Production Supervisor - WC45 |350-555-0167 |Cell |[email protected] | 1|3385 Crestview Drive | |Everett |Washington |98201 |United States | |
161| |Kirk |J |Koenigsbauer | |Production Technician - WC45 |669-555-0150 |Work |[email protected] | 1|1220 Bradford Way | |Seattle |Washington |98104 |United States | |
162| |Laura |C |Steele | |Production Technician - WC45 |777-555-0141 |Work |[email protected] | 0|1825 Corte Del Prado | |Duvall |Washington |98019 |United States | |
163| |Alex |M |Nayberg | |Production Technician - WC45 |819-555-0198 |Work |[email protected] | 1|1400 Gate Drive | |Newport Hills|Washington |98006 |United States | |
164| |Andrew |M |Cencini | |Production Technician - WC45 |207-555-0192 |Cell |[email protected] | 0|4444 Pepper Way | |Sammamish |Washington |98074 |United States | |
165| |Chris |T |Preston | |Production Technician - WC45 |200-555-0112 |Cell |[email protected] | 0|6657 Sand Pointe Lane | |Seattle |Washington |98104 |United States | |
166| |Jack |S |Richins | |Production Supervisor - WC30 |552-555-0111 |Work |[email protected] | 0|1356 Grove Way | |Monroe |Washington |98272 |United States | |
167| |David |N |Johnson | |Production Technician - WC30 |166-555-0162 |Cell |[email protected] | 0|6697 Ridge Park Drive | |Kenmore |Washington |98028 |United States | |
168| |Garrett |R |Young | |Production Technician - WC30 |609-555-0179 |Work |[email protected] | 2|2115 Passing | |Snohomish |Washington |98296 |United States | |
169| |Susan |A |Metters | |Production Technician - WC30 |639-555-0164 |Cell |[email protected] | 1|9104 Mt. Sequoia Ct. | |Sammamish |Washington |98074 |United States | |
170| |George |Z |Li | |Production Technician - WC30 |518-555-0199 |Cell |[email protected] | 0|3074 Arbor Drive | |Carnation |Washington |98014 |United States | |
171| |David |A |Yalovsky | |Production Technician - WC30 |373-555-0142 |Work |[email protected] | 1|5025 Holiday Hills | |Seattle |Washington |98104 |United States | |
172| |Marc |J |Ingle | |Production Technician - WC30 |234-555-0169 |Cell |[email protected] | 2|2473 Orchard Way | |Sammamish |Washington |98074 |United States | |
173| |Eugene |R |Zabokritski | |Production Technician - WC30 |241-555-0191 |Cell |[email protected] | 0|7939 Bayview Court | |Sammamish |Washington |98074 |United States | |
174| |Benjamin |R |Martin | |Production Technician - WC30 |533-555-0111 |Cell |[email protected] | 2|4231 Spar Court | |Snohomish |Washington |98296 |United States | |
175| |Reed |T |Koch | |Production Technician - WC30 |678-555-0110 |Work |[email protected] | 0|1275 West Street | |Redmond |Washington |98052 |United States | |
176| |David |Oliver |Lawrence | |Production Technician - WC30 |118-555-0177 |Work |[email protected] | 0|158 Walnut Ave | |Monroe |Washington |98272 |United States | |
177| |Russell |M |King | |Production Technician - WC30 |517-555-0122 |Work |[email protected] | 0|3919 Pinto Road | |Bellevue |Washington |98004 |United States | |
178| |John |N |Frum | |Production Technician - WC30 |663-555-0172 |Cell |[email protected] | 2|3665 Oak Creek Ct. | |Everett |Washington |98201 |United States | |
179| |Jan |S |Miksovsky | |Production Technician - WC30 |139-555-0131 |Work |[email protected] | 0|8624 Pepper Way | |Everett |Washington |98201 |United States | |
180| |Katie |L |McAskill-White | |Production Supervisor - WC20 |809-555-0133 |Work |[email protected] | 2|4948 West 4th St | |Seattle |Washington |98104 |United States | |
181| |Michael |T |Hines | |Production Technician - WC20 |218-555-0126 |Work |[email protected] | 0|1792 Belmont Rd. | |Monroe |Washington |98272 |United States | |
182| |Nitin |S |Mirchandani | |Production Technician - WC20 |143-555-0173 |Cell |[email protected] | 0|4096 San Remo | |Sammamish |Washington |98074 |United States | |
183| |Barbara |S |Decker | |Production Technician - WC20 |119-555-0192 |Cell |[email protected] | 0|7145 Matchstick Drive | |Sammamish |Washington |98074 |United States | |
184| |John |Y |Chen | |Production Technician - WC20 |201-555-0163 |Cell |[email protected] | 2|3977 Central Avenue | |Duvall |Washington |98019 |United States | |
185| |Stefen |A |Hesse | |Production Technician - WC20 |165-555-0113 |Cell |[email protected] | 1|8463 Vista Avenue | |Duvall |Washington |98019 |United States | |
186| |Shane |S |Kim | |Production Supervisor - WC45 |810-555-0178 |Cell |[email protected] | 2|9745 Bonita Ct. | |Bellevue |Washington |98004 |United States | |
187| |Yvonne |S |McKay | |Production Technician - WC45 |286-555-0189 |Work |[email protected] | 0|1962 Cotton Ct. | |Everett |Washington |98201 |United States | |
188| |Douglas |B |Hite | |Production Technician - WC45 |808-555-0172 |Cell |[email protected] | 1|390 Ridgewood Ct. | |Carnation |Washington |98014 |United States | |
189| |Janeth |M |Esteves | |Production Technician - WC45 |540-555-0191 |Work |[email protected] | 1|4566 La Jolla | |Monroe |Washington |98272 |United States | |
190| |Robert |J |Rounthwaite | |Production Technician - WC45 |589-555-0147 |Cell |[email protected] | 0|6843 San Simeon Dr. | |Seattle |Washington |98104 |United States | |
191| |Lionel |C |Penuchot | |Production Technician - WC45 |450-555-0152 |Cell |[email protected] | 1|7765 Sunsine Drive | |Seattle |Washington |98104 |United States | |
192| |Brenda |M |Diaz | |Production Supervisor - WC40 |142-555-0139 |Work |[email protected] | 1|1349 Steven Way | |Seattle |Washington |98104 |United States | |
193| |Alejandro |E |McGuel | |Production Technician - WC40 |668-555-0130 |Work |[email protected] | 0|7127 Los Gatos Court | |Seattle |Washington |98104 |United States | |
194| |Fred |T |Northup | |Production Technician - WC40 |818-555-0192 |Cell |[email protected] | 0|2601 Cambridge Drive | |Snohomish |Washington |98296 |United States | |
195| |Kevin |H |Liu | |Production Technician - WC40 |714-555-0138 |Work |[email protected] | 2|7594 Alexander Pl. | |Seattle |Washington |98104 |United States | |
196| |Shammi |G |Mohamed | |Production Technician - WC40 |793-555-0179 |Cell |[email protected] | 0|332 Laguna Niguel | |Bellevue |Washington |98004 |United States | |
197| |Rajesh |M |Patel | |Production Technician - WC40 |373-555-0137 |Cell |[email protected] | 1|5423 Champion Rd. | |Edmonds |Washington |98020 |United States | |
198| |Lorraine |O |Nay | |Production Technician - WC40 |845-555-0184 |Work |[email protected] | 1|2059 Clay Rd | |Edmonds |Washington |98020 |United States | |
199| |Paula |R |Nartker | |Production Technician - WC40 |476-555-0119 |Cell |[email protected] | 1|2144 San Rafael | |Seattle |Washington |98104 |United States | |
200| |Frank |T |Lee | |Production Technician - WC40 |158-555-0191 |Cell |[email protected] | 0|8290 Margaret Ct. | |Seattle |Washington |98104 |United States | |
201| |Brian |T |Lloyd | |Production Technician - WC40 |110-555-0182 |Cell |[email protected] | 0|7230 Vine Maple Street | |Snohomish |Washington |98296 |United States | |
202| |Tawana |G |Nusbaum | |Production Technician - WC40 |368-555-0113 |Work |[email protected] | 0|9964 North Ridge Drive | |Seattle |Washington |98104 |United States | |
203| |Ken |L |Myer | |Production Technician - WC40 |949-555-0174 |Work |[email protected] | 1|1362 Somerset Place | |Everett |Washington |98201 |United States | |
204| |Gabe |B |Mares | |Production Technician - WC40 |310-555-0117 |Work |[email protected] | 0|1061 Buskrik Avenue | |Edmonds |Washington |98020 |United States | |
205| |Lori |A |Kane | |Production Supervisor - WC45 |289-555-0196 |Cell |[email protected] | 0|3066 Wallace Dr. | |Redmond |Washington |98052 |United States | |
206| |Stuart |V |Munson | |Production Technician - WC45 |413-555-0136 |Cell |[email protected] | 2|6448 Castle Court | |Bellevue |Washington |98004 |United States | |
207| |Greg |F |Alderson | |Production Technician - WC45 |332-555-0150 |Work |[email protected] | 0|8684 Military East | |Bellevue |Washington |98004 |United States | |
208| |Scott |R |Gode | |Production Technician - WC45 |391-555-0138 |Cell |[email protected] | 0|7403 N. Broadway | |Seattle |Washington |98104 |United States | |
209| |Kathie |E |Flood | |Production Technician - WC45 |446-555-0118 |Work |[email protected] | 0|9241 St George Dr. | |Everett |Washington |98201 |United States | |
210| |Belinda |M |Newman | |Production Technician - WC45 |319-555-0126 |Cell |[email protected] | 2|1399 Firestone Drive | |Bothell |Washington |98011 |United States | |
211| |Hazem |E |Abolrous | |Quality Assurance Manager |869-555-0125 |Work |[email protected] | 0|5050 Mt. Wilson Way | |Kenmore |Washington |98028 |United States | |
212| |Peng |J |Wu | |Quality Assurance Supervisor |164-555-0164 |Work |[email protected] | 2|250 Race Court | |Bothell |Washington |98011 |United States | |
213| |Sootha |T |Charncherngkha | |Quality Assurance Technician |325-555-0137 |Work |[email protected] | 0|4155 Working Drive | |Kenmore |Washington |98028 |United States | |
214| |Andreas |T |Berglund | |Quality Assurance Technician |181-555-0124 |Cell |[email protected] | 0|1803 Olive Hill | |Renton |Washington |98055 |United States | |
215| |Mark |L |Harrington | |Quality Assurance Technician |147-555-0179 |Cell |[email protected] | 0|8585 Los Gatos Ct. | |Issaquah |Washington |98027 |United States | |
216| |Sean |P |Alexander | |Quality Assurance Technician |420-555-0173 |Cell |[email protected] | 2|7985 Center Street | |Renton |Washington |98055 |United States | |
217| |Zainal |T |Arifin | |Document Control Manager |204-555-0115 |Cell |[email protected] | 1|342 San Simeon | |Issaquah |Washington |98027 |United States | |
218| |Tengiz |N |Kharatishvili | |Control Specialist |910-555-0116 |Work |[email protected] | 1|3333 Madhatter Circle | |Issaquah |Washington |98027 |United States | |
219| |Sean |N |Chai | |Document Control Assistant |205-555-0132 |Cell |[email protected] | 0|9314 Icicle Way | |Issaquah |Washington |98027 |United States | |
220| |Karen |R |Berge | |Document Control Assistant |746-555-0164 |Work |[email protected] | 0|3127 El Camino Drive | |Index |Washington |98256 |United States | |
221| |Chris |K |Norred | |Control Specialist |575-555-0126 |Cell |[email protected] | 0|989 Crown Ct | |Issaquah |Washington |98027 |United States | |
222| |A. Scott | |Wright | |Master Scheduler |992-555-0194 |Cell |[email protected] | 0|9297 Kenston Dr. | |Newport Hills|Washington |98006 |United States | |
223| |Sairaj |L |Uddin | |Scheduling Assistant |500-555-0159 |Cell |[email protected] | 0|8040 Hill Ct | |Redmond |Washington |98052 |United States | |
224| |William |S |Vong | |Scheduling Assistant |148-555-0145 |Cell |[email protected] | 2|6774 Bonanza | |Bellevue |Washington |98004 |United States | |
225| |Alan |J |Brewer | |Scheduling Assistant |438-555-0172 |Work |[email protected] | 0|25 95th Ave NE | |Kenmore |Washington |98028 |United States | |
226| |Brian |P |LaMee | |Scheduling Assistant |313-555-0196 |Cell |[email protected] | 0|2294 West 39th St. | |Everett |Washington |98201 |United States | |
227| |Gary |E. |Altman |III |Facilities Manager |110-555-0112 |Cell |[email protected] | 0|2598 Breck Court | |Renton |Washington |98055 |United States | |
228| |Christian |E |Kleinerman | |Maintenance Supervisor |846-555-0157 |Cell |[email protected] | 0|8036 Summit View Dr. | |Gold Bar |Washington |98251 |United States | |
229| |Lori |K |Penor | |Janitor |295-555-0161 |Cell |[email protected] | 0|3514 Sunshine | |Index |Washington |98256 |United States | |
230| |Stuart |J |Macrae | |Janitor |539-555-0149 |Work |[email protected] | 0|2266 Greenwood Circle | |Renton |Washington |98055 |United States | |
231| |Jo |L |Berry | |Janitor |228-555-0159 |Cell |[email protected] | 0|1748 Bird Drive | |Index |Washington |98256 |United States | |
232| |Pat |H |Coleman | |Janitor |720-555-0158 |Work |[email protected] | 0|2425 Notre Dame Ave | |Gold Bar |Washington |98251 |United States | |
233| |Magnus |E |Hedlund | |Facilities Administrative Assistant |583-555-0182 |Work |[email protected] | 0|9533 Working Drive | |Renton |Washington |98055 |United States | |
234| |Laura |F |Norman | |Chief Financial Officer |615-555-0110 |Cell |[email protected] | 1|6937 E. 42nd Street | |Renton |Washington |98055 |United States | |
235| |Paula |M |Barreto de Mattos| |Human Resources Manager |523-555-0175 |Cell |[email protected] | 2|4311 Clay Rd | |Bellevue |Washington |98004 |United States | |
236| |Grant |N |Culbertson | |Human Resources Administrative Assistant|955-555-0131 |Work |[email protected] | 2|213 Stonewood Drive | |Gold Bar |Washington |98251 |United States | |
237| |Hao |O |Chen | |Human Resources Administrative Assistant|806-555-0136 |Work |[email protected] | 0|7691 Benedict Ct. |# 141 |Issaquah |Washington |98027 |United States | |
238| |Vidur |X |Luthra | |Recruiter |153-555-0186 |Work |[email protected] | 0|3030 Blackburn Ct. | |Newport Hills|Washington |98006 |United States | |
239| |Mindy |C |Martin | |Benefits Specialist |522-555-0147 |Work |[email protected] | 0|9687 Shakespeare Drive | |Newport Hills|Washington |98006 |United States | |
240| |Willis |T |Johnson | |Recruiter |778-555-0141 |Work |[email protected] | 0|5452 Corte Gilberto | |Everett |Washington |98201 |United States | |
241| |David |J |Liu | |Accounts Manager |646-555-0185 |Work |[email protected] | 0|9605 Pheasant Circle | |Gold Bar |Washington |98251 |United States | |
242| |Deborah |E |Poe | |Accounts Receivable Specialist |602-555-0194 |Cell |[email protected] | 0|7640 First Ave. | |Everett |Washington |98201 |United States | |
243| |Candy |L |Spoon | |Accounts Receivable Specialist |920-555-0177 |Cell |[email protected] | 0|310 Winter Lane | |Index |Washington |98256 |United States | |
244| |Bryan |A |Walton | |Accounts Receivable Specialist |935-555-0199 |Work |[email protected] | 0|1397 Paradise Ct. | |Newport Hills|Washington |98006 |United States | |
245| |Barbara |C |Moreland | |Accountant |822-555-0145 |Cell |[email protected] | 0|137 Mazatlan | |Seattle |Washington |98104 |United States | |
246| |Dragan |K |Tomic | |Accounts Payable Specialist |117-555-0185 |Work |[email protected] | 1|3884 Beauty Street |# 14 |Gold Bar |Washington |98251 |United States | |
247| |Janet |L |Sheperdigian | |Accounts Payable Specialist |393-555-0186 |Work |[email protected] | 0|6871 Thornwood Dr. | |Sammamish |Washington |98074 |United States | |
248| |Mike |K |Seamans | |Accountant |927-555-0150 |Work |[email protected] | 2|1245 Clay Road | |Index |Washington |98256 |United States | |
249| |Wendy |Beth |Kahn | |Finance Manager |248-555-0134 |Work |[email protected] | 2|4525 Benedict Ct. | |Sammamish |Washington |98074 |United States | |
250| |Sheela |H |Word | |Purchasing Manager |210-555-0193 |Work |[email protected] | 0|535 Greendell Pl | |Sammamish |Washington |98074 |United States | |
251| |Mikael |Q |Sandberg | |Buyer |309-555-0170 |Work |[email protected] | 2|9539 Glenside Dr | |Bothell |Washington |98011 |United States | |
252| |Arvind |B |Rao | |Buyer |848-555-0163 |Cell |[email protected] | 0|9495 Limewood Place | |Renton |Washington |98055 |United States | |
253| |Linda |P |Meisner | |Buyer |916-555-0165 |Cell |[email protected] | 0|6118 Grasswood Circle | |Bellevue |Washington |98004 |United States | |
254| |Fukiko |J |Ogisu | |Buyer |520-555-0177 |Work |[email protected] | 0|8751 Norse Drive | |Bellevue |Washington |98004 |United States | |
255| |Gordon |L |Hee | |Buyer |230-555-0144 |Cell |[email protected] | 0|108 Lakeside Court | |Bellevue |Washington |98004 |United States | |
256| |Frank |S |Pellow | |Buyer |163-555-0147 |Cell |[email protected] | 0|5980 Icicle Circle |Unit H |Renton |Washington |98055 |United States | |
257| |Eric |S |Kurjan | |Buyer |265-555-0195 |Work |[email protected] | 2|1378 String Dr | |Renton |Washington |98055 |United States | |
258| |Erin |M |Hagens | |Buyer |842-555-0158 |Work |[email protected] | 0|2947 Vine Lane | |Bellevue |Washington |98004 |United States | |
259| |Ben |T |Miller | |Buyer |151-555-0113 |Work |[email protected] | 0|101 Candy Rd. | |Redmond |Washington |98052 |United States | |
260| |Annette |L |Hill | |Purchasing Assistant |125-555-0196 |Cell |[email protected] | 1|6369 Ellis Street | |Redmond |Washington |98052 |United States | |
261| |Reinout |N |Hillmann | |Purchasing Assistant |370-555-0163 |Work |[email protected] | 2|620 Woodside Ct. | |Bellevue |Washington |98004 |United States | |
262| |David |M |Barber | |Assistant to the Chief Financial Officer|477-555-0132 |Work |[email protected] | 0|8967 Hamilton Ave. | |Newport Hills|Washington |98006 |United States | |
263| |Jean |E |Trenary | |Information Services Manager |685-555-0120 |Work |[email protected] | 2|2383 Pepper Drive | |Redmond |Washington |98052 |United States | |
264| |Stephanie |A |Conroy | |Network Manager |594-555-0110 |Work |[email protected] | 2|7435 Ricardo | |Issaquah |Washington |98027 |United States | |
265| |Ashvini |R |Sharma | |Network Administrator |656-555-0119 |Work |[email protected] | 1|6580 Poor Ridge Court | |Issaquah |Washington |98027 |United States | |
266| |Peter |I |Connelly | |Network Administrator |310-555-0133 |Work |[email protected] | 0|9530 Vine Lane | |Issaquah |Washington |98027 |United States | |
267| |Karen |A |Berg | |Application Specialist |654-555-0177 |Work |[email protected] | 0|5256 Chickpea Ct. | |Issaquah |Washington |98027 |United States | |
268| |Ramesh |V |Meyyappan | |Application Specialist |182-555-0134 |Work |[email protected] | 1|3848 East 39th Street | |Issaquah |Washington |98027 |United States | |
269| |Dan |K |Bacon |Jr. |Application Specialist |166-555-0159 |Work |[email protected] | 0|1921 Ranch Road | |Issaquah |Washington |98027 |United States | |
270| |François |P |Ajenstat | |Database Administrator |785-555-0110 |Cell |franç[email protected] | 0|1144 Paradise Ct. | |Issaquah |Washington |98027 |United States | |
271| |Dan |B |Wilson | |Database Administrator |653-555-0144 |Work |[email protected] | 0|5863 Sierra | |Bellevue |Washington |98004 |United States | |
272| |Janaina |Barreiro Gambaro|Bueno | |Application Specialist |623-555-0155 |Work |[email protected] | 0|5979 El Pueblo | |Issaquah |Washington |98027 |United States | |
273|Mr. |Brian |S |Welcker | |Vice President of Sales |716-555-0127 |Cell |[email protected] | 0|7772 Golden Meadow | |Issaquah |Washington |98027 |United States | |
274| |Stephen |Y |Jiang | |North American Sales Manager |238-555-0197 |Cell |[email protected] | 0|2427 Notre Dame Ave. | |Redmond |Washington |98052 |United States | |
275| |Michael |G |Blythe | |Sales Representative |257-555-0154 |Cell |[email protected] | 1|8154 Via Mexico | |Detroit |Michigan |48226 |United States | |
276| |Linda |C |Mitchell | |Sales Representative |883-555-0116 |Work |[email protected] | 0|2487 Riverside Drive | |Nevada |Utah |84407 |United States | |
277| |Jillian | |Carson | |Sales Representative |517-555-0117 |Work |[email protected] | 1|80 Sunview Terrace | |Duluth |Minnesota |55802 |United States | |
278| |Garrett |R |Vargas | |Sales Representative |922-555-0165 |Work |[email protected] | 0|10203 Acorn Avenue | |Calgary |Alberta |T2P 2G8 |Canada | |
279| |Tsvi |Michael |Reiter | |Sales Representative |664-555-0112 |Work |[email protected] | 1|8291 Crossbow Way | |Memphis |Tennessee |38103 |United States | |
280| |Pamela |O |Ansman-Wolfe | |Sales Representative |340-555-0193 |Cell |[email protected] | 1|636 Vine Hill Way | |Portland |Oregon |97205 |United States | |
281| |Shu |K |Ito | |Sales Representative |330-555-0120 |Cell |[email protected] | 2|5725 Glaze Drive | |San Francisco|California |94109 |United States | |
282| |José |Edvaldo |Saraiva | |Sales Representative |185-555-0169 |Work |josé[email protected] | 0|9100 Sheppard Avenue North| |Ottawa |Ontario |K4B 1T7 |Canada | |
283| |David |R |Campbell | |Sales Representative |740-555-0182 |Work |[email protected] | 0|2284 Azalea Avenue | |Bellevue |Washington |98004 |United States | |
284|Mr. |Tete |A |Mensa-Annan | |Sales Representative |615-555-0153 |Work |[email protected] | 1|3997 Via De Luna | |Cambridge |Massachusetts |02139 |United States | |
285|Mr. |Syed |E |Abbas | |Pacific Sales Manager |926-555-0182 |Work |[email protected] | 0|7484 Roundtree Drive | |Bothell |Washington |98011 |United States | |
286| |Lynn |N |Tsoflias | |Sales Representative |1 (11) 500 555-0190|Cell |[email protected] | 2|34 Waterloo Road | |Melbourne |Victoria |3000 |Australia | |
287| |Amy |E |Alberts | |European Sales Manager |775-555-0164 |Work |[email protected] | 1|5009 Orange Street | |Renton |Washington |98055 |United States | |
288| |Rachel |B |Valdez | |Sales Representative |1 (11) 500 555-0140|Cell |[email protected] | 0|Pascalstr 951 | |Berlin |Hamburg |14111 |Germany | |
289| |Jae |B |Pak | |Sales Representative |1 (11) 500 555-0145|Work |[email protected] | 0|Downshire Way | |Cambridge |England |BA5 3HX |United Kingdom | |
290| |Ranjit |R |Varkey Chudukatil| |Sales Representative |1 (11) 500 555-0117|Cell |[email protected] | 0|94, rue Descartes | |Bordeaux |Gironde |33000 |France | |
Sample table: HumanResources.EmployeePayHistory
businessentityid|ratechangedate |rate |payfrequency|modifieddate |
----------------+-----------------------+-------+------------+-----------------------+
1|2009-01-14 00:00:00.000| 125.5| 2|2014-06-30 00:00:00.000|
2|2008-01-31 00:00:00.000|63.4615| 2|2014-06-30 00:00:00.000|
3|2007-11-11 00:00:00.000|43.2692| 2|2014-06-30 00:00:00.000|
4|2007-12-05 00:00:00.000| 8.62| 2|2007-11-21 00:00:00.000|
4|2010-05-31 00:00:00.000| 23.72| 2|2010-05-16 00:00:00.000|
4|2011-12-15 00:00:00.000|29.8462| 2|2011-12-01 00:00:00.000|
5|2008-01-06 00:00:00.000|32.6923| 2|2014-06-30 00:00:00.000|
6|2008-01-24 00:00:00.000|32.6923| 2|2014-06-30 00:00:00.000|
7|2009-02-08 00:00:00.000|50.4808| 2|2014-06-30 00:00:00.000|
8|2008-12-29 00:00:00.000|40.8654| 2|2014-06-30 00:00:00.000|
-- more --
Sample Solution:
-- Selecting FirstName, LastName, and Rate columns from the vEmployee view and EmployeePayHistory table for employees whose rate falls outside the range of 27 to 30
SELECT
-- Selecting the FirstName column from the vEmployee view
e.FirstName,
-- Selecting the LastName column from the vEmployee view
e.LastName,
-- Selecting the Rate column from the EmployeePayHistory table
ep.Rate
-- Selecting data from the vEmployee view
FROM
HumanResources.vEmployee e
-- Joining the vEmployee view with the EmployeePayHistory table based on BusinessEntityID
JOIN
HumanResources.EmployeePayHistory ep
ON
e.BusinessEntityID = ep.BusinessEntityID
-- Filtering records where the Rate is not between 27 and 30
WHERE
ep.Rate NOT BETWEEN 27 AND 30
-- Ordering the result set by Rate
ORDER BY
ep.Rate;
Explanation:
- This SQL code retrieves information about employees' first names, last names, and pay rates from the vEmployee view and the EmployeePayHistory table.
- The SELECT statement specifies the columns to be included in the result set.
- The JOIN clause connects the vEmployee view with the EmployeePayHistory table based on the BusinessEntityID column.
- The WHERE clause filters records to include only those where the pay rate falls outside the range of 27 to 30.
- The ORDER BY clause sorts the result set by the pay rate in ascending order.
- The result set will contain columns for first name, last name, and pay rate for employees whose pay rate is not between 27 and 30.
Sample Output:
firstname |lastname |rate | -----------+-----------------+-------+ Marc |Ingle | 6.5| George |Li | 6.5| David |Johnson | 6.5| John |Frum | 6.5| Russell |King | 6.5| David |Lawrence | 6.5| Reed |Koch | 6.5| Benjamin |Martin | 6.75| John |Frum | 7| George |Li | 7.25| Marc |Ingle | 7.25| ...
SQL AdventureWorks Editor:
Practice Online
Contribute your code and comments through Disqus.
Previous: Find marketing Assistants with more than 41 vacation hours.
Next: Retrieve rows whose datetime values are between '20111212' and '20120105'.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://w3resource.com/sql-exercises/adventureworks/sql-adventureworks-exercise-143.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics