Write a query to display student ID, First name and age. Sort the result based on student ID. [Note : Age can be calculated using DOB and give alias name as age] STUDENT COURSE Number(4) Varchar2(20)...

Write a query to display student ID, First name and age. Sort the result based on student ID.<br>[Note : Age can be calculated using DOB and give alias name as age]<br>STUDENT<br>COURSE<br>Number(4)<br>Varchar2(20)<br>Varchar2(20)<br>PK<br>Studld<br>PK courseid<br>number(4)<br>varchar2(20)<br>number(2)<br>number(7,2)<br>FirstName<br>LastName<br>Street<br>City<br>CourseName<br>Duration<br>Varchar2(20)<br>Fees<br>Varchar2(20)<br>DOB<br>Date<br>REGISTRATION<br>PK-Primary key<br>FK-Foreign key<br>FK<br>CourselD<br>number(4)<br>FK Studld<br>number(4)<br>DOJ<br>Date<br>

Extracted text: Write a query to display student ID, First name and age. Sort the result based on student ID. [Note : Age can be calculated using DOB and give alias name as age] STUDENT COURSE Number(4) Varchar2(20) Varchar2(20) PK Studld PK courseid number(4) varchar2(20) number(2) number(7,2) FirstName LastName Street City CourseName Duration Varchar2(20) Fees Varchar2(20) DOB Date REGISTRATION PK-Primary key FK-Foreign key FK CourselD number(4) FK Studld number(4) DOJ Date

Jun 05, 2022

SOLUTION.PDF

Write a query to display student ID, First name and age. Sort the result based on student ID. [Note : Age can be calculated using DOB and give alias name as age] STUDENT COURSE Number(4) Varchar2(20)...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment