Home / Expert Answers / Computer Science / q-5-from-the-below-table-a-nbsp-write-a-sql-query-to-retrieve-the-number-of-employees-having-di-pa793

(Solved): Q# 5: From the below table (a) Write a SQL query to retrieve the number of employees having di ...



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

\begin{tabular}{|c|c|c|c|c|c|c|}
\hline EmplD & EmpName & \multicolumn{1}{c|}{ EmpEmail } & PhoneNumber & Salary & City \\
\h

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


We have an Answer from Expert

View Expert Answer

Expert Answer


(a) Here is a query that will retrieve
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe