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>Number(4)<br>Varchar2(20)<br>Varchar2(20)<br>Varchar2(20)<br>Varchar2(20)<br>Date<br>PK courseid<br>CourseName<br>number(4)<br>varchar2(20)<br>number(2)<br>number(7,2)<br>Duration<br>Fees<br>City<br>DOB<br>REGISTRATION<br>FK CourselD<br>FK Studid<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 Number(4) Varchar2(20) Varchar2(20) Varchar2(20) Varchar2(20) Date PK courseid CourseName number(4) varchar2(20) number(2) number(7,2) Duration Fees City DOB REGISTRATION FK CourselD FK Studid 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