;List all students (S_ID, S_LName, S_FName) with all courses (C_ID, C_NAME) that a student
has been enrolled in. Order the list by student information. Use “Outer join”.
-List all students (S_ID, S_LName, S_FName) with the number of courses and the average that
a student has been enrolled in (S_ID, S_LName, S_FName, # of courses, and the average of
those courses). Use “Outer join”.
- List all courses (C_ID, C_Name) in COURSE table with the number of students enrolled in each
- Using a subquery, list all students (S_ID, S_LName, S_FName) and average of each student,
whose average grade is higher than the average grade of all students.
budget is $10
19 freelanceria on tarjonnut keskimäärin 39 $ tähän työhön
Hi,Specialists working are for real time MNC are available to help you out.If required any kind of oracle or java related queries/projects are handled and also guided.Budget can be negotaited based on the requirement
Hello Sir, I am a Teradata certified SQL specialist and can finish these queries easily. I will charge $2 per query. Please contact me with further details for any assistance on writing queries. Thanks!