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 1997. Sort the result set by<br>student's Id.<br>Student - Course Enrollement Management<br>STUDENT<br>COURSE<br>PK Studid<br>FirstName<br>LastName<br>Street<br>City<br>DOB<br>Number(4)<br>PK courseid<br>CourseName<br>number(4)<br>varchar2(20)<br>number(2)<br>number(7,2)<br>Varchar2(20)<br>Varchar2(20)<br>Varchar2(20)<br>Varchar2(20)<br>Date<br>Duration<br>Fees<br>REGISTRATION<br>FK CourselD<br>FK Studld<br>number(4)<br>number(4)<br>PK-Primary key<br>FK-Foreign key<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 PK Studid FirstName LastName Street City DOB Number(4) PK courseid CourseName number(4) varchar2(20) number(2) number(7,2) Varchar2(20) Varchar2(20) Varchar2(20) Varchar2(20) Date Duration Fees REGISTRATION FK CourselD FK Studld number(4) number(4) PK-Primary key FK-Foreign key DOJ Date

Jun 05, 2022

SOLUTION.PDF

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...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment