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
- 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
- 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".

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