Employee ID Name Dept Salary Starting Date Country Gender
E001 Derek Hernandez Support 40322 7/4/2022 USA Male
E002 David Wilson Sales 70731 8/24/2015 UK Male
E003 Juan Patterson Finance 44120 11/23/2015 Canada Male
E004 Harry Rodriguez IT 97522 6/11/2025 USA Male
E005 Julia Glenn HR 108237 3/22/2018 Australia Female
E006 Richard Mcmillan Support 62586 11/30/2018 India Male
E007 Jordan Mcneil Sales 107376 4/16/2020 UK Male
E008 Taylor Lewis Support 89571 4/14/2020 USA Female
E009 Bryan Bradley Support 50378 11/30/2019 Canada Male
E010 Norman Hanson HR 58495 4/19/2023 USA Male
E011 Eric Shelton Finance 43230 3/8/2020 India Male
Operation
E012 Erin Lewis 86848 10/2/2020 USA Female
s
E013 Anthony Barnes HR 45776 7/2/2022 Canada Male
E014 Traci Murray Marketing 59198 3/19/2023 USA Female
Q) find which country has most number of employee working in company?
E015 Wayne Wise Finance 83229 8/12/2022 UK Male
5 Support
E016 Jose Peterson HR 49006 12/14/2023 USA Male
Q)How many employee are these of indian origin?
E017 Brenda Conway Support 58156 1/15/2022 Australia Female
3
E018 William Diaz IT 50893 9/13/2023 India Male Q) count female emolpyee from Support Deparment
E019 Scott Brown Marketing 93768 8/27/2021 USA Male
2
E020 Carl Castro HR 111552 9/22/2018 Canada Male Q)cout employee with salary between 55000 and 65000?
4
178107 Q)find count of employee in IT dept with salary >65000?
1
Que -Find total salary of indian employees of sales department
Q)find count of male employee in IT deparment with salary>65000?
Q)find the country of employee E019? 1
USA
Q)find dept of Scott Brown?
Marketing
Q)find emp id of Scott brown?
1.look up vale must be in lesf most column of selected data
2. output value/col must always be in right side of lookup value
ans.match 19 row
1 column
E019 mixed
