Answer to Question #294166 in Databases | SQL | Oracle | MS Access for Anuj

Question

Ques- create a SQL query .....on

Table : STUDENT

Admno 101 , 102 , 103 , 104 & 105

Name

Ayushi

heena

Jitender

meena

Marks

52, 95 , 89 , 65 ,98

1) Write a create table query

2) To displey al details of all students.

3) To dsplay al details in descending order of marks.

4) To display admno and name of all students whose name starts with 'A.

4 To display the maximum and minimum marks from the table students

5) To dsplay al details of students whose marks are between 80 to 95 inclusive

Answer 1

Dear msms, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: