[solved]-Using Following Database Table Structure Name Table Employees Employees Employeeld Lastnam Q39046830

Using the following database table structure (name of the table is Employees) Employees EmployeelD LastName FirstName 39732 Abrams Performancı Gender Title Salary Location Wendy Account Rep 47500 Atlanta Good E M 56200 Chicago Good 30070 Adams Bret Senior Account 24098 Adams Senior Account 45900 Cleveland Excellent Ben M 30817 Afflord M Lance Senior Account 59100 Detroit Average Account Rep 45200 Chicago M 23303 Aikman Dino Average Good 56200 Boston Wendy 22920 Alworth Senior Account 47900 Atlanta Excellent 12797 Anderson Vicki Senior Account Valerie Account Rep Senior Account 14426 Anderson E 49900 Cleveland Good 15374 Armstrong M 53500 Chicago Excellent Ringo Senior Account 17008 Ashley Tina E 51900 Cleveland Good 12080 Bailey Robert Account Rep 39900 Detroit Excellent 12276 Barnes Jeb M Account Rep 46900 Boston Excellent 39898 Bartolini Suzie Senior Account 63000 Detroit Average Account Rep 15903 Bartolini M 44200 Phoenix Excellent Bart 26634 Battle Susan Senior Account 37000 Boston Good Account Rep 12548 Battle Good Susannah 43900 San Francisco 20900 Boston M 49662 Beamer Brian Trainee Good 38400 Miami 34162 Bell Roni Account Rep Average 32196 Bermont M William Account Rep 48200 New York Average 34500 Los Angeles M Account Rep 37611 Bianch Arthur Average Design SQL queries for the following: 1. Select first and last name of all female employees 2. Select first and last name of all male employees whose location is Chicago 3. Select all fields for employees whose salary is less than or equal to $50,000 Show transcribed image text Using the following database table structure (name of the table is Employees) Employees EmployeelD LastName FirstName 39732 Abrams Performancı Gender Title Salary Location Wendy Account Rep 47500 Atlanta Good E M 56200 Chicago Good 30070 Adams Bret Senior Account 24098 Adams Senior Account 45900 Cleveland Excellent Ben M 30817 Afflord M Lance Senior Account 59100 Detroit Average Account Rep 45200 Chicago M 23303 Aikman Dino Average Good 56200 Boston Wendy 22920 Alworth Senior Account 47900 Atlanta Excellent 12797 Anderson Vicki Senior Account Valerie Account Rep Senior Account 14426 Anderson E 49900 Cleveland Good 15374 Armstrong M 53500 Chicago Excellent Ringo Senior Account 17008 Ashley Tina E 51900 Cleveland Good 12080 Bailey Robert Account Rep 39900 Detroit Excellent 12276 Barnes Jeb M Account Rep 46900 Boston Excellent 39898 Bartolini Suzie Senior Account 63000 Detroit Average Account Rep 15903 Bartolini M 44200 Phoenix Excellent Bart 26634 Battle Susan Senior Account 37000 Boston Good Account Rep 12548 Battle Good Susannah 43900 San Francisco 20900 Boston M 49662 Beamer Brian Trainee Good 38400 Miami 34162 Bell Roni Account Rep Average 32196 Bermont M William Account Rep 48200 New York Average 34500 Los Angeles M Account Rep 37611 Bianch Arthur Average Design SQL queries for the following: 1. Select first and last name of all female employees 2. Select first and last name of all male employees whose location is Chicago 3. Select all fields for employees whose salary is less than or equal to $50,000

Expert Answer

---

Answer to Using the following database table structure (name of the table is Employees) Employees EmployeelD LastName FirstName 39… . . .