Computer Science, asked by PraveenGupta8737, 23 days 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

Science, 11 days ago

ವಿದ್ಯುತ್‌ ಬಲ್ಬ್ ನಲ್ಲಿ ಉದ್ದನೆಯ ಟಂಗಸ್ಟನ ತಂತಿಯನ್ನು ಸುರುಳಿ ರೂಪಕ್ಕೆ ಪರಿವರ್ತಿಸಿ ಅಳವಡಿಸಿರುತ್ತಾರೆ ಏಕೆಂದರೆ A) ತಂತಿಯ ಉದ್ದ ಹೆಚ್ಚಾ ದಂತೆ ರೋಧ ಹೆಚ್ಚಾ ಗುತ್ತದೆ ಇದರಿಂದ ಉಷ್ಣ ಪರಿಣಾಮವು ಹೆಚ್ಟಾಗುತ್ತದೆ B) ತಂತಿಯ ಉದ್ದ ಹೆಚ್ಚಾ ದಂತೆ ರೋಧ ಕಡಿಮೆಯಾಗುತ್ತ ದೆ ಇದರಿಂದ ಉಷ್ಣ ಪರಿಣಾಮವು ಹೆಚ್ಚಾ ಗುತ್ತಿದೆ C) ತಂತ್ತಯ ಉದದ ಹೆಚ್ಚಾ ದಂತೆ ರೋಧ ಕಡಿಮೆಯಾಗುತಿ ದೆ ಇದರಿಾಂದ ಉಷ್ಣ ಪ್ರಿಣಾಮವು ಕಡಿಮೆಯಾಗುತಿ ದೆ. D)ತಂತಿ ಉದ್ದ ಹೆಚ್ಚಾ ದಂತೆ ರೋಧ ಹೆಚ್ಚಾ...

Math, 11 days ago

find the HCF of the following numbers by continued division method a) 250,415...

Geography, 11 days ago

what is sociology??????

Business Studies, 23 days 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, 23 days 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, 8 months ago

calculate national income by income and expenditure...

Biology, 8 months ago

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

Math, 8 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.