Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME ELC D102 D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE S103 Hisham 6/1/1999 Male 90 D102 A102 Level 1 22 12/30/1994 Female 45 D103 Diploma Dipioma S102 Sara A104 27 S101 Salim 6/1/1999 Male 45 D103 A104 22 S/6/1995 Male 10/15/1992 Male S107 Khalil 45 D101 A101 BTech 26 S109 Said 45 D104 A101 Advanced Diploma 29 45 D101 S/1/1995 Male 4/5/1998 Male $100 Ahmad A103 STech 26 S104 Faisal 90 D104 A101 Advanced Diploma 23 Fatima 2/23/1992 Female 90 D102 A102 Level 2 Level 3 | Dipioma $105 29 S106 Arwa 9/12/1999 Female 45 D102 A102 22 8/13/1991 Female 90 D103 S108 Ibtisam A104 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of all students who belong to BSD department with the USING clause 3. Display the advisor name, student name and gender for all students who belong to Level 1, Level 2 or Level 3 by using the FROM clause 4. Display the department name and allowance of students 5. Display the advisor name, student name and department name

Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME ELC D102 D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE S103 Hisham 6/1/1999 Male 90 D102 A102 Level 1 22 12/30/1994 Female 45 D103 Diploma Dipioma S102 Sara A104 27 S101 Salim 6/1/1999 Male 45 D103 A104 22 S/6/1995 Male 10/15/1992 Male S107 Khalil 45 D101 A101 BTech 26 S109 Said 45 D104 A101 Advanced Diploma 29 45 D101 S/1/1995 Male 4/5/1998 Male $100 Ahmad A103 STech 26 S104 Faisal 90 D104 A101 Advanced Diploma 23 Fatima 2/23/1992 Female 90 D102 A102 Level 2 Level 3 | Dipioma $105 29 S106 Arwa 9/12/1999 Female 45 D102 A102 22 8/13/1991 Female 90 D103 S108 Ibtisam A104 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of all students who belong to BSD department with the USING clause 3. Display the advisor name, student name and gender for all students who belong to Level 1, Level 2 or Level 3 by using the FROM clause 4. Display the department name and allowance of students 5. Display the advisor name, student name and department name

Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
See similar textbooks
icon
Related questions
Question
Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE Hisham 6/1/1999 Male 90 D102 S103 A102 Level 1 22 12/30/1994 Female 45 D103 S102 Sara A104 Diploma 27 S101 Salim 6/1/1999 Male 45 | D103 A104 Diploma 22 5107 Khalil 5/6/1995 Male 45 D101 A101 Blech 26 45 | D104 Advanced Diploma S109 Said 10/15/1992 Male A101 29 5/1/1995 Male 45 D101 90 D104 5100 Ahmad BTech Advanced Diploma A103 26 4/5/1998 Male 2/23/1992 Female 9/12/1999 Female S104 Faisal A101 23 0 D102 45 D102 S105 Fatima 90 A102 Level 2 29 S106 Arwa A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of all students who belong to BSD department with the USING clause 3. Display the advisor name, student name and gender for all students who belong to Level 1, Level 2 or Level 3 by using the FROM clause 4. Display the department name and allowance of students 5. Display the advisor name, student name and department name
Transcribed Image Text:Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE Hisham 6/1/1999 Male 90 D102 S103 A102 Level 1 22 12/30/1994 Female 45 D103 S102 Sara A104 Diploma 27 S101 Salim 6/1/1999 Male 45 | D103 A104 Diploma 22 5107 Khalil 5/6/1995 Male 45 D101 A101 Blech 26 45 | D104 Advanced Diploma S109 Said 10/15/1992 Male A101 29 5/1/1995 Male 45 D101 90 D104 5100 Ahmad BTech Advanced Diploma A103 26 4/5/1998 Male 2/23/1992 Female 9/12/1999 Female S104 Faisal A101 23 0 D102 45 D102 S105 Fatima 90 A102 Level 2 29 S106 Arwa A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of all students who belong to BSD department with the USING clause 3. Display the advisor name, student name and gender for all students who belong to Level 1, Level 2 or Level 3 by using the FROM clause 4. Display the department name and allowance of students 5. Display the advisor name, student name and department name
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Web Page
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
SEE MORE TEXTBOOKS