Skip to main content

20. Assume each salesperson has a 12 % commission.Write a query on the order table that will Produce the Order number, salesman no and amount of commission for that order.

SELECT
    onum,
    snum,
    ammount * 0.12
FROM
    orders;

Output:

d