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 give me the queries?

Answer 1

Answer:

(1)The value of ‘g’

(i)Increases as we go above the earth’s