Practical 5.sql

-- 1. Solve the following queries using above databases and where clause range searching and pattern matching

-- Output

-- 2. List all salesmen with their % of commission.


-- 3. Display the no. Of orders for each day in the descending order of the no. Of orders in the following format. FOR dd-mm-yy,there are____ Orders.
    -- a. Assume each salesperson has a 12% commission. Write a query on the order table that will produce the order number, salesman no and the amount of commission for that order.


-- 4. Find the highest rating in each city in the form: For the city (city), the highest rating)


-- 5. List all in descending order of rating. Calculate the total of orders for each day and place the result in descending order.