Question

i)Display a report listing name, age, charges and amount of charges including VAT as 2% on charges name the column as total charges and keep the data in ascending order of name.

ii)To display the difference of highest and lowest charges of each department having maximum charges more than 300.

iii)Find out the details of patients whose age is same or more than that of patient whose hospital charges are maximum.
iv)Display the charges of various departments .A charge amount should appear only once.
Can someone help me with this

Answer 1

Answer:

sorry i don't know this.

but tell me next question.

i ready to answer.

follow and mark brilliantly.