SQL query using joins

Tags:
ANSI SQL
MySQL
@page { margin: 2cm } p { margin-bottom: 0.21cm } @page { margin: 2cm } p { margin-bottom: 0.21cm }

Question: Write a query to fetch the details of all the employees who know two additional languages (speak and read) other than their mother tongue. Their salary must be greater than 50000 and have been working in the company from 2012.

 


Software/Hardware used:
sql
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    This is obviously a homework assignment.

    Are you having problems doing it?

    If you show us what you have tried, we can guide you, so that you get to solve it by yourself.
    85,015 pointsBadges:
    report
  • ToddN2000
    Post the code you have tried and any results. At this point we have no clues as to the tables, table layouts and field names needed to even start to point you in the right direction. We are glad to help you fix problems but you need to try it on your own to reinforce the logic.  If we do it for you then it's just like a copy and paste and you will not learn anything more. This data may be in one table or many tables.  I will give a clue...
    Select a,b,c,d,e from file1
    join file2 on file1.a = file2.a


    134,585 pointsBadges:
    report
  • abdioromo29
    what is physical securty

    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: