Explore BrainMass

Explore BrainMass

    MS SQL SERVER 2003

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

    MS SQL SERVER 2003

    Problem 1
    Write SQL queries
    1. Write a SQL query that joins Customer and Store table in the Kudler database and uses BETWEEN to restrict record selection (use Store Name to restrict the data).
    2. Write a SQL query that Customer and Store table in the Kudler database and uses LIKE to restrict record selection (use Store Phone Number to restrict data).
    3. Group Customers by Store Name: Select the Customer's last name and group them by Store Name.
    4. Choose a Customer from the Customer table, delete this Customer.
    5. Calculate the maximum labor cost for all item types from the Item Table.

    Problem 2
    In addition create your own SQL query from the database
    · GROUP statement
    · UNION statement
    · JOIN statement
    · INSERT statement
    · DELETE/DROP statement

    © BrainMass Inc. brainmass.com March 4, 2021, 6:06 pm ad1c9bdddf
    https://brainmass.com/computer-science/sql/ms-sql-server-2003-29779

    Attachments

    Solution Preview

    select Store.Store_Name, Store.Store_Phone_Number, Customer.Phone_Number
    from Store inner join Customer on Store.Store_City = Customer.City
    where Store.Store_Name between 'CircuitCity' and 'TigerDirect';

    select Store.Store_Name, Store.Store_Phone_Number, ...

    Solution Summary

    MS SQL SERVER 2003 is studied.

    $2.49

    ADVERTISEMENT