Answer the following questions using the SQL (Structured Query Languages): 

a. write  query in SQL to create Employees table using Table-1. 

b. write  query in SQL to find the highest salary employees

c. write  query in SQL to find the highest salary for female employee .

d. write  query in SQL to display the branch_id, number of employees and maximum salary of each branch.

 

Transcribed Image Text:

employeeID first_name last_name birthday gender salary branch_id 100 brahim Kaya 1967-11-17 M 250000 1 101 Dilek Bilir 1961-05-11 F 110000 1 102 Sinan Ege 1964-03-15 M 75000 2 103 Ebru Yelkenci 1971-06-25 F 63000 2 104 Serpil Fiek 1980-02-05 F 55000 2 105 Galileo Galilei 1958-02-19 M 69000 2 106 Murat Bilgin 1969-09-05 M 78000 3 107 Ali Ak 1973-07-22 M 65000 3 108 Kemal Turan 1978-10-01 M 71000 3 employeeID first_name last_name birthday gender salary branch_id 100 brahim Kaya 1967-11-17 M 250000 1 101 Dilek Bilir 1961-05-11 F 110000 1 102 Sinan Ege 1964-03-15 M 75000 2 103 Ebru Yelkenci 1971-06-25 F 63000 2 104 Serpil Fiek 1980-02-05 F 55000 2 105 Galileo Galilei 1958-02-19 M 69000 2 106 Murat Bilgin 1969-09-05 M 78000 3 107 Ali Ak 1973-07-22 M 65000 3 108 Kemal Turan 1978-10-01 M 71000 3