Explore BrainMass

Explore BrainMass

    Database Management problems

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Note the table below.

    Write an SQL query to show the names and salary of salespeople who have two or more orders. First use a join query and then write the query again using a sub query.
    SALESPERSON: name, percent_of_quota, salary
    ORDER: number, cust_name, salesperson_name, amount
    CUSTOMER: name, city, industry_type

    © BrainMass Inc. brainmass.com February 24, 2021, 2:18 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/database-management-example-problems-12680

    Attachments

    Solution Summary

    This solution provides an SQL query to show the names and salary of salespeople who have two or more orders.

    $2.19

    ADVERTISEMENT