Select 5 % of admission fees from sara , 10% of admission fees from Dora and for other 15 % of admission fees as ‘Deducted_Admission_fee’ from tblStudent table.

YasminRadwan26

Save to bookmark

2022-05-13

1097

Database, Sql programming, Interview questions, Database Interview-questions, Sql programming Interview-questions,

All Answers

YasminRadwan26

2022-05-13

need an explanation for this answer? contact us directly to get an explanation for this answer

SELECT FirstName, CASE FirstName WHEN 'Sara' THEN Admission_fee * .10 WHEN 'Dora' THEN Admission_fee * .15 ELSE Admission_fee * .15

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Select 5 % of admission fees from sara , 10% of admission fees from Dora and for other 15 % of admission fees as ‘Deducted_Admission_fee’ from tblStudent table.

All Answers

This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now