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

Tietoa työnantajasta:
( 54 arvostelua ) providence, United States

Projektin tunnus: #474501

19 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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 [login to view URL] 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 [login to view URL] required any kind of oracle or java related queries/projects are handled and also [login to view URL] 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 [login to view URL] in Computer Science and Oracle [login to view URL] do this very Efficently. Praveen

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