Home / Expert Answers / Computer Science / from-tables-given-below-write-sql-queries-to-a-find-names-of-all-employees-who-have-sold-over-30-pa988

(Solved): From tables given below, write SQL queries to (a) find names of all employees who have sold over 30 ...



From tables given below, write SQL queries to

(a) find names of all employees who have sold over 30,000 to a single client.

(b) find all clients who are handled by the branch that Michael Scott manager (Assume you know Michael’s ID)

Works With Branch Client
\begin{tabular}{|c|c|c|}
\hline client id & client name & branch id \\
\hline 400 & Durmore Highschool & 2 \\
\hline 4

Employee

Works With Branch Client \begin{tabular}{|c|c|c|} \hline client id & client name & branch id \\ \hline 400 & Durmore Highschool & 2 \\ \hline 401 & Lackawana Country & 2 \\ \hline 402 & FeoEx & 3 \\ \hline 403 & John Daly Law, LLC & 3 \\ \hline 404 & Scranton Wutepages & 2 \\ \hline 405 & Tmes Newspuovt & 3 \\ \hline 406 & FeoEx & 2 \\ \hline \end{tabular} Employee


We have an Answer from Expert

View Expert Answer

Expert Answer


Here are the SQL queries to solve the two problem
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe