Question

05.
by aata vypes.write any four data types.
Assume the table BILL given below
Qty
15
B no BIl date
Cust_name
Item desc
Price
1
2021-10-8
Deepak Display Unit
20
5000
2
2021-10-8
Sumit Chair
10
1200
3
2021-10-9
Harshit Table
10
2500
4
2021-10-9
Punit
Display unit
15
5000
5
2021-10-9
Sumit
Study Table
7500
2021-10-9
Sarika
Table
15
2500
7
2021-10-10
Deepak Table
10
2500
8
2021-10-10
Sumit
Chair
10
1500
9
2021-10-11
Punit
Chair
10
1700
10 2021-10-11
Deepak
Study table
15
7500
5
(ANY FIVE)
(a) Write command for each task
1. Write the command to make the table bill.
2. Write the command to add one more field discount
3. Set the value as 10% of price for all bill
4. Display detail of all bills
5. Write command to display cust_name_item_desc,qty .price, amount (Qty*Price) for
all items
6. Write command to display all unique item sold​

Answer 1

Answer:

please check your questions