| Search (advanced search) | ||||
Use this Search form before posting, asking or make a new thread.
|
|
06-25-2020, 05:06 PM
(This post was last modified: 06-25-2020 05:14 PM by leejiacheng1.)
Post: #1
|
|||
|
|||
|
[GET] SQL and PostgreSQL: From beginner to pro
SQL and PostgreSQL: From beginner to pro
https://skl.sh/2V64tDR
Reps+ are always welcome!
Happy Learning! Jia Cheng bro. My other posts that you might miss: bestblackhatforum.com/search.php?action=finduser&uid=341124 |
|||
|
08-11-2020, 06:01 PM
Post: #2
|
|||
|
|||
|
RE: [GET] SQL and PostgreSQL: From beginner to pro
Coupon reinstate!
https://skl.sh/2V64tDR ****************************************************************** Project Description Please try all of these queries before you look at the solution, it is okay to look at the solution when your query doesn't work. (some of these queries are not simple). But please at least try it :) 1. Create new table "courseDetail" which will contain id of course and its price. 2.Select name of course together with a number of students and price order the result by a number of students in descending order if multiple records have the same number of students order them by price in descending order. 3. Select names of all programming courses 4. Select names of all courses with a number of students greater than 7500 5. Select names and number of students of courses with category starting with 'P' and number of students greater than 7000 6. Select name of students with id greater than 1 and age greater than 20 7. Select name of students with id greater than 1 or age greater or equal to 20 8. Select all courses with the same category as the 'Java' course (NOTE: Query must work even when the category of Java course changes) Solutions will be revealed in following lectures
Reps+ are always welcome!
Happy Learning! Jia Cheng bro. My other posts that you might miss: bestblackhatforum.com/search.php?action=finduser&uid=341124 |
|||
