Write a query to display list of students name who all are from IT department. Sort the result based on students name in descending. Hint:Use Subquery Refer the below schema diagram: Department...


Write a query to display list of students name who all are from IT department. Sort the result based on students name in descending.<br>Hint:Use Subquery<br>Refer the below schema diagram:<br>Department<br>Student<br>department_id number --> PK<br>department_name varchar(30)<br>department_block_number number<br>student_id number--> PK<br>student_name varchar(30)<br>address varchar(40)<br>city varchar(30)<br>department_id number --> FK<br>PK- Primary Key<br>FK- Foreign Key<br>Subject<br>Staff<br>staff_id number-- PK<br>staff_name varchar(30)<br>department_id number--> FK<br>dsubject_id number --PK<br>subject_name varchar(30)<br>subject_code varchar(10)<br>staff_id number --> FK<br>Mark<br>value number<br>subject_id number--> PKFK H<br>student_id number->PK,FK<br>

Extracted text: Write a query to display list of students name who all are from IT department. Sort the result based on students name in descending. Hint:Use Subquery Refer the below schema diagram: Department Student department_id number --> PK department_name varchar(30) department_block_number number student_id number--> PK student_name varchar(30) address varchar(40) city varchar(30) department_id number --> FK PK- Primary Key FK- Foreign Key Subject Staff staff_id number-- PK staff_name varchar(30) department_id number--> FK dsubject_id number --PK subject_name varchar(30) subject_code varchar(10) staff_id number --> FK Mark value number subject_id number--> PKFK H student_id number->PK,FK

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here