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
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Knowledge Booster
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.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L