Write a query to display student's Id and First Name whose from Coimbatore or Chennai and born on 8th Oct 1997. Sort the result set by student's Id. Student - Course Enrollement Management STUDENT...


Write a query to display student's Id and First Name whose from Coimbatore or Chennai and born on 8th Oct<br>1997. Sort the result set by student's Id.<br>Student - Course Enrollement Management<br>STUDENT<br>COURSE<br>Number(4)<br>PK Studld<br>FirstName<br>LastName<br>Street<br>PK<br>courseid<br>number(4)<br>Varchar2(20)<br>varchar2(20)<br>number(2)<br>number(7,2)<br>96<br>CourseName<br>Duration<br>Fees<br>Varchar2(20)<br>Varchar2(20)<br>Varchar2(20)<br>City<br>DOB<br>Date<br>REGISTRATION<br>number(4)<br>PK-Primary key<br>FK-Foreign key<br>FK<br>CourselD<br>FK Studld<br>number(4)<br>DOJ<br>Date<br>

Extracted text: Write a query to display student's Id and First Name whose from Coimbatore or Chennai and born on 8th Oct 1997. Sort the result set by student's Id. Student - Course Enrollement Management STUDENT COURSE Number(4) PK Studld FirstName LastName Street PK courseid number(4) Varchar2(20) varchar2(20) number(2) number(7,2) 96 CourseName Duration Fees Varchar2(20) Varchar2(20) Varchar2(20) City DOB Date REGISTRATION number(4) PK-Primary key FK-Foreign key FK CourselD FK Studld number(4) DOJ Date

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here