Page 1 of 1

[Solved] Create queries for homework assignment

Posted: Thu Jun 06, 2024 3:15 pm
by 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
https://public-jerc9024-tech.b-cdn.net/files/1.jpg
202406060839.jpg (123.51 KiB) Viewed 7635 times
Img 2 - https://public-jerc9024-tech.b-cdn.net/files/2.jpg
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 7635 times

Re: Database Query Code.....

Posted: Thu Jun 06, 2024 3:35 pm
by 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". :crazy: :ucrazy: :?: :?:

Re: Database Query Code.....

Posted: Fri Jun 07, 2024 1:07 pm
by 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.

Re: Database Query Code.....

Posted: Fri Jun 07, 2024 1:36 pm
by robleyd
https://www.w3schools.com/sql/

Or other alternatives at this link.

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