Find Jobs
Hire Freelancers

Beginner SQL/Database Help!!!!

$30-100 USD

クローズ
投稿日: 21年以上前

$30-100 USD

完了時にお支払い
Answer the following questions using the School database and the data provided. For each question, submit the SQL statements used to determine the answer and your answer. 1) Create a view to calculate the numerical grade point average for each student listed in the database. 2) Create a view to calculate the number majoring in each department? 3) Create a view of the STUDENT table that includes the age of the student. This view should include all other STUDENT fields as well. 4) Which students have a grade point average that is higher than the grade point average of students who are majoring in ECT? 5) Which students have a grade point average that is higher than the grade point average of all the students who are majoring in HCI? 6) Create a view to list the different instructors that are teaching in the current academic year. 7) Which students have taken courses taught by Xiaoping Xia? 8) Which students have taken a course that is among the courses taught by Xiaoping Xia, even if the student did not take the course from Xiaoping Xia? 9) Which instructors teach courses in the same department as those taught by Evelyn Lulis and Yoseph Winograd? 10) Which five students have the highest grade point averages? 11) An analysis of the data in our database revealed that there are a lot of duplicate addresses in the ADDRESS table. In order to converse space, we need to make some changes to the database. We will assign each address a unique identifier and reference that address from the STUDENT table as either the permanent or temporary address. Students living at the same address will point to the same ADDRESS record. (25 points) This question has 3 parts i can send to you. I also have a project that needs to be done and I can send that you as well. ## Deliverables All I need is the SQL statements that would make this work. It would also help, though, if it could be explained what is happening in each part of the sql statement. Also, this is a beginnner class and should use certain statements that I can give you that we have gone over in class. I can email you the SCHOOL database that this uses and the project info. ## Platform Should work on win2000 using oracle and SQL ## Deadline information Please email me at k7e3v3 at aol.com. This can not be done in very advanced SQL. I will go over the details if you feel like youd like to do this and the project. Thanks a bunch for your help.
プロジェクト ID: 2882336

プロジェクトについて

37個の提案
リモートプロジェクト
アクティブ 21年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に37人のフリーランサーが、平均$48 USDで入札しています
ユーザーアバター
See private message.
$51 USD 14日以内
5.0 (137 レビュー)
7.0
7.0
ユーザーアバター
See private message.
$84.15 USD 14日以内
4.7 (96 レビュー)
7.0
7.0
ユーザーアバター
See private message.
$48.45 USD 14日以内
4.9 (133 レビュー)
6.4
6.4
ユーザーアバター
See private message.
$21.25 USD 14日以内
5.0 (34 レビュー)
4.5
4.5
ユーザーアバター
See private message.
$42.50 USD 14日以内
5.0 (47 レビュー)
4.1
4.1
ユーザーアバター
See private message.
$17 USD 14日以内
5.0 (27 レビュー)
4.1
4.1
ユーザーアバター
See private message.
$34 USD 14日以内
5.0 (14 レビュー)
3.8
3.8
ユーザーアバター
See private message.
$42.50 USD 14日以内
4.8 (27 レビュー)
3.7
3.7
ユーザーアバター
See private message.
$42.50 USD 14日以内
3.7 (9 レビュー)
3.7
3.7
ユーザーアバター
See private message.
$17 USD 14日以内
5.0 (3 レビュー)
3.4
3.4
ユーザーアバター
See private message.
$59.50 USD 14日以内
3.7 (5 レビュー)
2.9
2.9
ユーザーアバター
See private message.
$63.75 USD 14日以内
4.5 (5 レビュー)
2.5
2.5
ユーザーアバター
See private message.
$42.50 USD 14日以内
5.0 (18 レビュー)
2.4
2.4
ユーザーアバター
See private message.
$8.50 USD 14日以内
5.0 (1 レビュー)
2.0
2.0
ユーザーアバター
See private message.
$47.60 USD 14日以内
5.0 (8 レビュー)
2.0
2.0
ユーザーアバター
See private message.
$85 USD 14日以内
4.8 (2 レビュー)
1.9
1.9
ユーザーアバター
See private message.
$30.60 USD 14日以内
3.9 (7 レビュー)
1.3
1.3
ユーザーアバター
See private message.
$8.50 USD 14日以内
4.8 (2 レビュー)
1.0
1.0
ユーザーアバター
See private message.
$42.50 USD 14日以内
5.0 (2 レビュー)
0.9
0.9
ユーザーアバター
See private message.
$85 USD 14日以内
5.0 (1 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
United States
5.0
2
メンバー登録日:11月 4, 2002

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。