MYSQL......
SOLUTION
1. Display the name of week day when socks purchased.
Sol :-
2. Display remainder after dividing price by qty
Sol :-
3. Display the discount amount by 10% in two decimal places.
Sol :-
4. Display the records of items purchased in the month 11.
Sol :-
5. Display maximum qty purchased from the table.
Sol :-
6. Display itemname, price and qty in the descending order of price.
Sol :-
7. Display item_id, itemname and position of s in each itemname.
Sol :-
One Response