Question: Q# 5: From the below table (a) Write a SQL query to retrieve the number of employees having different salaries in each city. (b) Write

Q# 5: From the below table

(a) Write a SQL query to retrieve the number of employees having different salaries in each city.

(b) Write a query to retrieve the number of employees in each city, having salary > 15000

Q# 5: From the below table (a) Write a SQL query to

\begin{tabular}{|c|c|c|c|c|c|c|} \hline EmplD & EmpName & \multicolumn{1}{c|}{ EmpEmail } & PhoneNumber & Salary & City \\ \hline 1 & Nidhi & nidhiesample.com & 9955669999 & 50000 & Mumbai \\ \hline 2 & Anay & anay\&sample.com & 9875679861 & 55000 & Pune \\ \hline 3 & Rahul & rahulesample.com & 9876543212 & 35000 & Delhi \\ \hline 4 & Sonia & sonia@sample.com & 9876543234 & 35000 & Delhi \\ \hline 5 & Akash & akashesample.com & 9866865686 & 25000 & Mumbai \\ \hline \end{tabular}

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!

How many films are in the database?How many films are in the database? Write a SQL query to retrieve the number of films in the film table. Save the query in a text file named query 1 - 1 . sql Save...

Problem: Northwind Traders is a leading international supplier of food and beverages. They have an extensive network of suppliers around the world and customers spread across different countries....

53600-001: Business Data Warehousing Assignment- 1 SQL Refresher 1 salesman_id name city commission ----------- ---------- ---------- ---------- 5001 James Hoog New York 0.15 5002 Nail Knite Paris...

Define the contextual-equivalence relation ` M =ctx M0 : for pairs of PCF terms M, M0 , PCF types , and PCF type environments . [3 marks] (ii) For PCF terms M and N with respective typings ` M : and...

Needing some help on making these SQL tables and then launching the queries with them the thing we use is pure SQL coding in like a playground server so if it can be something similar to that it be...

Needing some help on making these SQL tables and then launching the queries with them 1. Create two tables: books and authors. 2. In the books table, include the following columns: book_id (primary...

salesman_id name city commission ----------- ---------- ---------- ---------- 5001 James Hoog New York 0.15 5002 Nail Knite Paris 0.13 5005 Pit Alex London 0.11 5006 Mc Lyon Paris 0.14 5003 Lauson...

Q 1 . Create a table named Employee with the following structure: EmployeeID ( integer , primary key ) FirstName ( varchar , not null ) LastName ( varchar , not null ) Department ( varchar , not null...

Assuming a library database schema with the following tables and attributes: Book (BookID, Title, AuthorID, PublisherID, Rating, Price) Author (AuthorID, FirstName, LastName) Publisher (PublisherID,...

Q2(a) i. The Lyons Dance Company uses the following database that stores data about ballet dancers, shows and companies. COMPANY(compID, compname, city, country) DANCER(dancerID, dname, birthyear,...

Consider now Review Exercise 3.76. The density function of the time Z in minutes between calls to an electrical supply store is given by (a) What is the mean time between calls? (b) What is the...

A rod of mass m and length / is lying on a horizontal table. The work done in making it stand on one end will be- (a) mgl (b) mgl 2 (c) mgl 4 (d) 2mgl

Income Statement Income Gross sales 6 Sales returns and allowances 240000 Net sales 6660000 Cost of goods sold 2760000 Gross profit 3900000 Dividends received from stock investments in lessthan20...

The financial statements of Eagle Sport Supply are shown in the table below. For simplicity, "Costs" include interest. Assume that Eagle's assets are proportional to its sales. Assume a growth rate...

Consider a country where you may want to work. Research the cultural differences you may encounter and work out how this would affect the management of people in organisations in that country.

If you have fellow students from a number of countries, choose fi ve of them and discuss with them their working experience of how recruitment, performance management and reward operate in practice.

Disparate impact analysis (the four-fifths rule, standard deviation analysis) is used in employment discrimination cases. The National Assessment of Education Progress conducted by the U.S....