Käynnissä

help with sql queries

;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

course.

- 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

Taidot: SQL

Näytä lisää: help sql queries, sql queries, table queries, student grade, help using, grade student, sql student, student help, student course, sql grade, student information sql, sql order, sql number, sql higher average grade, sql budget, sql table, grade average, average student, table sql queries join

About the Employer:
( 53 reviews ) providence, United States

Projektin tunnus: #474501

19 freelanceria on tarjonnut keskimäärin 39 $ tähän työhön

AlosDeveloper

Hello, please see PMB

30 $ USD 0 päivässä
(28 arvostelua)
6.1
TakeReal

I can write these 4 queries for $30. Today.

30 $ USD 1 päivässä
(179 arvostelua)
5.7
GlobalTechInc

Dear Maam, I can do it right now. Please check PMB for details. Thank you.

30 $ USD 0 päivässä
(2 arvostelua)
4.0
kamosion

Very easy.

30 $ USD 0 päivässä
(2 arvostelua)
3.3
Weblogica

Get your work within 6 hrs.Good Work Lowest Price

30 $ USD 0 päivässä
(0 arvostelua)
0.0
sanjaykus

Please provide the description of all the required tables.

200 $ USD 2 päivässä
(0 arvostelua)
0.0
ttdien

I finish this job in a few hours. please give me this job. if you not satisfy with the results, you donot need to pay me.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
Kishoresg

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

30 $ USD 1 päivässä
(0 arvostelua)
0.0
shahpratixa2702

ready to work...

30 $ USD 2 päivässä
(0 arvostelua)
0.0
Kaveeths

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!

30 $ USD 1 päivässä
(0 arvostelua)
0.0
ngonichibamu0108

Easy less than an hour stuff. I am SQL expert

30 $ USD 0 päivässä
(1 arvostelu)
0.0
Nyky99

I can do this easely. Thank you for your choise.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
ayayy

I can do this, pls check your pm. Thanks.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
shoravbd

Hi, Please see the PM. Thanks/Shorav

30 $ USD 1 päivässä
(0 arvostelua)
0.0
rajeshatwork

Hi i am a fresher but lot of experience in sql during college. . i will finish u the queries in less than 3 hours. .

30 $ USD 1 päivässä
(0 arvostelua)
0.0
birijan

Please check pm.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
mrityunjaygaurav

Hello sir. Writing these queries is simple for me. i need the table structure and the queries can be written with ease. i am a fresher and has a experience of developing database based e-governance projects of 3 year Lisää

30 $ USD 1 päivässä
(0 arvostelua)
0.0
sivakrishna123

Hi I am working as SQL Developer since form 3 years, I can deliver it in 3 hrs and helps you in future also.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
sachinsonone

Hi, We are ready to work with you. Thanks Hsofttech

30 $ USD 0 päivässä
(0 arvostelua)
0.0
pkumar2511

Hi I am B.Tech in Computer Science and Oracle Consultant.Can do this very Efficently. Praveen

30 $ USD 1 päivässä
(0 arvostelua)
0.0