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 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

The Answer is in the image, click to view ...

Question: 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

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.

table 1.png

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Discussion - Long-Term Care Industry Discuss one of the three important historical events that formed the basis of the long-term care industry. Next, discuss three long-term care options and the...

The accompanying table can be used to make paired comparisons of the desirability of salary, deferred compensation, and pensions as a function of a = current and future employer marginal tax rates, b...

An NC winery makes 4 types (1-4) of wine measured in gallons per year. Maximize profit. Formulate the LP and solve in a solver. Production involves Labor, Tank mixing time, Warehouse Aging. Caution:...

Given the data (a) Calculate (2.8) using Newtons interpolating polynomials of order 1 through 3. Choose the sequence of the points for your estimates to attain the best possible accuracy. (b) Utilize...

A sporting goods chain places TV ads to promote golf club sales. The marketing director used past records to determine the following data, where x is the number of ads placed monthly and y is the...

Russell Simmons invested $5,000 to start Def Jam and then later sold his business to Polygram Records for $100 million. Calculate Simmonss return on investment (ROI).

Examine the wording of the questions. Could the way questions are worded cause bias because they are leading?

Heat transfer is not an intuitive process muses the Curious Cook. Does doubling the thickness of a hamburger approximately double the cooking time? What effect does the initial temperature have on...

1 . Discuss anything new and unique that can be added to theNestles management plan 2 . Management development program ( MDP ) innestle

A city ordinance stipulates that all bicycle riders must wear a helmet. Bethany decides to enjoy a cigarette during a leisurely Sunday morning bike ride. As she goes to light the smoke, the chin...

Data table More info Another company has clered to sel Spectra Systems the swich for $13.00 per unit. if Spectra Systems buys the switch from the outside supplier, the ide manufacturing facilibes...

Case Study Jean Davis is a 19-year-old woman who is experiencing difficulties in college. She moved out of the dorm because she thought other students were out to ruin her life. Her former roommate...

1. Main Entry: Within the body of post, clearly identify each segment of the required response in order to facilitate discussion development. a. Early impressions: Another UMGC Psychology student...

A Rhodamine dye solution was discharged in a river section at a constant rate. Estimate the discharge if the dye is found to reach an equilibrium of 5 parts per billion (ppb). Given: Amount of...

In first-order predicate logic, what is a Herbrand theorem? Question 4Answer a. A statement that is provable from the axioms of first-order predicate logic b. A statement that is true in some...

Which distribution is similar to the shape of a survival function, which is often used in engineering to indicate the time it takes an object to fail? Which distribution is similar to the shape of a...

modern differential equations 1.3 Person A opens at age 25 contributes year for 10 years, but makes no additional contributions thereafter. Person B waits until age 35 to open an IRA and contributes...

The registrar of a college with a population of N = 4,000 full-time students is asked by the president to conduct a survey to measure satisfaction with the quality of life on campus. The following...

For each of these statements, decide whether it is true or false, justifying your answer or offering a counter-example. a. The graph of y = a x passes through (0, 1) for all positive real numbers a....

Show that the equation 2 cos 2 x + cos x 6 = 0 has no solutions.

a. Find the range of values of k for which the equation x 2 kx + (k + 3) = 0 has no real roots. b. Find the range of values of p for which the roots of the equation px 2 + px 2 = 0 are real.

The United Nations Development Programme (UNDP) uses the Human Development Index (HDI) in an attempt to summarize in one number the progress in health, education, and economics of a country. In 2012,...

In justifying his choice of a model, a student wrote, "I know this is the correct model because R2 = 99.4%." a) Is this reasoning correct? Explain. b) Does this model allow the student to make...

The researcher in Exercise 9 is content with the second regression. But he has found a number of shells that have large residuals and is considering removing all them. Is this good practice?