contestada

Create a list of student names from area code 203 along with the number of years since they registered (show 2 decimal places on all values).
Sort the list on the number of years from highest to lowest and then on student name.
NOTE that the calculated number of years will vary from the expected results depending on when the query is run.

Respuesta :

zahidahmadkhantanoli

Answer:

Answer is provided in the explanation section

Explanation:

1. For testing this query, first create a table:

CREATE TABLE STUDENT (NAME CHARACTER(25), ROLLNO int PRIMARY KEY, AREACODE int, REGD_YEAR date)  

2. Insert some data for checking the query

 insert into student values(101,'Mark',203,'03-12-1997')  

            insert into student values(106,'Zack',204,'06-18-1992')

 insert into student values(104,'Jess',203,'01-11-1995')

3. Select query for creating a list of student names from area code 203

SELECT NAME AS "Student Name", AREACODE, REGD_YEAR

FROM STUDENT

WHERE AREACODE LIKE '203%'

ORDER BY “REGD_YEAR“,”Student Name”;

Otras preguntas