Write a query to display patient id and the maximum number of appointments booked by the patient.order by patient

Question

I am not able to use two aggregate function together

Answer 1

Dhiraj singh✔️ It seems your question appears to be an assignment. Please show us your attempt and use the 8 rules to get help from the community.
https://www.sololearn.com/Blog/38/8-simple-rules-to-get-help-from-the-community

*can be a code coach solution which is meant for you to do to help you establish your skills abilities and where you need to learn... not the community
*one issued by a school or other institution
*one issued or created by another platform
*one that appears to be in the form of a challenge that was created by you or somewhere else.

Your question will be reviewed by a team of moderators and will most likely be marked for deletion.
https://www.sololearn.com/Discuss/1316935/?ref=app

Answer 2

I tried this but it is not working...

Answer 3

Select patient id, max(appointment),
From patient table,
Order by patient number ;

Answer 4

Maybe this should work