Hi,
I have following table and has wrriten SQL View like this

'Ticket_Certifi cation' one to one 'Ticket'
'Ticket_Certifi cation' one to many 'Ticket_Certifi cation_Internal CertNo'
'Ticket' one to one 'Master_TicketT ype', 'Ticket_StatusD ates'
'Ticket' One to Many 'Fee_Details' (this table contains only the unpaid ticketIDs)
'Fee_Details' one to many 'Fee'

Now I have to calculate the...