Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
e. Find the number of graduate students who have the same average degrees, average degrees and display new column as average degrees*average degrees/2 for each graduate student, and list in the order of age. f. Write a query to retrieve name of professor, department name and project, for all projects whose budget is greater than 400. g. Select all those professors who age in the range 30 to 40 and don't www bave any rank

e. Find the number of graduate students who have the same average degrees, average degrees and display new column as average degrees*average degrees/2 for each graduate student, and list in the order of age. f. Write a query to retrieve name of professor, department name and project, for all projects whose budget is greater than 400. g. Select all those professors who age in the range 30 to 40 and don't www bave any rank

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Hello
Can you help me answering these question on xamp ??
I need the syntax
I'm waiting 

DH Donia Hussin A Fnal Project - Word )فشل تنشيط المنتج( مشاركة و أخبرني بما تريد القيام به تعليمات مراجعة مراسلات الشريط الرئيسي عرض تصميم ملف ابجد قص A- Aa A A ابجد هوز عنوان فرعي تأكيد دقیق أبجد هوز أبجد فوز أبجد هور أبجد هوز أبجد هوز أبجد هوز أبجد هوز Jluiul ab yac العنوات عنوان V عنوان ۲ العنوان ) بلا تباعد T ülgic عادي -= = = E - A - aly - A X2 abe - U I B الصق تحديد - نسخ التنسيق تحرير blait فقرة الحافظة 1 2 3 4 . 5 10 . 11. I. 12 13 . 14 15 . 1 16 17 I. 18 .| 19 professors Projects SSN name age R_specialty rank pnumber starting ending Date budget ssn_pro name 1 Alexandra 30 Science Assistant Professor Date 2 Alex 35 English Assistant Professor 1/3/2020 20/3/2020 1/4/2020 1/3/2020 20/3/2020 Analysis_1 9/4/2020 20/4/2020 29/4/2020 9/4/2020 1 300 1 3 Lesbon 40 Mathmatic Professor 2 Translate 400 2 4 smith 32 Science null 3 Calculation 600 3 5 Loại 42 Computer Professor Analysis_2 algorithm 4 200 1 5 29/5/2020 320 5 Work_In departments work_dept Ssn dnumber time pnumber dnumber name ssn Office Ssn_pro 1 1 1 3:00pm 1 IT New York 1 3 2 12:30am 3 2 Science Boston 3 2 3 2 3 1:00pm 3 Engineering Boston 3 1 2 3:00am 1 4 Health sciences New York 2 1 3 Chicago 4 4 11:00am 5 Accounting 1 work_proj Gradute SSN Gradute_NO pnumber 1 1 1 SSN Avg_degree age dnumber advise name 2 1 2 1 Laila 85 24 1 1 3 1 3 2 Ali 90 22 1 2 1 4 3 Ahmed 95 26 3 5 1 5 4 Sami null 30 2 3 2 1 5 Amany Andre 85 32 2 2 2 Windows buii انتقل إلى الإعدادت لتنشيط Windows. 6 95 33 3 5 3 4 3 140% الإنجليزية )الولايات المتحدة( من 19۲ كلمات الصفحة ۲ من ک e •V:IA ENG E3 Ai Pr Ps PC Au 1/8/2021
Transcribed Image Text:DH Donia Hussin A Fnal Project - Word )فشل تنشيط المنتج( مشاركة و أخبرني بما تريد القيام به تعليمات مراجعة مراسلات الشريط الرئيسي عرض تصميم ملف ابجد قص A- Aa A A ابجد هوز عنوان فرعي تأكيد دقیق أبجد هوز أبجد فوز أبجد هور أبجد هوز أبجد هوز أبجد هوز أبجد هوز Jluiul ab yac العنوات عنوان V عنوان ۲ العنوان ) بلا تباعد T ülgic عادي -= = = E - A - aly - A X2 abe - U I B الصق تحديد - نسخ التنسيق تحرير blait فقرة الحافظة 1 2 3 4 . 5 10 . 11. I. 12 13 . 14 15 . 1 16 17 I. 18 .| 19 professors Projects SSN name age R_specialty rank pnumber starting ending Date budget ssn_pro name 1 Alexandra 30 Science Assistant Professor Date 2 Alex 35 English Assistant Professor 1/3/2020 20/3/2020 1/4/2020 1/3/2020 20/3/2020 Analysis_1 9/4/2020 20/4/2020 29/4/2020 9/4/2020 1 300 1 3 Lesbon 40 Mathmatic Professor 2 Translate 400 2 4 smith 32 Science null 3 Calculation 600 3 5 Loại 42 Computer Professor Analysis_2 algorithm 4 200 1 5 29/5/2020 320 5 Work_In departments work_dept Ssn dnumber time pnumber dnumber name ssn Office Ssn_pro 1 1 1 3:00pm 1 IT New York 1 3 2 12:30am 3 2 Science Boston 3 2 3 2 3 1:00pm 3 Engineering Boston 3 1 2 3:00am 1 4 Health sciences New York 2 1 3 Chicago 4 4 11:00am 5 Accounting 1 work_proj Gradute SSN Gradute_NO pnumber 1 1 1 SSN Avg_degree age dnumber advise name 2 1 2 1 Laila 85 24 1 1 3 1 3 2 Ali 90 22 1 2 1 4 3 Ahmed 95 26 3 5 1 5 4 Sami null 30 2 3 2 1 5 Amany Andre 85 32 2 2 2 Windows buii انتقل إلى الإعدادت لتنشيط Windows. 6 95 33 3 5 3 4 3 140% الإنجليزية )الولايات المتحدة( من 19۲ كلمات الصفحة ۲ من ک e •V:IA ENG E3 Ai Pr Ps PC Au 1/8/2021
b. Find all information of projects who have managed by each professor c. Find the names and degrees of graduate students whose degree is better than some graduate students called ali. d. write a query to retrieve the name of graduate student and student advisor name of all graduate student. e. Find the number of graduate students who have the same average degrees, average degrees and display new column as average degrees*average degrees/2 for each graduate student, and list in the order of age. f. Write a query to retrieve name of professor, department name and project, for all projects whose budget is greater than 400. g. Select all those professors who age in the range 30 to 40 and don't have any rank.
Transcribed Image Text:b. Find all information of projects who have managed by each professor c. Find the names and degrees of graduate students whose degree is better than some graduate students called ali. d. write a query to retrieve the name of graduate student and student advisor name of all graduate student. e. Find the number of graduate students who have the same average degrees, average degrees and display new column as average degrees*average degrees/2 for each graduate student, and list in the order of age. f. Write a query to retrieve name of professor, department name and project, for all projects whose budget is greater than 400. g. Select all those professors who age in the range 30 to 40 and don't have any rank.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS