General discussion

  • Creator
    Topic
  • #2279127

    SQL

    Locked

    by umer ·

    Hi
    Can anyone help in giving query code for these problems:

    1- List the surname of any employee who does not have an e in their surname.

    2- Find the number of jobs employee 22 has had or has currently.

    3- List all of the empnos of employees and their position in 1984.

    4- What was the average salary in 1988? Look at employees who where employed on the last day of 1988.

    5- Count the number of employee who has a forename starting with M or A.

    6-List the employee numbers and telephone numbers ordered by descenending

All Comments

  • Author
    Replies
    • #3383544

      Reply To: SQL

      by madestroitsolutions ·

      In reply to SQL

      I e-mailed you with the answer, so you better give me the points here…. he he

      Good Luck!

      • #3387246

        Reply To: SQL

        by umer ·

        In reply to Reply To: SQL

        Thanks.
        I already knew the asnwers,
        but for any reason, these were still giving problem, so i asked you. Few of your pseudo-codes still have problem, i dont know why.

    • #3387277

      Reply To: SQL

      by pnakiet ·

      In reply to SQL

      Hi, you
      You should go to school better than ask us here.
      Good Luck

      • #3387245

        Reply To: SQL

        by umer ·

        In reply to Reply To: SQL

        any problem?
        i already knew the answers by the way.

    • #3387244

      Reply To: SQL

      by umer ·

      In reply to SQL

      This question was closed by the author

Viewing 2 reply threads