Computer Science, asked by PraveenGupta8737, 1 month ago

Write a query to display list of staff name, subject name handled, maximum mark scored in that subject. Give an alias to the maximum mark as max_mark. Sort the result based on maximum mark in descending
using:joins & subquery

Answers

Answered by AnshuBhardwaj123

1

Below is the answer to your question

Attachments:

Previous Question

Next Question

Similar questions

English, 26 days ago

Rokon said to me,"I shall go to the picture today"...

Math, 26 days ago

solve equation please help me...

Biology, 26 days ago

why polymerization is called dehydration synthesis...

Business Studies, 1 month ago

is the ability to quickly expand or decrease computer processing, memory and storage resources to meet changing demands without worrying about capacity planning and engineering for peak usage.Select oneFault toleranceDisposable resourcesElasticityHigh availability...

Chemistry, 1 month ago

Write the structure of the major organic product in each of the following reactions:(i) CH3CH2CH2CI + Nal acetoneheat(ii) (CH3)3CBr + KOH ethanolheat(iii) CH3CH(Br)CH2CH3+ NaOH water(iv) CH3CH2Br + KCN aq. ethanol(v) C6H5ONa + C2H5CI(vi) CH3CH2CH2OH + SOCI2(vii) CH3CH2CH = CH2+ HBr peroxide(viii) CH3CH = C(CH3)2 + HBr...

Economy, 9 months ago

calculate national income by income and expenditure...

Biology, 9 months ago

vessels that carry blood from various organ towards the heart...

Math, 9 months ago

On Sunday. Raju ran 5/3 km . on monday he ran 13/5 km . (a) the total distance he ran in two days. (b) the difference in the distance he ran on both days.