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.
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics