[Solved] Create queries for homework assignment

[jerc9024]

Can any one create the following Query code as in the image
Img 1 - https://public-jerc9024-tech.b-cdn.net/files/1.jpg

https://public-jerc9024-tech.b-cdn.net/files/1.jpg

202406060839.jpg (123.51 KiB) Viewed 7590 times

Img 2 - https://public-jerc9024-tech.b-cdn.net/files/2.jpg

https://public-jerc9024-tech.b-cdn.net/files/2.jpg

202406060842.jpg (116.15 KiB) Viewed 7590 times

[Sliderule]

Yes I can, but, no I will not.

What you are displaying is a "homework assignment".

Therefore, you have to "learn" and read the manuals and/or books, rather than having someone do it for you, and, "cheating" on your "homework assignment".

[jerc9024]

I solved all of my qusestion but still i am not able to solve these two question, guide for these are not in my book or on any website can i get some help?
(b) Write an SQL query to display the coach name with the highest pay for each sport.
(c) Write an SQL query to display Coach_ID, Coach Name, and Date_of _Apply in descending order.

[robleyd]

https://www.w3schools.com/sql/

Or other alternatives at this link.

b) learn about the MAX function
c) learn about ORDER BY